What is required by Service Management installer in a SQL Server MDB environment

Products

• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager
• CA Service Catalog

Issue/Introduction

What is required by the Service Management installer when a remote SQL Server is used for the MDB?

Environment

Service Desk Manager 14.x or 17.x

SQL Server 2014, 2016 and 2019

Resolution

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

In an Advanced Availability (AA) environment, the client tools need to be installed on the Standby server, Background server, and all App servers.

In a Conventional architecture, the client tools need to be installed on the Primary server.

The SQL Client tools and Management tools are needed for the SQL command-line utilities.

If you do not want to install these components for command line, use the Microsoft ODBC driver 13.1 for Microsoft SQL Server and download the following from the Microsoft Download Center:

• Microsoft ODBC Driver 13.1 for Microsoft SQL Server
• Microsoft Command Line Utilities 14.0 for Microsoft SQL Server
• Microsoft SQL Server Management Studio (SSMS)

Additional Information

SDM SQL Server (2014, 2016, or 2019) Database Requirements

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