No announcement yet.

How to change the default SQL port?


Unconfigured Ad Widget

  • Filter
  • Time
  • Show
Clear All
new posts

  • How to change the default SQL port?

    How to change the default SQL port?
    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.