TechBubbles Microsoft Technology BLOG

Connection issue with SQL Azure

Today, I got the following error message when connecting to SQL Azure from our dev environment

clip_image001

Don’t panic follow the below trouble shooting steps.

1. Check your Microsoft Azure portal firewall settings. You should add your client ip address range as following

image

2. If you still get the same error message then double check the way that your are connecting to server using client tool example: if you use SQL Server Management Studio then make sure you follow the pattern in following screenshot

clip_image005

Make sure you enter login as <username>@<servername>. Username is your sqlserver admin user and server name is first part in <server_name>.database.windows.net.

3. If you still can’t connect to the server then most likely it is with your network, you can determine this by going to the command prompt and type ping <server_name>.database.windows.net

clip_image007

4. Take the ip address from output and type telnet <ipaddress> 1433 if you get telnet command not found then go to control panel à Programs and go to turn windows features on\off check the telnet feature

5. If this command successful then window will change to complete blank screen if not then it is definitely with your network. Your network proxy not allowing this connect remote server on this port.

6. Alternatively you can also check the audilog and activity log on azure portal

image

 

7. If you still can’t resolve the issue then contact @AzureSupport, they are nice people who can put you in right direction.

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

Add Comment

By Kalyan Bandarupalli
TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud