I am implementing a jdbc connection with SQL Server and AEM as a Cloud. Searching for docs, i found any points and work on it, as:
- Create a dedicated ip, in CLOUD APÌ and set it to our firewell.
- Enable advanced networking and set the host and port of our database connection.
- Configure OSGI file in JDBC Pool Connection, with reserved environment variable "AEM_PROXY_HOST".
Have something else to do? Even doing all this, we have this error log:
Unable to create database query com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Failed to validate the server name "proxy.tunnel"in a certificate during Secure Sockets Layer (SSL) initialization. Name in certificate "*.sql.azuresynapse-dogfood.net"".