How do I make firewall acceptance stick in SQL Azure?

Why do I have to constantly click "YES" and "OK" when logging on to use my SQL AZURE database?

Whenever I log into the SQL AZURE database I have, it always gives me an error about my firewall setting -- but the error seems to be in reference to the server. I click "YES" on the option to allow access on the error message that appears at the bottom of the display. Then it presents a different prompt that asks if I want to include my IP address in the settings, I click "YES" again and then I am allowed to continue.

But then when I go to log into the database to use it, I always get this message that says it will take about 5 minutes to have the settings stick:

Firewall check failed. Cannot open server '{THE SERVER ID}' requested by the login. Client with IP address '{my IP Address}' 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.

Eventually, I am able to edit and manage my database tables. But if I log out and log back in another day, I run into the same issues. So, how do I make firewall acceptance stick in SQL Azure?

more ▼

asked Sep 04, 2012 at 05:08 PM in Default

avatar image

60 7 8 9

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You need to go to the Management Portal for Azure (windows.azure.com). Click at the lower left on databases. You'll see your account. Expand that and you'll see your database, kx4224xxxwhatever. Click on that. Right in the middle of the screen should be a button labeled "Firewall Rules". Click on that and you can click Add. That will allow you define a rule and save it. It's what I do.

One other issue you might be hitting is that your IP address is constantly changing. In which case, you need to determine if there's a range that you could create a rule for.

Either way, you should be able to store the rules right there.

more ▼

answered Sep 05, 2012 at 10:26 AM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 04, 2012 at 05:08 PM

Seen: 2210 times

Last Updated: Sep 05, 2012 at 10:26 AM

Copyright 2018 Redgate Software. Privacy Policy