Please fix previously working connection to Azure SQL db?

• 
  I have just checked SQL Compare is still able to access the Azure SQL databases, so red-gate knows how to connect why is addressing this for source control such an issue?

  mvanraalte January 18, 2023 18:03

  - 0 +
• 
  Very weird - i see the question: SQL Source control can't access this database has the same problem that was posted 6months+ ago
  and also: SQL Source Control can't access this database - Azure SQL Managed Instance
  
  why is this not getting fixed?

  mvanraalte January 18, 2023 22:11

  - 0 +
• 
  Hi @mvanraalte
  
  This is came about due to Microsoft changing their "Microsoft.Data.SqlClient" which is used for connecting. We had been waiting on Microsoft to resolve this and then allow us to inherit the fix. I believe we have a fix coming next week

  DanC January 20, 2023 09:53

  - 0 +
• 
  Hi Dan,
  
  That is great to hear, i look forward to trying it out. Thanks for the follow up!
  
  My curiosity is how SQL Compare is still working and its connections do not fail? Is it already using the newer component and Source Control using the older one?

  mvanraalte January 20, 2023 16:25

  - 0 +
• 
  Hi @mvanraalte
  
  SQL Compare was able to run the latest version of the Microsoft SQL Data Client, but I believe some of our other tools used dlls that weren't compatible so we had to do some extra work to allow the SQL Compare engine to go into those tools and be compatible for SSMS 19

  DanC January 20, 2023 16:32

  - 0 +
• 
  HI @DanC
  You indicated you plan to have a solution to this access problem this week. Any chance i can get access to it?
  Thanks!

  mvanraalte January 26, 2023 19:20

  - 0 +
• 
  Hi @mvanraalte
  
  I spoke to soon, we're still awaiting a fix on this so please continue to use the older version until I update further

  DanC January 30, 2023 09:55

  - 0 +
• 
  @DanC
  I appreciate the follow up.
  
  I was not able to get the older version installed, so i am stalled waiting day by day for this fix. I understand that this would require a little effort but looking at some of the other forum entries this has been a problem for a long time. I am really looking for a solution, Thanks.

  mvanraalte January 30, 2023 17:09

  - 0 +
• 
  Hi @mvanraalte
  
  If you uninstall the current version you have, then proceed to install the following version it will work: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.3.36.16024.exe
  

  DanC January 30, 2023 17:17

  - 0 +
• 
  @DanC
  I am still getting a failure. I have checked Help>About to make sure that i am running the intended version from above.
  Setup tab is failing with: "SQL Source Control can't access this database."
  Commit tab is diff and now failing with Redgate error: "ActiveDirectoryInteractive authentication method is not supported."
  So, i am still stuck. Did the uninstall not remove something / did the install not install something?

  mvanraalte January 31, 2023 17:48

  - 0 +
• 
  Hi @mvanraalte
  
  Ah, SQL Source Control doesn't support Azure MFA, if you wish to use this auth method you will need to switch to Flyway Desktop: https://documentation.red-gate.com/soc/requirements-and-supported-systems
  
  

  If you are interested in database version control with Azure Active Directory Interactive Authentication (MFA), try Flyway Desktop, Redgate's next generation of SQL Source Control, available as part of Flyway Teams or Flyway Enterprise. Find out more about switching your license and get in touch with our sales team for a demo.

  DanC February 01, 2023 10:30

  - 0 +
• 
  @DanC
  I am familiar with SQL Source Control, and it was working great until this connection bug arose. How do I go back to the working solution? I do not want to move to a new product that works differently. We may consider this in the future.

  mvanraalte February 01, 2023 16:18

  - 0 +
• 
  Hi @mvanraalte
  
  

  Thank you for your patience on this issue, we now have a release which contains the latest SQL Compare engine and this should resolve the issue you was experiencing!

  Are you able to patch into v7.5.4 at your earliest convenience and confirm if this issue has been resolved.

  Download link available here: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.5.4.16994.exe

  Patch note 7.5.4.16994 - February 28th, 2023

  Improvements

  • VT-282 - Providing support for SSMS 2019 GA.
  • Updated SQL Compare Engine to 15.0.5.23167

  DanC March 01, 2023 09:56

  - 0 +

Add comment

Please sign in to leave a comment.