Cannot connect to xxxxxxxxxx.database.windows.net

Question

_{Monday, March 16, 2015 2:31 PM}

I'm using Visual Studio Express 2013 for Web Update 4. Created a database through MSFT Azure using the tutorials. When I select the SQL Database and select OPEN IN VISUAL STUDIO, SQL Server 2014 opens up but I get an error message Cannot connect to xxxxxxxxxxx.database.windows.net. A network-related or instance-specific error occurred......The Server was not found or was not accessible. Error 53. Using the trial Azure and trial VS 2013. 

Any help would be appreciated. Thanks

All replies (8)

_{Tuesday, March 17, 2015 3:48 PM ✅Answered}

Hi,

Are you not being able to open the server connection due to firewall settings of your organization ?

Cannot open server '<Server name>' requested by the login. Client with IP address '<IP>' is not allowed to access the server.  To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range.  It may take up to five minutes for this change to take effect.

Regards,

Shirisha Paderu

_{Tuesday, March 17, 2015 5:01 PM ✅Answered}

Hi,

I am not sure if this works on a company network. Try and let us know the results.

- go to dnstools.com and resolve the virtual name <your server>.database.windows.net

- use the resolved Ip address in SMSS like this:

             - Server name: <IP address>

             - Login: <user name>@<your server>

             - in the Options>>Connection Properties, change the Network protocol to TCP/IP

Hope this helps you.

Girish Prajwal

_{Tuesday, March 24, 2015 5:02 PM ✅Answered}

Hi. Yes, definitely a company firewall issue. I have created an Azure VM with all my development software loaded and do my development off of the Azure VM. Connection to the Azure DB is fine now. 

_{Monday, March 16, 2015 3:28 PM}

Hi Jeff,

Did you add your IP to the database's firewall? Or maybe your Internet provider provided a new IP address that not in white list.

You can follow this guide to add a new IP rule in database's firewall : https://msdn.microsoft.com/en-us/library/azure/jj553530.aspx 

1. From the Management Portal, click SQL Databases. All databases and their corresponding servers are listed here.

2. Click Servers at the top of the page.

3. Click the arrow beside the server for which you want to manage firewall rules.

4. Click Configure at the top of the page.

   • To add the current computer, click Add to the Allowed IP Addresses.
   • To add additional IP addresses, type in the Rule Name, Start IP Address, and End IP Address. 
   • To modify an existing rule, click any of the fields in the rule and modify.
   • To delete an existing rule, hover over the rule until the X appears at the end of the row. Click X to remove the rule.

5. Click Save at the bottom of the page to save the changes.

_{Monday, March 16, 2015 3:34 PM}

Hi,

We get these error messages when the connection to Azure SQL Database fails. The connection problems can be caused by the firewall settings, connection time-out, or incorrect login information. Additionally, if the maximum limit on some Azure SQL Database resources is reached, you cannot connect to Azure SQL Database.

As per the error message, the possible causes could be your trial versions are expired or you don't have access ( or ) some system-specific issue such as an outage or some component failure. Therefore, you may eventually have to open a support case.            

              To find more information about these errors, try these methods:            

•                 Check the Microsoft Azure Service Dashboard for any known outages.              

•                 Test the connectivity by using ping and telnet. For more information about how to do this, see Troubleshooting SQL Server Connectivity Issues and Azure SQL Database connectivity troubleshooting guide.                

  Note As a troubleshooting step, try to test the connectivity on a different client computer. Check whether you can log on by using SQL Server Management Studio and also the Azure portal:

Hope this helps.

Regards,

Shirisha Paderu

_{Monday, March 16, 2015 4:39 PM}

Yes, I've added the IP address to the database firewall already. Thanks.

_{Monday, March 16, 2015 5:47 PM}

Thanks for the links. Turns out my company's firewall is stopping me from accessing my Azure sql db. Any tips to get around this? Should I be creating a VM in Azure and loading VS2013 or using VS Online in Azure? When I downloaded VS Express 2013 for web it loaded on to my laptop....to get around the company's firewall, I think all of this development needs to be done in my Azure development area. 

_{Thursday, March 19, 2015 2:45 PM}

Hi,

Any update on this issue. Please let us know if the issue is resolved.

Girish Prajwal