SSMS new firewall rule for AZURE not allowed for personal accounts - AADSTS500200

Question

SSMS new firewall rule for AZURE not allowed for personal accounts - AADSTS500200

Bill Clark 0

Screenshot 2025-08-05 203956

If my IP address changes, I am no longer able to use SSMS to create a new firewall rule. It was possible to create a rule for the last 10 years or so, but within the past month, I cannot. I must log into the Azure control panel (using the very same personal account) to set the rule on the database.

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-06T05:05:28.2+00:00

Hi Bill Clark,

I kindly request you to please share the details requested in the private message for further investigation.
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator

2025-08-06T20:28:58.05+00:00

Personally, I prefer to update the rule from the portal. Yes, that is more hassle, but the key thing is that I want to delete the old address, to prevent that someone else who get that address is able to access my resources.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-07T07:51:24.8866667+00:00

Hi Bill Clark,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-08T03:01:34.58+00:00

Hi Bill Clark,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

1 answer

Your answer

Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-06T05:05:28.2+00:00

Hi Bill Clark,

I kindly request you to please share the details requested in the private message for further investigation.
Erland Sommarskog 124.2K Reputation points MVP Volunteer Moderator

2025-08-06T20:28:58.05+00:00

Personally, I prefer to update the rule from the portal. Yes, that is more hassle, but the key thing is that I want to delete the old address, to prevent that someone else who get that address is able to access my resources.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-07T07:51:24.8866667+00:00

Hi Bill Clark,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Mahesh Kurva 6,850 Reputation points Microsoft External Staff Moderator

2025-08-08T03:01:34.58+00:00

Hi Bill Clark,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Answer 1

TP 131.6K Volunteer Moderator

Hi Bill,

Have you considered using SSMS 21 instead? The connection/sign-in has been updated and for me it allows me to use Microsoft account to create firewall rule. It doesn't redirect to web browser for the authentication prompt (unlike older SSMS versions).

I've experienced the same thing as you describe when using SSMS 20, so for that I just use Entra ID account when I need to sign in to create firewall rule.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP

Share via

SSMS new firewall rule for AZURE not allowed for personal accounts - AADSTS500200

1 answer

Your answer