Unable to connect to Microsoft SQL Database from AEM Sandbox --connection timed out error | Community
Skip to main content
D
Divya_13
Level 2
August 28, 2023

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

  • August 28, 2023
  • 1 reply
  • 2693 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Harwinder-singh
Community Advisor
Harwinder-singhCommunity Advisor
Community Advisor
August 28, 2023

@divya_13  Check this out - 

https://stackoverflow.com/questions/33590030/the-tcp-ip-connection-to-the-host-localhost-port-1433-has-failed-error-need-as

 

    D
    Divya_13Author
    Level 2
    September 22, 2023

    @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-cloud-manager/programs/introduction-sandbox-programs.html?lang=en#limitations

     

    Thank you for your input.

    S
    ssinghai
    Level 2
    November 6, 2023

    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?


    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.  

    Terms & ConditionsAccessibility statement

    Loading footer...