Unable to execute simple query in azure sql server

Question

I am using azure sql server for .net applications, now I am unable to open functions, stored procedures and even unable to run simple queries in azure sql server in SSMS and in Azure portal also.

Answer 1

Hi Solipeta Bhandavi,

Welcome to Microsoft Q&A forum.

As I understand, you are getting Timeout error when connecting to Azure SQL Database.

1. Make sure that TCP/IP is enabled as a client protocol on the application server. For more information, see Configure client protocols. On application servers where you don't have SQL tools installed, verify that TCP/IP is enabled by running cliconfg.exe (SQL Server Client Network utility).
2. Check the application's connection string to make sure it's configured correctly. For example, make sure that the connection string specifies the correct port (1433) and fully qualified server name. See Get connection information.
3. Try increasing the connection timeout value. We recommend using a connection timeout of at least 30 seconds.
4. Test the connectivity between the application server and the Azure SQL Database by using SQL Server Management Studio (SSMS), a UDL file, ping, or telnet. For more information, see Troubleshooting connectivity issues and Diagnostics for connectivity issues.

Note

As a troubleshooting step, you can also test connectivity on a different client computer.

1. As a best practice, make sure that the retry logic is in place. For more information about retry logic, see Troubleshoot transient faults and connection errors to SQL Database.

If these steps don't resolve your problem, I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.

Thanks