- Start the SQL Server Network Utility in SQL Server 2000. Select TCP, click Properties, and then enter the additional port separated by a comma; for example: 1433,5000.
- Stop and then restart the SQL Server server, and review the errorlog. Your errorlog should resemble the following:
SQL server listening on TCP, Shared Memory, Named Pipes.<BR/>
SQL server listening on 220.127.116.11:1433, 18.104.22.168:5000, 127.0.0.1:1433, 127.0.0.1:5000.
- Use the SQL Server Client Network Utility to modify your clients to spread the load accross the TCP ports. For example, two Web servers, both connecting to the same SQL Server on port 1433, can now split the load across 1433 and 5000. This allows the administrator to separate the traffic across multiple ports and increases the connection throughput.
Article ID: 294453 - Last Review: Jun 22, 2014 - Revision: 1