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