Fix the ‘Your client IP address does not have access to the server.’ error when connecting to an Azure SQL Database from SQL Server Management Studio

If you’ve just created an Azure SQL Database and are trying to connect to it from SQL Server Management Studio you may get an access error saying…

Your client IP address does not have access to the server.

To resolve this you need to amend the firewall settings on the server.  To do this navigate to your new database and click ‘Set server firewall’…

Go to the new Azure SQL Database

 

… and then on the Firewall settings page click ‘Add client IP‘ to have Azure populate a firewall rule for you as shown below. Don’t forget to click Save afterwards.

 

Add client IP in the firewall settings page

Leave a Reply

Your email address will not be published.