Enable Remote Connection in MS SQL Server

MS SQL Server does not allow remote connection by default. To enable MS SQL remote connection, you need to open port 1433 in the firewall. After the port is open, you need to enable TCP/IP protocol in MS SQL Server.

Start SQL Server Management Studio, take the property of the server

Enable SQL Server and Windows Authentication mode

SQL server autentication

Under Connections, allow Allow Remote Connections

SQL Server allow remote connection

Start SQL Configuration Manager.

Start SQL Configuration Manager

Go to

SQL Configuration Manager > SQL Server Network Configuration > Protocols for MSSQL SERVER

Enable TCP/IP

MS SQL enable TCP/IP

Now you need to restart MS SQL server, after that, you should be able to connect to MS SQL server remotely.

Need help with Linux Server or WordPress? We can help!

Leave a Reply

Your email address will not be published. Required fields are marked *