Applicable to:
- Plesk for Windows
Question
How to enable remote connections to MS SQL server?
Answer
-
Connect to the server via RDP.
-
Run SQL Server Configuration Manager.
-
Open the SQL Server Configuration Manager (Local) > SQL Server Network Configuration menu, click the required Protocols for MSSQLSERVER and make sure that the TCP/IP protocol has the Enabled status:
-
Double-click the TCP/IP protocol, go to the IP Addresses tab, 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:
-
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:
Note: port 1433 must be opened in the firewall.
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.