MDB installing failing with error SSL Provider: The certificate chain was issued by an authority that is not trusted.

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

The Client Automation Installation/Upgrade is failing while installing the MDB with the below pop up:

Then it finally fails with below error:

We see the follow error in the install_mdb.log:

02-16,15:53:39 setupmdb mdb log file in "C:\Users\Administrator~1.BAB\AppData\Local\Temp\ITRM\database\mdb_install\install_mdb.log"

02-16,15:53:39 SetupMDB command: setupmdb  -DBVENDOR=mssql -DBNAME=mdb -DBHOST=hostname -DBPORT=1433 -DBDRIVER="ITCM" -WORKSPACE="ITCM" -JRE_DIR="D:\Program Files (x86)\CA\SC\Mdb\Windows\jre" -MDB_SOURCE_DIR="C:\Users\ Administrator ~1.BAB\AppData\Local\Temp\ITRM\database\mdb_install" -MDB_TARGET_DIR="C:\Users\ Administrator ~1.BAB\AppData\Local\Temp\ITRM\database\mdb_install" -MDB_EXIT_SCRIPT=no -MDB_PRIVATE_DIR="D:\Program Files (x86)\CA\SC"
02-16,15:53:40 Executing pre-process: "C:\Users\ Administrator ~1.BAB\AppData\Local\Temp\ITRM\database\mdb_install\mssql\setupmdb_pre.bat"
02-16,15:53:41 Checking if mdb already exists...
02-16,15:53:41
02-16,15:53:41 sqlcmd -S "Hostname,1433" -d master -E -e -b -Q "exit(SELECT count(*)+100000 FROM master..sysdatabases WHERE name = 'mdb')" 
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : SSL Provider: The certificate chain was issued by an authority that is not trusted.
.
Sqlcmd: Error: Microsoft SQL Server Native Client 11.0 : Client unable to establish connection.
02-16,15:53:42 SQL command error, ERRORLEVEL=1, see logfile for details
02-16,15:53:42 Setupmdb_pre exit /B return code=100
02-16,15:53:44 Pre-process failed (errorlevel=100)
02-16,15:53:44 Setupmdb exit  return code=110

 

Environment

Release : 1403

Component : DESKTOP AND SERVER MANAGEMENT

Cause

The issue occurs if you have the SSL encryption enabled in the SQL Server Configuration Manager.

Resolution

Open the SQL Server Configuration Manager and make sure that ‘Force Protocol Encryption is set to ‘No’ under the SQL Native Client 11.0 configuration and SQL Native Client 11.0 configuration (32bit) properties.

Recycle the SQL Server Service and re-run the installation/upgrade.