The CA Service Desk Manager (CA SDM) 12.9 CUM#1 required SETUPMDB post install command fails with error "TCP Provider: No connection could be made because the target machine actively refused it."

Document ID : KB000056654
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The CA Service Desk Manager (CA SDM) 12.9 CUM#1 required SETUPMDB post install command fails.

INSTALL_MDB.LOG contains the following errors:

Sqlcmd -S "localhost,1433" -d master -U ServiceDesk -P ***  -e -b -Q "exit(SELECT count(*)+100000 FROM master..sysdatabases WHERE name = 'mdb')"
HResult 0x274D, Level 16, State 1
TCP Provider: No connection could be made because the target machine actively refused it.

Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.
SQL command error, ERRORLEVEL=1, see logfile for details
Setupmdb_pre exit /B return code=100
Pre-process failed (errorlevel=100)
Setupmdb exit /B return code=110

Solution:

SETUPMDB.BAT may need to be run by adding the "-DBPORT" and -"DBHOST" option to provide the correct port number for some SQL server installations if the default SQL port is changed or a named instance of SQL Server is used.

For example, if the SQL Server DBMS server listens for connections on port 1455, instead of on the default port 1433, then the setupmdb command would be run as follows:

setupmdb -DBVENDOR=mssql -JRE_DIR=C:\PROGRA~1\CA\SC\JRE\1.6.0_30 -DBUSER=sa -DBPASSWORD=sa -DBDRIVER=Service_Desk -WORKSPACE=Service_Desk  -DBHOST=SQLSERVER -DBPORT=1455

Note, in the example above, that the JRE_DIR is the out-of-the-box path for the JRE.  It is possible that it is different in your environment; you may verify it by comparing it to the value of NX_JRE_INSTALL_DIR that is specified in your NX.env file (but, notice that you must use backslashes in the path specified in the setupmdb command). 

Additionally, your environment may be using a different user other than "sa" (and of course, a different password), so these should be entered according to what is correct for your environment.

Run SETUPMDB.BAT -help to list all options.

For additional information on SetupMDB, please see TEC617177.