Share via

Azure SQL database firewall issue

Naveen V 1 Reputation point
2021-03-08T11:42:21.853+00:00

I am getting below error ** **1. **Cannot open server 'firstsqlsvr' requested by the login. Client with IP address '137.135.92.14' is not allowed to access the server. To enable access, use the Windows Azure Management 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. ClientConnectionId:e1f26bae-0b2c-445b-9bdc-318da79942f7, error stack:shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)**** ** I was keep on adding new IP address when i get the error .

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vaibhav Chaudhari 39,011 Reputation points Volunteer Moderator
    2021-03-08T13:57:13.817+00:00

    Yes, you will have to keep on adding IP address in allowed IP addresses section whenever your machine IP address changes.

    Another option is you can provide all the IP address range like 0.0.0. to 255.255.255.255 but note that this way your server allows communications from all resources inside the Azure boundary, that may or may not be part of your subscription.

    Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.