Configure the App Volumes Manager to communicate with the SQL server using TLS 1.2 protocol.

Prerequisites

  1. Ensure that the SQL server version you have installed supports TLS 1.2. If it does not support TLS 1.2, install the patch for TLS 1.2 or upgrade to latest service pack which supports TLS 1.2. See https://support.microsoft.com/en-in/help/3135244/tls-1-2-support-for-microsoft-sql-server.

  2. Refer to the Microsoft documentation for encryption and certificate validation settings.

  3. Download and install the ODBC driver msodbcsql_17.2.0.1_x64.msi or the latest driver on the machine where the App Volumes Manager is installed.

Procedure

  1. Open the ODBC Data Source Administrator (64-bit) setting. In the System DSN tab and rename the existing data source svmanager. Click Add.

  2. Select the new ODBC driver and click Finish. You must select the ODBC Driver 17 for SQL Server.

  3. Enter the name of the data source as svmanager.

  4. Enter the SQL server details and click Next.
  5. Select the appropriate authentication type and click Next.

  6. Select the Change the default database to option and select the appropriate database from the drop-down menu.

  7. Click Next.
  8. Verify the information and click Finish.

What to do next

  1. Click Test Data Source… to confirm that the settings are correct and the new driver can communicate with database.

  2. On success, a message TESTS COMPLETED SUCCESSFULLY is displayed.