Saturday, February 18, 2012

Configuring SQL Server to listen on alternative Port

If you need SQL Server to listen on some alternative port or to share additional port for remote access, please follow these directions:

1) Login to your server using Terminal Services Client
2) Go to Start -> Programs -> SQL Server -> Server Network Utility
3) Under Enabled Protocols, select TCP/IP and go to properties
4) In the default port field, enter “1433, 2512” without the quotes. This will force SQL Server to listen on both port 1433 and 2512. 
If you would like to have SQL listen on a different port, simply enter additional port numbers in a comma delimited format.
5) Now restart the SQL Server service so that it can rebind it’s network connections.

No comments:

Post a Comment