Change the external Microsoft SQL Server database

If the SecureTransport Server uses an external Microsoft SQL Server database and any of the database settings change, you must change the corresponding settings in the Administration Tool.

  1. Log on to the SecureTransport Administration Tool as user dbsetup.
  2. Select Setup > Database Settings.
  3. The Database Setting page is displayed with the external database settings under Enterprise Clustering - Microsoft SQL Server External Database.
  4. Type the values necessary to connect to the new external database:
    • Host – The FQDN or IP address of the Microsoft SQL Server system
    • Port – The number of the port used to access the server, 1433 is the default
    • User Name – The name of the user authorized to connect to the database
    • Password – The password for the user, not displayed
    • Database Name – Used to connect to the Microsoft SQL Server.
    • Use secure connection – When Use secure connection is checked, the connection between SecureTransport and the database server will be encrypted. If Use secure connection is checked, the following option should be configured:
      • Server Certificate CN (optional) – If specified, SecureTransport will match the specified value with the database server certificate CN. If it is not specified, SecureTransport will match the host name with the database server certificate CN. If neither of them is matched, the connection will fail.
      • TrustStore File Path – Browse and select the TrustStore file to import the trusted certificates.
    • Use Custom JDBC URL – Unchecked by default. When checked, you can specify a custom connection string for SecureTransport to use to connect to a Microsoft SQL Server database. In the URL, specify the host, port, database name, user name and password or use the available placeholders. You can include additional connection properties to define specific behavior, for example, a connection via SSL. If the custom JDBC URL connects to your database using SSL, make sure the Use secure connection checkbox is selected.
      The exact syntax of a JDBC URL is specified by your DBMS.

      #Example

      To specify an encrypted connection to mirror SQL instances by using a username and password:

      jdbc:sqlserver://${host}:${port};databaseName=${databaseName};user=${user};password=${password};encrypt=${encrypt};trustStore=${trustStorePath};trustStorePassword=${trustStorePassword};hostNameInCertificate=${hostNameInCertificate};failoverPartner=${failoverHost};

      The option to specify a custom JDBC URL is also exposed as a REST API resource.
    • NoteWhen specified, the custom JDBC configuration is kept on patch revert.
  5. Click Test Connection to SQL Server Database.
  6. If SecureTransport displays a failure message, correct the network, database, or other error reported and try again.
  7. Click Save.
Note You can retrieve and update an existing Microsoft SQL Server database configuration, and test the connection to the database using the respective Admin REST API resource:  /configurations/database/mssql .

Related topics:

Related Links