search cancel

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


Article ID: 17125


Updated On:


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


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


Service Desk Manager 14.x or 17.x

SQL Server 2014, 2016 and 2019


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