To use dynamic ports

  1. Start the SQL Server Configuration Manager (Start > All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager.
  2. Expand SQL Server Network Configuration and select Protocols for yourSQLServerInstance.
  3. Select TCP/IP (enable it if it is not currently enabled) and click on the IP Addresses tab.
  4. Scroll to the bottom to IPAII and set the following values for ports:

    For the TCPIP Dynamic Ports, set the value to 0.

    For the TCPIP Static Port, set the value to blank.

  5. Start the SQL Server Browser service (Start > All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager and then select SQL Server Services and start the SQL Server Browser service.)
  6. Restart the SQL Server instance.
  7. Open the %LARUNDIR%\dataarea\db.cfg in a text editor.
  8. Set the PORT parameter to 0, or simply remove or comment out the PORT parameter.
  9. Set the DBSERVER parameter to the name of the SQL Server instance.