Not able to connect from my Local Visual Studio 2022 to Azure SQL Server

Question

Azure provided this connection string for ADO.NET:

Server=tcp:jeanjhskyblue.database.windows.net,1433;Initial Catalog=MEDISEABLUE;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication="Active Directory Default";

when connecting from SSMS, i am getting this error: SQL Server was not found and not accessible, Microsoft SQL server Error 10060

see attached image

Thanks, Jean Haidar jhhaidar@att.net

Answer 1

Hi @ Jihan Haidar,

Thanks for the question and using MS Q&A platform.

It seems like you are having trouble connecting to your Azure SQL Server from Visual Studio 2022. The error message you are seeing indicates that the SQL Server instance is not reachable.

Here are some steps you can try to resolve this issue:

1. Check that you have entered the correct server name and port number in the connection string. Make sure that there are no typos or errors in the connection string.
2. Ensure that your computer is connected to the internet and that there are no network connectivity issues.

3)Check that your firewall settings are not blocking the connection. You may need to add an exception to your firewall to allow incoming connections to the SQL Server port.

4)Try connecting to the SQL Server from another machine to see if the issue is specific to your computer.

5)Check that the SQL Server instance is running and is accessible from your network.

6)Confirm that your login credentials and authentication method are correct.

For Additional Information, please refer to this document: Troubleshoot connectivity issues to Azure SQL.

Hope this helps. Do let us know if you have any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.