SQL Server 2000

To configure your instance of SQL Server to use a dynamic port, follow these steps:

  1. 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 clickServer Network Utility.
    • Click Start, and then click Run. In the Open box, type svrnetcn.exe, and then click OK.

    The Server Network Utility dialog box appears.

  2. In the Server Network Utility dialog box, click the General tab.
  3. In the Instance(s) on this server list, select your instance of SQL Server.

    Note If TCP/IP protocol is disabled, enable it now. To do this, click TCP/IP in theDisabled Protocols list, and then click Enable.
  4. In the Enabled Protocols list, click TCP/IP, and then click Properties.
  5. In the Default port box, type 0, and then click OK.
  6. Click OK, and then click OK again.
  7. Restart the instance of SQL Server.
  8. View the SQL Server error logs to verify that the instance of SQL Server is currently using the dynamic port.

    Note If you have a clustered instance of SQL Server, and you follow the specified steps on a cluster node, you may notice that the TCPDynamicPorts registry values and the TCPPort registry values on other cluster nodes still hold the old values. When you move the SQL Server group to the corresponding cluster node, and then bring SQL Server online on the cluster node, the registry values on the cluster nodes will reflect the correct values.

Post By Editor (2,827 Posts)

Website: →