2016-11-16 13:18:00 UTC
2017-08-16 17:06:40 UTCApplicable to:
- Plesk for Windows
Question
How to enable remote connections to MS SQL server?
Answer
-
Run SQL Server Configuration Manager.
-
Go to SQL Server Network Configuration > Protocols for MSSQLSERVER .
-
Make sure that TCP/IP protocol is enabled.
-
Right click on TCP/IP > Properties > IP Addresses tab.
-
Go to IPAll section and specify "1433" TCP Port:
-
Restart MS SQL server. The simplest way is to open Control Panel > Administrative Tools > Services and restart it:
