Azure SQL Database traffic migration to newer Gateways when using Webapp-->Azure SQL

0
votes

I have received an email from Microsoft regarding "Azure SQL Database traffic migration to newer Gateways". These changes are highlighted on this page.

In that page it says that you will not be impacted if you have:

  • Redirection as the connection policy
  • Connections to SQL Database from inside Azure and using Service Tags
  • Connections made using supported versions of JDBC Driver for SQL Server will see no impact. For supported JDBC versions, see Download Microsoft JDBC Driver for SQL Server.

I have also seen this similar question on Stackoverflow but my situation is different.

I have a simple scenario of a webapp and an SQL database where I access my database from the webapp using the connection string. The connection string looks like this:

Data Source=tcp:myspecialdb.database.windows.net,1433;Initial Catalog=my-prod-db;User [email protected];Password=mysecretpassword;

Can someone please tell me if I will be impacted? Thank you.

1
azureazure-sql-server
did you get any error? – Leon Yue
@LeonYue, the change will happen mid Sept. – Stackedup
Hi @Stackedup, we can't answer you certainly because it is not happened, I also receive the email from Microsoft. As I understand, If you web app host in Azure and Azure SQL database allow Azure Service or resources access this server, I think it won't be impacted. It more affect IP address firewall settings. – Leon Yue
yeah, that's right. If we met any error, Azure also will provide the solution/guides for us. Can I post it as answer? – Leon Yue
haha, you are so humorous! How about mark it first for your hair? – Leon Yue

1 Answers

1
votes

We can't answer you certainly because it is not happened, I also received the email from Microsoft.

enter image description here

enter image description here

As I understand, If you web app host in Azure and Azure SQL database allow Azure Service or resources access this server, I think it won't be impacted. It more affect IP address firewall settings.

And as you said: It looks like that if I use the service tags then it won't be a problem. I believe that's how I have set up my configuration. Like in my connection string above, my service tag is my-prod-db/myspecialdb. so fingers corssed it should go without any problems.

If we 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.