installation failed with an Integration error

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

When installing the Service Desk Manager, 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 [EXAMPLE SDM SERVER]
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 [EXAMPLE SDM SERVER]) 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.

The easiest way to ensure the components are obtained is to install SQL Server Management Studio