How do I resolve the following : An error occurred while fetching firewall rule details. Please try loading the firewall rule again.

Question

How do I resolve the following : An error occurred while fetching firewall rule details. Please try loading the firewall rule again.

Mark Wedderburn 0

I am attempting to add a firewall rule to my SQL database. I get the message : "An error occurred while fetching firewall rule details. Please try loading the firewall rule again" as I access the page. How can I resolve?

0 comments

Answer recommended by moderator

Mark Wedderburn 0

The issue occurred because of a late payment which I didnt realize.

Pilladi Padma Sai Manisha 11,620 Reputation points Microsoft External Staff Moderator

2026-02-12T10:05:45.84+00:00

Hi Mark Wedderburn,
Thank you for your patience here, and I’m really sorry the earlier guidance didn’t point you in the right direction I understand how frustrating it is when the portal shows an error and you’re just trying to make a simple firewall change.

Based on your update, the behavior you experienced makes sense. When a subscription goes into a past-due or disabled state because of billing, Azure temporarily blocks management operations on resources. During that time the SQL server firewall blade cannot read its configuration, which triggers the message “An error occurred while fetching firewall rule details.” This isn’t caused by your network, IP settings, or SQL configuration it’s a control-plane restriction while the subscription is not fully active.

Now that the payment has been completed, please sign out of the Azure portal, sign back in, and reopen the logical SQL server resource (not just the database). It can take a short period for the platform to fully restore access after billing is resolved, so if the firewall page still fails initially, wait a little while and try again. Once the subscription status is fully synced, the firewall rules should load normally and you’ll be able to add or edit them without issue.

I appreciate you calling out the real cause, and again I’m sorry for the confusion earlier. If the error continues even though the subscription shows Active, let me know and we’ll look at the server state together.
Manoj Kumar Boyini 19,345 Reputation points Microsoft External Staff Moderator

2026-02-12T21:33:27.01+00:00

Hi Mark Wedderburn,

I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

2 additional answers

Your answer

Pilladi Padma Sai Manisha 11,620 Reputation points Microsoft External Staff Moderator

2026-02-12T10:05:45.84+00:00

Hi Mark Wedderburn,
Thank you for your patience here, and I’m really sorry the earlier guidance didn’t point you in the right direction I understand how frustrating it is when the portal shows an error and you’re just trying to make a simple firewall change.

Based on your update, the behavior you experienced makes sense. When a subscription goes into a past-due or disabled state because of billing, Azure temporarily blocks management operations on resources. During that time the SQL server firewall blade cannot read its configuration, which triggers the message “An error occurred while fetching firewall rule details.” This isn’t caused by your network, IP settings, or SQL configuration it’s a control-plane restriction while the subscription is not fully active.

Now that the payment has been completed, please sign out of the Azure portal, sign back in, and reopen the logical SQL server resource (not just the database). It can take a short period for the platform to fully restore access after billing is resolved, so if the firewall page still fails initially, wait a little while and try again. Once the subscription status is fully synced, the firewall rules should load normally and you’ll be able to add or edit them without issue.

I appreciate you calling out the real cause, and again I’m sorry for the confusion earlier. If the error continues even though the subscription shows Active, let me know and we’ll look at the server state together.
Manoj Kumar Boyini 19,345 Reputation points Microsoft External Staff Moderator

2026-02-12T21:33:27.01+00:00

Hi Mark Wedderburn,

I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

Answer 1

Hi Mark Wedderburn,

It looks like you're facing an issue with adding a firewall rule to your SQL database, getting an error while trying to fetch rule details. This problem might be caused by a couple of reasons. Here are some steps you can try to resolve the issue:

Refresh the Page: Sometimes, the portal can have temporary issues. Simply refreshing the page or waiting a few moments before trying again can help.

Check Permissions: Ensure you have the required permissions assigned to your account to manage firewall rules. You might need to be a subscription owner or have contributor-level access.

Enable TCP Port 1433: Make sure that TCP port 1433 is open on your local network as it is required for connecting to Azure SQL Database. You can check this by running:

telnet <your-server-name>.database.windows.net 1433

If it fails, the port might be blocked.

Review Your IP Configuration: Go to the Azure portal, access your SQL server, and check the Configure tab to verify your Current Client IP Address. Ensure this IP address is added to the firewall rules under Allowed IP Addresses.

Dynamic IP Address Considerations: If you’re using a dynamic IP address, it might change regularly, which could lead to access issues. In this case, consider adding a range or switching to a static IP.

Clear Cache: If you've made changes to your firewall rules and they aren't recognized immediately, you can clear the local cache by running:

DBCC FLUSHAUTHCACHE;

This command helps to refresh the authentication cache for your database.

Check Documentation: You can refer to these helpful documents for detailed steps and troubleshooting tips:

If these steps don't solve your issue, I suggest providing a bit more detail about your setup. Here are a few follow-up questions that could help narrow down the problem:

What specific steps have you taken when trying to add the firewall rule?
Have there been any network changes recently that could affect connectivity?
Are you receiving any other error messages aside from fetching firewall rule details?

Hope this helps you get back on track! Let me know if there's anything else you need!

Manoj Kumar Boyini 19,345 Reputation points Microsoft External Staff Moderator

2026-02-11T21:13:17.7933333+00:00

Hi Mark Wedderburn,

I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

Answer 2

Alberto Morillo 35,506 MVP Volunteer Moderator

Maybe that is related to temporary issues on the Azure region where the server is located. Examine Resource Health to find possible health information related the server/database. In this case

User's image

Make sure you still have permissions to manage firewall rules. See permissions required here.

As a workaround, try to create the rule using Transact-SQL while connected to the master database or using Azure CLI.

EXECUTE sp_set_firewall_rule
@name = N'AllowSpecificIP',
@start_ip_address = '192.168.1.1',
@end_ip_address = '192.168.1.10';

0 comments