Avatar of Murray Brown
Murray Brown
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Azure - Allowing access to Windows Azure SQL database for specific computer from any Client IP address


In trying to connect to a SQL server database that I set up in Azure I get this error each time I try and interact with the database from a different location. If I add a rule that allows the client IP address at that location the error doesn't occur. I access the internet from a number of locations. Do I have to add every client IP address or is there a way to add a rule that picks up my computer and allows me in from anywhere?

  Firewall check failed. Cannot open server 'XXXXXXXXX' requested by the login. Client with IP address 'XXXXXXXXX' is not allowed to access the server. To enable access, use the SQL Azure 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.
AzureMicrosoft SQL Server

Avatar of undefined
Last Comment
Murray Brown

8/22/2022 - Mon