Cannot connect to Azure SQL server

Question

Cannot connect to Azure SQL server

KH2437 0

This morning, we were unable to connect to two of our azure sql servers (UAT and Prod) from an on prem VM, yet we could connect to our 3rd server (DEV). UAT and DEV are on the same subscription in Azure while prod is on a separate sub. Access is restricted to the same set of IP addresses for all, yet when we try to connect via SSMS or directly on the portal through Query editor (preview), it is gives the same error!

Connecting with User's image

User's image

We've checked with our network team and they said 1433 is not being blocked on the permitter firewall. However, we get the following failure only from this VM. What we can't figure out is why it works for DEV and not for UAT. The remote IP is different but we don't have any rule for these IP addresses in our internal firewalls. Also, these remote IP addresses appear to change and belong to a gateway I think

User's image

This happened with what believe were no changes put through on the client side. Does anyone have any ideas on how we could trouble shoot this down?

Thanks in advance for any help.

1 answer

Your answer

Answer 1

Erland Sommarskog 121.4K MVP Volunteer Moderator

Some googling on the essential part, An attempt to access a socket in a way forbidden by its access permissions, suggest that this is a general networking error caused by some sort of conflict with another program. That is, it is a issue within the VM. In the StackOverflow thread https://stackoverflow.com/questions/10461257/an-attempt-was-made-to-access-a-socket-in-a-way-forbidden-by-its-access-permissi there are several suggestions of things to try.

KH2437 0 Reputation points

2025-06-17T23:57:48.1233333+00:00

Thanks @Erland Sommarskog , I had a look at that thread and tried to see if any other program was using 1433 but there were none. Also, SSMS, can connect to the DEV server on 1433 albeit to a different remote IP address. Could the Azure be blocking my IP address on the UAT and PROD remote ip addresses?
Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator

2025-06-18T20:21:54.4766667+00:00

Hm, port 1433 is the port on the remote server. The local port is something else. And this is where the conflict would be.

Did you try to simply reboot the VM?

Also, check the etc\hosts file so that there is not address set up for the Azure server there.
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator

2025-06-19T20:21:34.7366667+00:00

HI KH2437

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sai Raghunadh M 4,300 Reputation points Microsoft External Staff Moderator

2025-06-20T19:20:00.4+00:00

HI KH2437

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Cannot connect to Azure SQL server

1 answer

Your answer