Could not connect azure sql db from ssms

Question

Couldnt connect live SQL db

TITLE: Connect to Server

---

Cannot connect to dbowemp.database.windows.net.

---

ADDITIONAL INFORMATION:

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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10060-database-engine-error

---

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

---

BUTTONS:

OK

---

Answer 1

Hi,

I have just tried some connectivity tests in my computer, and all looks good towards your sql server IP and instance name. Please ty the following commands from a command window in your computer and try if all works and getting connected well from your end too

ping dbowemp.database.windows.net

ping 20.61.99.197

telnet 20.61.99.197 1433

telnet dbowemp.database.windows.net 1433

If it is not working from your computer, check the windows firewall rules in your computer and see if it blocks the connection/port

Hope this helps.

---

--please don't forget to upvote and Accept as answer if the reply is helpful--