CA SDM install fails at the 'Integrate the Products' step of the Installation Wizard. Previous steps of the installation were successful.
CA SDM stdlogs show below errors:
INFO PatchDatabaseTask.java 353 Executing altArgs >sql_check_db -c -s SDMServerName -o mdbadmin -d mdb -U mdbadmin -p <DB password> -n SQLServerHostName <
INFO ? ? Process D:\PROGRA~1\CA\SERVIC~1\bin\sql_check_db.exe completed with exit code 99
ERROR PatchDatabaseTask.java 607 Can't connect to the database.
ERROR PatchDatabaseTask.java 665 Can not connect to the Database Server.
CA SDM Checkdb.log shows:
SDMServerName sql_ckeckdb 2312 ERROR sqlclass.c 473 Failed to logon to SQL Server (SQLServerHostName ) Reason: [Microsoft SQL Server Native Client 11.0] [ SQL Code=10054 SQL State=08001] Client unable to establish connection; [Microsoft SQL Server Native Client 11.0] [ SQL Code=10054 SQL State=08001] TCP Provider: An existing connection was forcibly closed by the remote host.
SQL command line tool test (osql) errors out with the same behavior, while sqlcmd command works fine. See below:
osql -E -S SqlServerHostName
[SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.
[SQL Server Native Client 11.0]Client unable to establish connection
sqlcmd -E -S SqlServerHostName
The above indicates that the behavior is more about SQL Native Client rejecting the connection but regular SQL client layer works fine.