CODEWITHSUNDEEP
sql-serverazure
Ahmed Mujtaba
Ahmed Mujtaba

Reputation: 2248

Connection to SQL Server fails

I get the following error when I try to connect to my Azure SQL Server with SSMS

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 get this error when I attempt to connect with my new host provider. With my old hosting provider, I didn't have this issue. I have tried every possible solution on the internet but nothing works.

I have allowed my IP the access by adding it to the list of allowed IPs in the Azure portal. Can someone help me figure out why I can access the server with one host provider but not with the other?

Upvotes: 0

Views: 1771

Answers (1)

qin
qin

Reputation: 1713

You must have a internet access.
It seems that you just can't connect to the server.

You must add your public IPv4 Address in Azure firewall list.
Note: Some ISP will use NAT, so your public IP connect to DB may be difference from your public IP connect to Azure Portal.

Upvotes: 1

Related Questions