Applicable to:
- Plesk for Windows
Question
How to enable remote connections to MS SQL server?
Answer
- Log in to Plesk server using RDP.
-
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 or other port if 1433 is used by another MS SQL Server:
-
Restart MS SQL server. The simplest way is to open Control Panel > Administrative Tools > Services and restart it:
Note: port 1433 must be opened in firewall.
Comments
0 comments
Please sign in to leave a comment.