Client with IP address is not allowed to access the server Azure SQL database
Client with IP address is not allowed to access the server Azure SQL database
Client with IP address is not allowed to access the server Azure SQL database
Re: Client with IP address is not allowed to access the server Azure SQL database
This can be solved by configuring the Firewall of the Azure SQL Server where the SQL database resides. I am using the new Microsoft Azure Portal. Please see the screenshot below,
[](https://i.sstatic.net/Zw5qu.png)
Remember, you need to configure the Firewall and manage the IP addresses in SQL Server, not the SQL database.
Once you have selected the SQL Server,
- Click the *Settings -> Firewall*
- You will be requested Add a new Rule.
- Add a name and enter the IP address(or the range) that will access
the database. note: Azure automatically detects your current IP.
[](https://i.sstatic.net/e0xYR.png)
Wait for 5 minutes and you are ready to go. I hope this helps.
[](https://i.sstatic.net/Zw5qu.png)
Remember, you need to configure the Firewall and manage the IP addresses in SQL Server, not the SQL database.
Once you have selected the SQL Server,
- Click the *Settings -> Firewall*
- You will be requested Add a new Rule.
- Add a name and enter the IP address(or the range) that will access
the database. note: Azure automatically detects your current IP.
[](https://i.sstatic.net/e0xYR.png)
Wait for 5 minutes and you are ready to go. I hope this helps.