Azure SQL database Connection issues

1
votes

I'm trying to access the Azure database through SSMS but I get this error:

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.) (Microsoft SQL Server, Error: 258)

I have allowed my network IP on the database server and it doesn't say anything about a new IP trying to gain access. The connection is sometimes established but most of the time I get that error. I couldn't find anything related to this error specific to Azure DB. Is there a way to fix it?

1
sql-serverazureazure-sql-database
This happened to me few times on slow internet connection and when i dont use my database say for a week – TheGameiswar
It's not an internet issue. I can access the database from my other computer just fine and my internet isn't that slow. It gotta be something to do with authentication on my computer. – Ahmed Mujtaba
can you retry this? Please set connection timeout sufficiently large (30 seconds) – Satya_MSFT
Is this error consistent? Please make sure you are following recommendations here: azure.microsoft.com/en-us/documentation/articles/… – MihaelaBlendea

1 Answers

1
votes

Here are the recommended best practices for connecting to SQL Azure:

Client Drivers

  1. Recommended to get the latest version

Security and Firewall Rules

  1. Turn on encryption
  2. Turn off trust server certificate
  3. Open port #1433 and #1100-114999

Managing Connections

  1. 30s Connection timeout (SqlClient uses 15s as the default connection timeout)
  2. Explicitly specify tcp protocol (SQL DB supports only tcp
  3. Use connection pool