ASP SQL connection string to Windows Server 2022 Datacenter Azure Edition

Question

I have an ASP website residing on a Windows Server 2022 Datacenter Azure Edition. The website is linked to a SQL database on the same server. When trying to log in, the connection fails with message "Exception:Thrown: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)" (System.Data.SqlClient.SqlException)".

The following connection worked during initial testing but has since stopped working.

*

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

Did you enabled the remote access for your SQL Server?

https://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-quickstart?view=azuresql&tabs=visual-studio%2Cpasswordless%2Cservice-connector%2Cportal#configure-the-database

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **

Answer 2

Hi @Product Support,

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)" (System.Data.SqlClient.SqlException)

It is a general issue, you may follow the official documentation to troubleshoot.

A network-related or instance-specific error occurred while establishing a connection to SQL Server

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.