Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.

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.

1 Reply

Avatar

Level 3

Hi,

 

We are facing same issue, Have you got any solution on this?