Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

AEM_PROXY_HOST to connect jdbc SQL SERVER

Avatar

Level 2

Hi, 

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".

 

Captura de tela 2022-09-20 101836.png

 

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"".

 

Can anyone help me with this?

 

Thanks, friends.

0 Replies