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

book

Article ID: 17125

calendar_today

Updated On:

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:

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