Troubleshoot connection problems to Azure SQL Database

I would like to share a KB article which provides the troubleshooting steps that you can follow when you cannot connect to Microsoft Azure SQL Database. This article also includes the best practices to prevent request denials or connection terminations when you connect to Azure SQL Database.

Symptoms

  • Cannot open server connection due to firewall settings
  • The server was not found or was not accessible
  • Unable to login to the server
  • Connection timeout errors
  • Transient errors
  • Connection Terminated due to hitting some system-defined limit
  • Connections failing from SQL Server Management Studio (SSMS)

You receive error messages when the connection to Azure SQL Database fails. The connection problems can be caused by the firewall settings, connection time-out, or incorrect login information. Additionally, if the maximum limit on some Azure SQL Database resources is reached, you cannot connect to Azure SQL Database. Follow the troubleshooter in the "Resolution" section to resolve the connection problems.

Troubleshoot connection problems to Azure SQL Database: http://support.microsoft.com/kb/2980233/en-

July 14th, 2014 5:22am

Says not available. 
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2015 10:40am

Seems to be working now. Can you please retry? Could have been a temporary glitch.

Thanks.
Ramu

August 24th, 2015 10:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics