What is required by Service Management installer in a SQL Server 2014 or 2016 environment

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Database Requirements:
If you want to use a remote MDB, the database client SQL Server must be installed on the same computer where you install CA SDM.

We need Client tools on standby server, background server and app servers in Advanced Availability mode. If Conventional mode, we need Client Tools on Primary server.

NB: We need command line utilities when installing or configuring the server (pdm_configure).

What is required by Service Management installer in a SQL Server 2014 or SQL Server 2016 environment ?

Environment

Service Desk Manager 14.x or 17.x Windows with SQL Server 2014 or 2016

Resolution

We need Client tools and Management tools (for command line utilities).

If you don't want to install those components, you may use the

Microsoft® ODBC Driver 13.1 for SQL Server 

https://www.microsoft.com/en-us/download/confirmation.aspx?id=53339

and

Microsoft® Command Line Utilities 13.1 for SQL Server®

https://www.microsoft.com/en-us/download/confirmation.aspx?id=53591

Additional Information

https://connect.microsoft.com/SQLServer/feedback/details/845620/sqlcmd-exe-relocated-in-2014-installation