Save 15% on Instant Deploy Bare-Metal Servers in 26 Global Markets with Coupon Code: EdgeSave

Change the TCP port of SQL Server

The default SQL Server port of 1433 is blocked at our border routers for security purposes. Therefore, the port that SQL Server runs on will need to be changed if you would like to connect to it remotely. Be advised, however, that if you do so, you leave yourself open to other remote connections as well. Do so at your own risk.

1. You can do this by opening the Server Network Utility. (Start -> Programs -> Microsoft SQL Server -> Server Network Utility).

2. On the General tab, make sure TCP/IP is highlighted, and click Properties.

3. Type in the port number you wish to use.

4. Restart the SQL Server service.

Share on Twitter
Share on Facebook