Error: F_JD21AE Unable To Connect to SQL Server Database

Issue

While adding a new location in an Azure SQL database and testing the connection, the following error appears:

F_JD21AE Unable to connect to SQL Server database 'pDim' on node '<node>-sqlserver-sql.database.windows.net,1433'. DBMS error [[Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:unable to get local issuer certificate]. [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection. [Microsoft][ODBC Driver 17 for SQL Server]Invalid connection string attribute]. DBMS error number [-1]. SQL State [08001]. DBMS version [unknown]. Last query [none].

F_JG0557 The previous error occurred during request [POST /latest/hubs/hvrhub/new_loc/test].

Environment

• HVR 5
• Source: SQL Server
• Target: Azure SQL Server

Resolution

To resolve this issue, do the following:

1. While viewing the connection details, uncheck the Test Connection checkbox.
2. Click Confirm Connection Details.
3. In the source, enter the following values for action Environment:
   Name: HVR\_ODBC\_CONNECT\_STRING\_ADD Value: Encrypt=YES;TrustServerCertificate=YES
4. Test the connection.

Cause

The Environment variable is required to make a valid connection.