Wednesday, July 29, 2015

How do we configure SQL Server Express to allow remote tcp/ip connections on port 1433?

How do we configure SQL Server Express to allow remote tcp/ip connections on port 1433?


  • Run SQL Server Configuration Manager.
  • Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
  • Make sure TCP/IP is enabled.
1.       Right-click on TCP/IP and select Properties.
2.       Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.
3.       Scroll down to IP All.
4.       Make sure that TCP Dynamic Ports is blank. (This is possible there can be  5-digit port number.)

5.       Make sure that TCP Port is set to 1433.

No comments:

Post a Comment