When Trying to Upgrade to Intel® Setup and Configuration Software (Intel® SCS) 12.1, I get an Error that Neither Installer nor DataBaseTool can Check Current Version of Database

We have a working Intel® Setup and Configuration Software (Intel® SCS) 11.0.0.214 (installed in 2016) on Windows 2008 Server R2. When trying to upgrade to Intel® SCS 12.1, you get the error:

Neither installer nor DataBaseTool can check current version of database.

DB is on remote server running SQL Server 2008 Enterprise.

AD account used by SCS has admin rights on local server and has necessary rights on target DB:

• db_datareader
• db_datawriter
• db_ddladmin
• dbowner

(tried even on sysadmin)

Databasetool.exe UpgradeDB /RCSisDisabled DBServer=CHC20009002\PZUHEPRD492,2302 dbname=RCS_MO

INFO: Starting: UpgradeDB

INFO: Checking if the database exists and is a supported version...

INFO: RunGetDBVersionCmd. 2. Throwing ERR_UNKNOWN_DB_VERSION (400)

ERROR: Database upgrade failed.No changes were made to the database.

ERROR: Completed with error (1000): Unknown error occurred.

DatabaseTool.exe checkscsdbconnection dbserver=CHC20009002\PZUHEPRD492,2302 dbname=RCS_MO RCSUserName="CHADHEDANI\sv_AMT_RCS_PROD_P" RCSPassword="????" RCSUserWinAuth=1

INFO: Starting: CheckSCSDBConnection

INFO: Verifying user permission on database...

INFO: Verifying database version...

INFO: RunGetDBVersionCmd. 2. Throwing ERR_UNKNOWN_DB_VERSION (400)

ERROR: Completed with error (1000): Unknown error occurred.

Check the Intel® Setup and Configuration Software (Intel® SCS) version in the database:

• Server: CHC20009002\PZUHEPRD492,2302
• Database: RCS_MO
• Query: Select * From [dbo].[global_settings]
• Results: should be similar to below

Check the configuration_value for the scs_version row. I suspect this value may be missing or corrupt.

If so, run the following query to correct the issue:

• Query: Update [dbo].[global_settings] Set configuration_value = '11.0.0' Where configuration_name = 'scs_version'