Unable to connect to Microsoft SQL Database from AEM Sandbox --connection timed out error

[Divya_13]

Hi,

We are connecting to MS SQL Database from AEM sandbox(using AaaCS). In order to successfully establish connection between AEM and DB , we have whitelisted AEM public IP address on Azure . We are getting below error even after whitelisting.

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host {projectname}.database.windows.net, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."

Is there anything that we are missing here. Please help.

Thanks,

Divya

[Harwinder-singh]

@Divya_13  Check this out - 

https://stackoverflow.com/questions/33590030/the-tcp-ip-connection-to-the-host-localhost-port-1433-h...

[durga_kavali]

@Harwinder-singh  

we are facing similar issue in my project and ours is sandbox program.

Could you please confirm if we can connect to database or external services from a sandbox program since our project  is hosted in a sandbox environment?

Thanks,

Durga.

[durga_kavali]

@aanchal-sikka @arunpatidar @Mahedi_Sabuj @sherinregi  any idea if we can connect to external services or  database(azure) from aem sandbox program ? please suggest

Thanks,

Durga Kavali.

[Divya_13]

@Harwinder-singh 

I've raised an Adobe support ticket regarding this issue, and they have confirmed that we cannot connect to database from Sandbox programs.The port 1433 is not reachable from within the sandboxes and cannot have advanced networking . We can only connect to port 80 and 443 .

https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/using-...

Thank you for your input.

[ssinghai]

Hi,

I am trying to connect to azure cosmos db server on port 443, but still facing issues connecting from AEM. Any idea on this?

[Divya_13]

Are you using the Sandbox program, which is meant to be used for training and demos? Are you able to connect to the database from your local instance?

[ssinghai]

No Divya, actually I am trying to connect to Azure Cosmos DB from my local AEM cloud sdk, but not able to connect.

Getting this exception when trying to create the client for connection

java.lang.RuntimeException: Client initialization failed. Check if the endpoint is reachable and if your auth token is valid. More info: https://aka.ms/cosmosdb-tsg-service-unavailable-java

Getting no lead on this.  

[Divya_13]

Please check if the endpoint or key is correct, and the error you mentioned occurs if there is a firewall rule blocking the requests. Can you please check if that's the case?

https://learn.microsoft.com/en-us/azure/cosmos-db/nosql/troubleshoot-java-sdk-service-unavailable