SQL Source Control cause crashes

Robert_H_Ricardo

I have installed SQL Source Control but I don't really use it. Every now and again whilst using SSMS it generates the Send Error Report screen and no matter what you press it asks to do it again, and I have to reboot as even killing processes does not work.
I tried un-installing it and I could no longer connect to azure databases in SSMS, it gave a technical error ("could not discover endpoint for integrate windows authentication"!). I re-installed SQL Source Control it and I could connect to azure databases in SSMS again.
I use SQL Change Automation and it is really useful. This issue with SQL Source Control is a pain, but I don't want the solution to be more painful than the problem ...

DanC

Hi @Robert_H_Ricardo

Sorry to hear you're experiencing this issue!

Can I ask, what authentication method you're using to connect to your Azure databases?

Robert_H_Ricardo

Azure Active Directory - Integrated

DanC

Hi @Robert_H_Ricardo

Ah, there's currently a bug when using Azure AD for your authentication when using SQL Source Control, you can workaround this by using the following version: https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.2.40.13374.exe

If you uninstall the previous version and install the version provided. Your databases will retain their connections upon install.

Hope this helps!

DanC

Hi @Robert_H_Ricardo

Thank you for your patience on this issue, I can now let you know the latest version of SQL Source Control includes a fix for this issue:

7.3.31.15722 - June 1st, 2022

Improvements

• Updated SQL Compare Engine to 14.7.8.21113

Fixes

• VT-143 - Fixed a bug causing an error 'Could not load file or assembly 'Azure.Core..." when using Active Directory Authentication in Azure.

 

https://download.red-gate.com/checkforupdates/SQLSourceControl/SQLSourceControl_7.3.31.15722.exe