Question:
The below error appears while adding a new location in Azure SQL Database and test connection:
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 6.1
- Source Sql Server
- Target Azure Sql Server
Answer
Please follow the steps below:
- Uncheck the test connection before confirming
- Click Confirm Connection Details.
- On the source in Action Environment enter value below.
Name: HVR_ODBC_CONNECT_STRING_ADD
Value: Encrypt=YES;TrustServerCertificate=YES - Test the connection again.
Cause
The Environment variable is required to make a correct connection.