Changing the default port for contacting the database in DB Setup or application server

Changing the default port for contacting the database in Database Setup or Application Server 

Procedure Steps


The default port for SQL Server is 1433, and this is what will be used when contacting the database in Database Setup or the Application Server. If this port is blocked and you want to use a different port, you must update the ConnectionString in your application.config file.
 
You must add the port into the Data Source area of the file. For example:
 
Data Source=SERVERNAME,1230;
 
Where SERVERNAME is your server name or IP address, followed by the port you want to use.

Note: If using enterprise, the region will attempt to contact the master database using 1433 during Database Setup. If this is incorrect, you can temporarily do the following:
  1. On the regional database, edit the LNL_DB Master entry.
  2. Set the Servername of the Master entry to SERVERNAME,1230.
  3. Rerun Database Setup.
  4. Afterwards, change these settings back to their original configuration.
Other settings specific to Oracle can be found at www.connectionstrings.com.

Applies To


OnGuard (All versions)
OnGuard Enterprise (All versions)
SQL Server (All versions) 

Additional Information