Loading...
Skip to content
AndyLeonard.blog() AndyLeonard.blog()
  • LinkedIn
  • X.com
  • RSS
  • About Andy
  • linktr.ee

Failed to Update Server Errors When Configuring Networking

Posted on October 9, 2022by Andy LeonardCategories:Azure Server, Azure Server Security

Recently, I attempted to update the Networking for an Azure SQL Server I use when delivering training. Specifically, I was attempting to set “Public network access” to “Selected networks,” add my client IP, and check the “Allow Azure services and resources to access this server” checkbox – found on the Networking blade for my new Azure server:

 

I configured all three settings  clicked the “Save” button, and got the following error responses:

  • Failed to update server exceptions
  • Failed to update server firewall rules

“Read the Error Message, Andy”

Before I take off to solve an error, I say to myself, “Read the error message, Andy.” Well, most of the time I say this to myself. My first instinct is to always imagine what must be causing the error, and take off to solve what I’ve dreamed up.

I rarely dream up the correct error.

If I do not know what the actual error is, I do not know the answer to a very important question:

“What is the problem we are trying to solve?” – Bennett McEwan, circa 2008

Reading the first error message gives me this clue:

“Unable to create or modify firewall rules when public network interface for the server is disabled. To manage server or database level firewall rules, please enable the public network interface.” My goodness. It not only tells me what’s failing, the error message informs me how to fix it!

Starting at the Beginning

If I didn’t have such an awesome error message, or if I had not bothered to read it, I would need to think through the issue.

The Networking blade did not appear as shown in the first image until I clicked the “Selected networks” option for the “Public network access” property. In fact, the Networking blade appeared as shown below until I clicked the “Selected networks” option:

No other networking configuration options appeared until after setting the “Public network access” property, so I first set the “Public network access” property to “Selected networks” and then saved that setting all by itself:

Success!

Next, I configured both the “client IP” firewall rule and the “Allow Azure services…” exception:

When I clicked the save button:

Success, and then more Success!

I can configure additional settings on the Networking blade after I’ve changed the “Public networking access” property and applied the change. Before applying the change, I get errors.

Conclusion

You’ve probably already figured this out and are thinking, “Andy, you’re an idiot!” You may be completely right; I’m sure you are right at least some of the time. Reading the error message is a good rule, for me, at least. Here’s hoping this post helps someone.

Peace.

:{>

 

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>

TaggedAzureAzure SecurityAzure ServerAzure Server SecurityAzure SQL DB

One thought on “Failed to Update Server Errors When Configuring Networking”

  1. Pingback: Failed to Update Server Firewall Rules in Azure – Curated SQL

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Training

Next Live Training:

Fabric Data Factory logo A Day of Fabric Data Factory live and online 9:00 AM-4:30 PM (ET) 18 Jun 2025. Register today!
Fabric Data Factory logoAdvanced Azure Data Factory (ADF) live and online 9:00 AM-4:30 PM (ET) 25 Jun 2025. Register today!

Subscribe to my Newsletter

Need Help?

I still deliver consulting! I help enterprises implement Fabric Data Factory and Azure Data Factory solutions, help data teams rescue data warehouse projects, and support businesses by validating data architecture. Contact me. I can help.

Training

Azure QuickStart Premium includes access to all Enterprise Data & Analytics' Fabric, Azure, and Azure Data Factory training for 1 Year! Register today!

Do you need to level-up your Data Engineering skills in a hurry? Premium Level includes all Azure QuickStart Premium content plus SSIS and SSIS Catalog content. Register today!

  • LinkedIn
  • X.com
  • RSS
© 2025 by AndyLeonard.blog(). All rights reserved.
Back to top