Expand my Community achievements bar.

Enhance your AEM Assets & Boost Your Development: [AEM Gems | June 19, 2024] Improving the Developer Experience with New APIs and Events

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?