Keyword not supported: 'authentication'.
chuck
Posts: 29 Bronze 2
Setting up a project with a SQL Source Control project in SSMS
Failed to compare project against development source
Following this tutorial, and exception happened after
In the dialog, provide the connection details for the shadow database and click OK.
Failed to compare project against development source
Error performing schema comparison: Keyword not supported: 'authentication'.
The same exception aso happened, when I set an existing database as the development source.
Tagged:
Best Answer
-
DanC Posts: 627 Gold 5Hi @chuck and @Rcurtis
Sorry to hear you're experiencing this issue!
We are investigating this currently (bug report SCA-2736), and it appears that this bug appeared after version 4.2.20168.
You should be able to workaround this by using version 4.2.20168 (or an earlier version):
1 - Uninstall your existing SQL Change Automation installation from the Windows Control Panel
2 - Install an earlier version
Installer for 4.2.20168: https://download.red-gate.com/checkforupdates/SQLChangeAutomation/SQLChangeAutomation_4.2.20168.20590.exe
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers
4.2.20176 - June 24th, 2020
https://forum.red-gate.com/discussion/87158/keyword-not-supported-trust-server-certificate#latest
The bug is still being investigated and a fix hasn't been released just yet, apologies!
You should see the following quoted in the release notes when it's fixed "SCA-2736"
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
This bug has now been fixed as of version 4.2.20203.21402
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?