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

Source Control can't access database

I just upgraded to SQL Source Control 7.4.6
Getting the SQL Source Control can't access this database error.
I've tried setting Trust Server Certificate to true, however this only works on non mirrored databases. If I try to connect source control to a mirrored database it is saying it cannot access the database. Is there a way to fix source control?
AdamEdgar
0

Comments

4 comments

  • Victoria W
    Hi @AdamEdgar

    Are you trying to use Azure Active Directory Interactive authentication? If so, I'm sorry to say that auth method isn't supported in SQL Source Control. Our only DevOps / version control product that support such is Flyway Desktop.

    If you're not, please can you send over the log files from C:\Users\<username>\AppData\Local\Red Gate\Logs\SQL Source Control
    Victoria W
    0
  • AdamEdgar
    Hi Victoria
    We are not using Azure Active Directory Interactive authentication, we are using SQL authentication. 
    I think this might be a log from when it was saying it couldn't connect.
    (I have installed an older version of source control now, (7.3.36) and it is working again).

    When I was using the latest version it was only erroring on mirrored databases. 
    I also couldn't install the latest version of source control on SSMS 19, it was saying SSMS 17,18 or 19 needed to be installed but wasn't recognising SSMS 19 was installed. So we are now back on SSMS 18, with a previous version of source control.
    Cheers
    AdamEdgar
    0
  • Victoria W
    Hi @AdamEdgar

    Glad you're up and running again.

    SQL Source Control doesn't support SSMS 19 yet but we're working on it. I'll let you know as soon as we have a release.
    Victoria W
    0
  • Victoria W
    Hi @AdamEdgar

    Thank you for your patience on this issue, we now have a release which supports SSMS 19.

    https://download.red-gate.com/installers/SQLToolbelt/2023-03-01/SQLToolbelt.exe

    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
    Victoria W
    0

Add comment

Please sign in to leave a comment.