Patch Manager installation error : Unable to retrieve Database details for the manager

Products

• CA Client Automation - IT Client Manager

Issue/Introduction

Following error occurs during installation of CA DSM Patch Manager :
Unable to retrieve Database details for the manager

In %TEMP%\DSMSetup.log there are following lines :

1: 9-8-2025 - 01:02:47 - INFO    - File: CAUniITRM_Setup.rul       - Line: 13650 - String('ID_STRING_PM_ERR_3') =XXX 'Unable to retrieve Database details for the manager '[1]' and hence Patch Manager installation will be skipped.' 

 

And in %TEMP%\PatchManagerSetupCmd.log : 

{9/8/2025-1:2.32} Attempting to connect to SQL Server...
{9/8/2025-1:2.32} Server: <SQLServerName>
{9/8/2025-1:2.32} Port: 1433
{9/8/2025-1:2.32} User: ca_itrm
{9/8/2025-1:2.32} Password: ********
{9/8/2025-1:2.32} Connection Timeout: 90
{9/8/2025-1:2.32} Url: jdbc:sqlserver://
{9/8/2025-1:2.47} com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host <SQLServerName>, port 1433 has failed. Error: "<SQLServerName>. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
{9/8/2025-1:2.47} Connection to sql server failed

Environment

Client Automation - All Versions

Resolution

Communication with SQL Server is not possible due to possible causes :

- DNS problem. Check if the SQL Server Name could be resolved as ipaddress (check with nslookup, ping etc...)
- Firewall problem. Check if the SQL Server port (by default TCP 1433) is not blocked by a firewall
- Check if Microsoft SQL Server is up and running.