How can we help you today? How can we help you today?

SQL Source Control cause crashes

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 ...
Robert_H_Ricardo
0

Comments

4 comments

Sort by
  • 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?
    DanC
    0
  • Robert_H_Ricardo
    Azure Active Directory - Integrated
    Robert_H_Ricardo
    0
  • 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
    0
  • 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

     

    DanC
    0

Add comment

Please sign in to leave a comment.