To use static ports

Note: 

The use of static ports is not supported with DataDirect's jdbc driver unless the instance name is serverName\localhost or localhost.

  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 blank.

    For the TCPIP Static Port, set the value to your desired port number.

  5. Restart the SQL Server instance.
  6. Open the %LARUNDIR%\dataarea\db.cfg in a text editor.
  7. Set the PORT parameter to the same static port number you entered in the SQL Server configuration.
  8. Set the DBSERVER parameter to localhost or the name of the server.