Versions Compared

Old Version 2

changes.mady.by.user Nadja Pollard

Saved on

compared with

New Version 3

changes.mady.by.user Nadja Pollard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Start the Windows Registry Editor.
  2. In Registry Editor, locate the following registry key:
    Code Block
    languagesql
    HKEY_LOCAL_MACHINESOFTWAREMicrosoft
Microsoft SQL Server 
MSSQLServerSuperSocketNetLibTcp

    The TCPDynamicPorts and TCPPort values appear as follows, depending on your port allocation method:

...

    • Static Port Allocation
      If you configure an instance of SQL Server to use a static port, and you have not yet restarted the SQL Server instance, the registry values are set as follows:
      • TCPDynamicPorts = Last port used
      • TCPPort = New static port that you set by using the Server Network Utility.

If you configure an instance of SQL Server to use a static port, and you restart the SQL Server instance, the registry values are set as:

      • TCPDynamicPorts = Blank
      • TCPPort = New static port that you set by using the Server Network Utility.

...

    • Dynamic Port Allocation
      If you configure an instance of SQL Server to use dynamic port allocation, and you have not yet restarted the SQL Server instance, the registry values are set as follows:
      • TCPDynamicPorts = Blank
      • TCPPort = 0

However, if you configure an instance of SQL Server to use dynamic port allocation, and you restart the SQL Server instance, the registry values are set as follows:

      • TCPDynamicPorts = Current port used
      • TCPPort = Current port used