SDM 17.3 installation failed with an Integration error

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

When installing the SDM 17.3, the following error message appears on the Integration step.

Integrations of the products has failed, for the below tasks:

Export Service Desk Manager Policy File
Restart CA Service Desk Manager Services.

Would you like to continue with the remaining installation?

The install.log shows:

2023/07/09 12.25.28.376 ERROR [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] Error occured during the validation of the endpoints : Unable to connect to CA Service Desk Manager on server SDMSRV
2023/07/09 12.25.28.376 ERROR [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] will continue executing the next integration Task
...
2023/07/09 12.29.35.570 ERROR [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] Failed Auto-Integration Tasks list : [ExportSDMPolicyFile, RestartSDMServices]
2023/07/09 12.49.25.125 ERROR [DeployThread: Integrating the Product(s)] [AutoIntegrateTask] Installation was success but one or more integration tasks failed, please see log for more details

If the command sql_check_db (e.g. sql_check_db -c -s SDMSRV) is executed on the SDM server, the following error comes up.

ERROR: AHD50072: Unable to log in to SQL Server

Environment

Release : 17.3, SQL2019 (running on a separate machine from a SDM server)

Resolution

Only Microsoft SQL Management Studio was installed on the SDM server. SQLCMD utility and SQL Client Tool need to be installed on the SDM server too.

Additional Information

Can't connect to the database - Installation Error