Home / server / Questions / 179705
In Process
Manjot
Asked: 2010-09-10 13:26:48 +0800 CST

sql 2000: static ports for multiple sql server 2000 instances on same server

  • 772

For multiple instances of SQL server 2000 servers on the same server, how can I set up to use static ports? I tried to search it on the Internet and i came across This article. If I use this article, how will assign port number for seperate instances?

Thanks in advance.

sql-server

1 Answers

  1. solved. One of my friends answered:

    Start the Server Network Utility. To do this, do one of the following: Click Start, point to Programs, point to Microsoft SQL Server, and then click Server Network Utility.

    In the Instance(s) on this server list, select your instance of SQL Server.

    In the Default port box, type a static port number, and then click OK.

    Note The static port that you specify must differ from the dynamic port that your instance of SQL Server is currently listening on. Restart the instance of SQL Server. From: This article

    • 1