Configure default database port

Configure and enable the TCP/IP in the SQL database server to use the default port 1433 when you install the Control Room.

Enable TCP/IP from the Microsoft SQL Server Configuration Manager.

Transparent Data Encryption (TDE) is a function of Microsoft SQL Server database. Additional configurations are not required on the Control Room as the TDE supportability is managed by Microsoft. For more information, see Transparent data encryption (TDE) and Transparent data encryption for SQL Database.

Procedure

  1. Ensure the SQL Server Browser service is running in the Task Manager.
  2. To set the default port for the SQL database server, launch the Microsoft SQL Server Configuration Manager.
  3. Select SQL Server Network Configuration > Protocols for <SQL server instance>.
  4. Right-click Protocols for <SQL server instance> and select Open to show the available protocols.
  5. Ensure TCP/IP is enabled.
  6. Right-click TCP/IP and select Properties.
    You can configure the default port for the SQL database from the TCP/IP Properties window that is displayed.
  7. Select the IP Addresses tab to update the default TCP Port to 1433 in the IPAll node.
    If provided, clear the value shown in the TCP Dynamic Ports field.
  8. Click OK to confirm and exit the window.
  9. Select the SQL Server Services option to Restart the SQL Server <instance name>.
    The SQL database server is now configured and enabled to use the default port in the Control Room.