Source Control can't access database

AdamEdgar

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?

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

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

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

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