question

JamesBirchall-2062 avatar image
0 Votes"
JamesBirchall-2062 asked JamesBirchall-2062 commented

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

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.

azure-sql-databaseazure-webapps
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered JamesBirchall-2062 commented

@JamesBirchall-2062 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.

95321-image.png

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.


image.png (30.7 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.


In the Compute + storage blade I do not see the option above.
I see DTU count not vCores :

So does this mean I do not need to change anything in my WebApp that is hosted in Azure?
I have set my SQL Server settings to allow access to Azure services
95310-azuresqlserver.png


0 Votes 0 ·
azuresqlserver.png (3.8 KiB)

@JamesBirchall-2062 So you are using the standard tier in DTU pricing model.
Your database is not configured for zone redundancy so you should not have to make any changes.

Is you web app and Azure SQL database configured to use a VNET and service endpoint? If not then you are good.
You can check this from the Networking blade of your web app.
I dont have a VNET configured in the below example.

95588-image.png



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

0 Votes 0 ·
image.png (12.0 KiB)

Thanks for this, no VNET configured so its all good.

0 Votes 0 ·