0

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 Id=johndoe@myspecialdb.database.windows.net;Password=mysecretpassword;

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

Stackedup
  • 680
  • 2
  • 9
  • 26
  • 1
    did you get any error? – Leon Yue Aug 18 '20 at 01:27
  • @LeonYue, the change will happen mid Sept. – Stackedup Aug 18 '20 at 06:54
  • 1
    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 Aug 19 '20 at 02:29
  • Thanks @LeonYue. 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. – Stackedup Aug 20 '20 at 02:48
  • 1
    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 Aug 20 '20 at 03:04
  • @LeonYue, I will mark this as an answer on 16th or 17th of Sept depending how much I pull my hair out. :) – Stackedup Aug 20 '20 at 03:25
  • 1
    haha, you are so humorous! How about mark it first for your hair? – Leon Yue Aug 20 '20 at 05:13

1 Answers1

1

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.

Leon Yue
  • 15,693
  • 1
  • 11
  • 23