Azure firewall exclusion not working.

chrisrdba 361

Greetings. I've got two Azure SQL servers/ databases, one for DEV and one for Prod.

Each server has the same firewall rules set up. We have a developer that can access DEV w no problem, but cannot access Prod and it throws up the normal "your IP address does not have access to the server....." message.

Even though his IP address is within a exclusion known range, I tried adding his IP specifically to it's own new exclusion JIC -- no dice.

Any ideas?

Anurag Sharma 17,586 Reputation points

2020-09-22T07:18:38.877+00:00
Hi @chrisrdba , welcome to Microsoft Q&A forum.

This issue looks strange. I tried creating 2 databases and was able to connect to both. Assuming that both the databases have similar configuration. Could you please help us with below information?

How are you trying to connect to databases, through SDK or any other way?

Are you using Azure Sql Database as PaaS?

Are both the databases on same server or different server?
chrisrdba 361 Reputation points

2020-09-22T14:21:25.933+00:00

1) The person having the issue is simply trying to connect from SSMS, the same way he's connecting to DEV.

2) Azure SQL database.

3) Different servers, both created by me.
Anurag Sharma 17,586 Reputation points

2020-09-23T09:41:39.517+00:00

Hi @chrisrdba , I was trying the similar configuration you provided above but could not see any issue.

Is it possible that the production database is sitting behind a VNET?. You can check it as mentioned in below screenshot:

Share via

Azure firewall exclusion not working.