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
Release : 1403
Component : DESKTOP AND SERVER MANAGEMENT
The issue occurs if you have the SSL encryption enabled in the SQL Server Configuration Manager.
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.