Windows Azure Client with IP address XXX XXX XXX XX is not allowed to access the server

0 votes

In Windows Azure, I've set up a server, a database, and a firewall setting (rule). Under the Windows Azure Firewall Tab, I've added the IP In firewall setting, which is populating.

This problem notice appears when I try to connect to a database using Manage from Azure Platform.

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.

Furthermore, I am unable to connect using SQL Server Management Studio. For My IP Address, I'm getting the same connection issue error.

I don't have a static IP address, but it hasn't changed during this procedure. I tried several examples, but they all said to add a firewall rule, which I had already done.

Mar 4 in Azure by Edureka
• 8,240 points
105 views

1 answer to this question.

0 votes
With the latest version of Windows Azure, all you have to do is go to the firewall settings and click on add client IP and you'll be ok.
answered Mar 29 by Edureka
• 9,540 points

Related Questions In Azure

0 votes
0 answers

Windows Azure Portal login to portal and receive error "We are having trouble logging you into the portal"

Open browser Navigate to http://www.windowsazure.com/en-us/ Select portal top right login with ...READ MORE

Mar 2 in Azure by Edureka
• 8,240 points
53 views
0 votes
1 answer
0 votes
1 answer

calculate the length of the storage container - Azure blob storage

You can use the following code: $resourceGroup = ...READ MORE

answered Oct 30, 2019 in Azure by Waheem

edited Oct 7, 2021 by Sarfaraz 1,076 views
0 votes
1 answer

How to upload files to azure?

To access Azure Storage, you'll need an ...READ MORE

answered Jan 21, 2020 in Azure by Sirajul
• 59,170 points
4,928 views
0 votes
1 answer

Azure Blob Storage URL : WASB:// vs HTTP://

wasb://XXXXXXXXXX@XXXXX.blob.core.windows.net is used to access blob storage through ...READ MORE

answered Apr 7 in Azure by Edureka
• 9,540 points
55 views
0 votes
1 answer

Will Power BI connects with Azure LUIS to Visualize the INTENTS?

Azure Cognitive Services can be used as ...READ MORE

answered Apr 22 in Azure by Edureka
• 9,540 points
32 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP