Applicable to:
- Plesk for Windows
Question
How to enable remote connections to MS SQL server?
Answer
-
Connect to the server via RDP.
-
Press the Start button, go to Microsoft SQL Server XXXX (where XXXX is the MSSQL version) and click the SQL Server XXX Configuration Manager.
-
Open the SQL Server Configuration Manager (Local) > SQL Server Network Configuration menu and click the Protocols for MSSQLSERVERXXXX (where XXXX is the MSSQL version).
-
Make sure that the TCP/IP protocol has the Enabled status:
-
Double-click the TCP/IP protocol, go to the IP Addresses tab and scroll down to the IPAll section.
-
Specify the 1433 in the TCP Port field (or another port if 1433 is used by another MSSQL Server) and press the OK button:
Note: the specified port, e.g, 1433, must be opened in the firewall.
-
Go to SQL Server Configuration Manager (Local) > SQL Server Services, right-click the SQL Server (MSSQLSERVER) service and press the Restart button to apply made changes:
- Go to Plesk > Tools&Settings > Databases > MSSQLSERVER > Settings and click OK to reset cached connection settings.
Comments
2 comments
I'd just like to make a correction here. The simplest way to restart the service is not to switch programs. You can do it from within SQL Server Configuration Manager; just select 'SQL Server Services' from the left-most pane, then right-click the service you need to restart, and click 'Restart'. No need to go find another program (Services), locate the service in a huge list and go through its menu options to restart it.
Hello @Jason, thank you for notice.
The article will be reviewed soon.
Please sign in to leave a comment.