SQL Azure : Connection to SQL Azure throws exception

Question

When I connect to SQL Azure from my code, I get the following error.. I am able to connect to SQL Azure from SQL Server Management Studio successfully.

System.Data.SqlClient.SqlException: 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 requested name is valid, but no data of the requested type was found.)

I also tried connecting using sqlCMD and that connects without any issue. Only issue arises is during runtime when I get this exception.

Answer 1

You might also want to check to make sure your firewall allows outbound connections on port 1433.

Answer 2

There can be numerous reasons for this failure, I am listing out the scenarios and the options that needs to be allowed on the server.

1. If you are connecting an Azure SQL Instance using Sql server management studio while inside you company's network/firewall, first of all you will need to check if your company's firewall rules allow that or not.

2. On the AZURE SQL Server, make sure your IP address is in the allowed list.