Confusion caused by service advisory notification received about SQL Database network configuration

Question

The tracking ID is HMD2-HSG and the text of the message was as follows:

TRACKING ID:
HMD2-HSG TYPE:
ActionRequired
STATUS:
Active
COMMUNICATION:
We have important information regarding your SQL Database resources in UK West.

To improve performance and reduce login latency, two existing SQL Database gateways will begin accepting traffic in the UK West on 01 June 2021. As a result, the public IP addresses of your SQL databases in UK West may change.

To avoid service disruptions, update your network configuration to allow communication with these existing SQL Database gateways in UK West by 01 June 2021:

51.140.208.96, 51.140.208.97

If you use zone redundant configuration in SQL Database, ensure that your client can communicate with all gateways in UK West.

If you have questions, get answers from community experts in Microsoft Q&A. If you have a support plan and you need technical help, please contact us.

IMPACTED SERVICE(S) AND REGION(S)
Service Name Region
SQL Database UK West

---

Now we have an Azure Web App that uses a SQL Server Database in UK West, however I have no idea where to enter the above IP Addresses or where to oget to the "Zone Redundat Configuration" option. Instead I have added the firewall riles to allow the two IP Addresses to connect to the SQL Server in the "SQL Server" "Firewall and virtual networks" configuration section. Note this is in the "SQL Server" not the "SQL Database" area so I am sure it is not correct. Can someone please help.

I am sorry if this is the wrong place for this question, but it is from the link at the bottom of the Advisory and I had to create a Microsoft Documents account just to ask this question.

Regards,
Jim.

Answer 1

@James Birchall Welcome to Microsoft Q&A Forums.

Yes, this is the right place to get answers to all your questions regarding Azure services.
You will be affected by this change only if you

• Hard coded the IP address for any particular gateway in your on-premises firewall
• Have any subnets using Microsoft.SQL as a Service Endpoint but cannot communicate with the gateway IP addresses
• Use the zone redundant configuration for general purpose tier
• Use the zone redundant configuration for premium & business critical tiers

To check if you are using a zone redundant configuration, Navigate to your database on the Azure Portal and click on the Compute and Storage blade.
If the below setting is turned ON, then you have zone redundancy enabled and you will need to take action. The steps are here
I have mine turned off in the below example.

Please revert if you have additional questions or need any further help.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.