Unable to connect Azure SQL database service, gettting error as sp_set_Firewall_rule

Syed Basha 26 Reputation points
2023-05-07T05:23:40.7133333+00:00

Cannot open server 'az-uyrtewr1' requested by the login. Client with IP address '' 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:1f4acb83-7e30-4FadaFQWWWFDS

Azure SQL Database
{count} vote

3 answers

Sort by: Most helpful
  1. VasimTamboli 4,780 Reputation points
    2023-05-07T10:42:17.17+00:00

    The error message indicates that the IP address of the client trying to connect to the Azure SQL server is not allowed through the server's firewall. You can follow the steps below to create a firewall rule to allow your client's IP address to access the server:

    Log in to the Azure portal and navigate to the SQL server that you want to modify the firewall settings for.

    In the left-hand menu, click on "Firewalls and virtual networks."

    Add the IP address of the client machine that you want to allow access to the server. You can either add a specific IP address or a range of IP addresses.

    Save the changes and wait for up to five minutes for the new firewall rule to take effect.

    If you are still unable to connect after adding the firewall rule, ensure that the login credentials you are using to connect to the server are correct and that the login has been granted appropriate permissions to access the server and its databases.

    2 people found this answer helpful.

  2. Luke Murray 10,611 Reputation points MVP
    2023-05-07T09:47:40.25+00:00

    Hi, Syed

    As your IP address been allowed through the SQL Azure Firewall?

    https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql

    Sounds like the Firewall has been enabled on your Azure SQL database, blocking connections from your IP.

    0 comments No comments

  3. Luke Murray 10,611 Reputation points MVP
    2023-05-07T09:47:42.1033333+00:00

    Hi, Syed

    As your IP address been allowed through the SQL Azure Firewall?

    https://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql

    Sounds like the Firewall has been enabled on your Azure SQL database, blocking connections from your IP.

    0 comments No comments