azure sql connectivity from local sql server

Question

I am working with azure based application. In which, I need to get connected with azure sql server. I had already configured firewall setting on azure portal for my IP address. But still even when I tried to get connected to azure sql server, it never gets connect at the very first time. When I try to connect it more than two times then it gets connected.

This problem is also with application level connectivity, when i try to run the application on visual studio same happens.

I had researched a lot regarding this specific problem but didn't get any solution yet. I always get network related error Error Code : 53.

Any help will be appreciated.

What are you using to connect to the server? Your App or locally hosted SQL Server? What is throwing the error? — Dan Rediske, Nov 22 '16 at 17:17
@DanRediske-MSFT I am getting network related error with local sql server management studio at first time then it gets connected. Same happens when i try to do with visual studio IDE. — techV, Nov 23 '16 at 05:42

score 0 · Answer 1 · answered Aug 10 '17 at 19:01

This looks a lot like a local network issue.

When your application is deployed onto an Azure resource (App service, VM, etc.) does it get a similar connection error?

Every Azure SQL Server has a firewall, you need to create a client IP rule but also to allow access to the Azure service.

azure sql connectivity from local sql server

1 Answers1