How to enable remote connections to MS SQL server?

Created:

2016-11-16 13:18:00 UTC

Modified:

2017-08-16 17:06:40 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to enable remote connections to MS SQL server?

Applicable to:

  • Plesk for Windows

Question

How to enable remote connections to MS SQL server?

Answer

  1. Run SQL Server Configuration Manager.

  2. Go to SQL Server Network Configuration > Protocols for MSSQLSERVER .

  3. Make sure that TCP/IP protocol is enabled.

  4. Right click on TCP/IP > Properties > IP Addresses tab.

  5. Go to IPAll section and specify "1433" TCP Port:

  6. Restart MS SQL server. The simplest way is to open Control Panel > Administrative Tools > Services and restart it:

Have more questions? Submit a request
Please sign in to leave a comment.