Knowledgebase: Dedicated Server Guides
Configuring SQL Server to Listen on An Alternative Port
Posted by Jay Sudowski (Import) on 14 August 2004 12:36 AM
If you require SQL Server to listen on an alternative port for remote access, please follow these directions:
1) Login to your dedicated 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,1533" without the quotes.  This will force SQL Server to listen on both port 1433 and 1533.  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.

Making this change will in no way effect any existing SQL Server services.  You will not need to update or change any code, DSNs, or anything on the server.  However, you will need to reconfigure any EXTERNAL connections to utilize port 1533.   Any internal communications will continue to function on port 1433.
If you require assistance with this procedure, please open a ticket.
(1038 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).