Keyword not supported: 'authentication'.

chuck

Setting up a project with a SQL Source Control project in SSMS

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.

DanC

Hi @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

chuck

By the way, I am using the latest version

4.2.20176 - June 24th, 2020

chuck

also check the log and event log, nothing found related to the exception.

SQL Change Automation-SSMS-202007160742-17512.log

%SystemRoot%\System32\Winevt\Logs\Red Gate Software.evtx

Rcurtis

I get the same error trying to set up a new project using SQL Change Automation in SSMS

chuck

DanC said:

Hi @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

Version 4.2.20176 - June 24th, 2020 aslo introduced configuration error.
https://forum.red-gate.com/discussion/87158/keyword-not-supported-trust-server-certificate#latest

DanC

chuck said:

DanC said:

Hi @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

Version 4.2.20176 - June 24th, 2020 aslo introduced configuration error.
https://forum.red-gate.com/discussion/87158/keyword-not-supported-trust-server-certificate#latest

Hi Chuck,

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"

DanC

Hi @chuck

This bug has now been fixed as of version 4.2.20203.21402