FAQ - Azure

Question
Configure SQL management studio access to another IP
Answer

In SQL Management Studio you get the following messaage when trying to connect to an Azure Database:

 

"Cannot connect to mydbname.database.windows.net."

 

and

 

"Cannot open server 'mydebname' requested by the login. Client with IP address '255.255.255.255' 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. (Microsoft SQL Server, Error: 40615)"

 

Like most things in Azure, once you know how, it’s easy. Just finding out how can be incredibly tortuous!

 

From the machine you want to configure SSMS access for, log in to your Azure Management Porta dashboard.

 

Firewall Settings Microsoft Azure 0

 

Now click on the Azure SQL server you want to grant access for (not the individual databases unless you want to grant one by one).

 

Then select Firewall settings on the far right:

 

Firewall Settings Microsoft Azure 1

 

There is a nice option to add the current client IP, or (one by one only) you can create new rules. Just don’t try to add more than one at a time before saving.

 

Firewall Settings Microsoft Azure 2

 

Now go have a cup of tea and when you come back: you wish will be granted!

 

 

 

If you found this information useful, please share it!


This FAQ was last updated on Tuesday, April 18, 2017

Contact Information

To find out more about Ava solutions you can contact us in a number of ways:
Follow Us...