Share via

I can't reach an SQL database that I am added access to as an owner on my AZURE account.

Halász Csenge Zsuzsa 20 Reputation points
2023-04-07T12:48:42.3+00:00

I get this error message when trying to run my Client code:
"Microsoft.Data.SqlClient.SqlException: 'Cannot open server 'rendszkorszmod' requested by the login. Client with IP address '176.77.135.197' 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.'"

But I am added as owner to the Azure SQL database I am trying to reach.

What should I do?

Azure SQL Database
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,365 questions
0 comments
Accepted answer
  1. Alberto Morillo 34,451 Reputation points MVP
    2023-04-07T16:19:18.3033333+00:00

    In addition to be the owner, you must include the public IP address (176.77.135.197) on a rule of the Azure SQL Database firewall to allow you to access the database. Please follow steps provided in this documentation.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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