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 Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments

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