Keyword not supported: 'authentication'.

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.

chuck July 16, 2020 08:34

Comments

7 comments

By the way, I am using the latest version
4.2.20176 - June 24th, 2020

chuck July 16, 2020 08:53

0
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

chuck July 16, 2020 09:52

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

Rcurtis July 17, 2020 01:56

0
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

DanC July 17, 2020 09:39

0
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

chuck July 20, 2020 10:13

0
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 July 20, 2020 10:23

0
Hi @chuck

This bug has now been fixed as of version 4.2.20203.21402

DanC July 28, 2020 11:44

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Keyword not supported: 'authentication'.

Comments

4.2.20176 - June 24th, 2020

Add comment