Post reply

Listening on multiple ports

  • July 30, 2003 at 9:47 am

    #64971

    My company has mandated that new systems will be developed using different SQL Server ports. Can SQL Server listen on more than one port? How can I add ports?

    Any help is appreciated.

    - Greg

  • July 31, 2003 at 2:59 am

    #467903

    Hi there

    http://www.chriskempster.com/tipsandhints.html

    Run the server network utility GUI, select the appropriate instance. Highlight then enabled protocol (TCP/IP) and hit the properties button, for the default port enter your port numbers seperated by commas, for example: 1433,2433,2432, restart the instance for the changes to take affect and check your sql server logs. You will see something like:

    SQL server listening on 163.232.12.3:1433, 163.232.12.3:2433, 163.232.12.3:2432, 127.0.0.1:1433, 127.0.0.1:2433, 127.0.0.1:2432.

    SQL Server is ready for client connections

    Remember not to use 1434, which is a reserved UDP port for SQL Server.

    Cheers

    Ck

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply