Yet another SQL Server enthusiast


Connecting to Azure SQL Database #learning

Filed under: Uncategorized — sa @ 2:11 PM


If we want to connect to a Azure SQL Database by using a app (ex. SQL Server Management Studio) we may get following exception:



According to message associated with this exception, the cause of this issue is related to configuration of server-level (see also sp_set_firewall_rule) or database-level (see also sp_set_database_firewall_rule) firewall rules used to allow the access to SQL DB.


[1] First solution implies to configure the server-level/database-level firewall in order to allow connections from a specified IP of IP range: Select Azure SQL DB > Overview > Set server firewall


Then Add client IP > Save:



[2] Second solution is to allow connections to Azure SQL DB by activating Allow access to Azure services.

[3] If none of above solutions work for you then all details regarding FW configuration is available here: .


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at

%d bloggers like this: