What are the steps to install CA Client Automation 12.9 Domain Manager with a remote SQL Server Database?
search cancel

What are the steps to install CA Client Automation 12.9 Domain Manager with a remote SQL Server Database?


Article ID: 144982


Updated On:


CA Client Automation - IT Client Manager


With the release of CA Client Automation 12.9, it is now supported to install the MDB to a remote database from the installer
on the application server. This document will list the prerequisites for and steps to install of a 12.9 Domain Manager using
a remote SQL Server that will host mdb.


Client Automation - r12.9, r14.0, r14.5


Prerequisites for installation with Remote mdb database 

  •  SQL client connectivity
  •  SQL Management Tools
  •  Logged on to Domain Manager with a Windows account with Local Administrator Rights on the SQL Server
  •  The account used in # 3 must have SQL Server Role "SYSADMIN" assigned to it

 On the Domain Manager, install the SQL Client and the SQL Management Tools by running setup.exe from the SQL installation media.

Check the boxes next to "Client Tools Connectivity" and "Management Tools - complete" and click next and follow prompts:

You should get a message once the install completes like this

2. Verify that the account performing the install is listed in the local administrators group on the SQL server,
This is done by going to "Start -->Administrative Tools  -->Computer Management-->expand "Local users and Computers" -->Groups -->
Double click on "Administrators" make sure the account running setup of CA Client Automation is listed specifically, if not add it.

3. Go to SQL Management Studio and go under "Server Roles" double click on SYSADMIN make sure that the Windows account
who is running setup of Client Automation is assigned the SQL Server Role "SYSAMDIN" if not add it.

Steps to install a  CA Client Automation Domain Manager

Run Setup.exe from the root of the CA Client Automation DVD # 1 and choose to "Run this installation in English" or Applicable Language

Choose the first option - Install CA ITCM. In this scenario it is not necessary to do a separate 'Install MDB', it will be installed
automatically to the remote SQL server in the steps that follow:

Install Starts

Click Next>

Scroll down and accept the license agreement

Select the Options that are Applicable for your Environment and select Next>

Choose Custom Installation and click Next>

Select Domain Manager and any other Options that are applicable for your Environment  and click Next>

Fields explained:

Management Database Provider  - Choose Microsoft SQL Server

Management Database Server - this is where MSSQL is running and you should enter the Fully Qualified Domain Name (FQDN) of the SQL Server.

MDB Username - ca_itrm is the main SQL account for CA Client Automation

MDB Password and Confirm Password - the default password for this account is NOT_changedR11 but you can specify your own as desired. Be sure the password meets the server's password complexity requirements


Click Next>

On the Configure Microsoft SQL Server MDB screen enter the required fields as needed 


Options Explained:

Compatibility mode- Check this if you are going to be using this as a shared mdb database with other CA Products.
                                 This installs all tables to ensure other CA products will function correctly. 

MDB Database - Leave as mdb

MDB Instance Name - If connecting to a named instance of MSSQL specify the name of that instance. If connecting to the default instance leave as "default".

DB Port Number  - Specify the port utilized by SQL Server this should match what you setup in the SQL Connectivity Tools. 

Import Software Signatures during installation - specify if the installation should import the signatures or not.


 Click Next> after configuring this screen.

On the Configure the Scalability Server Screen enter the name of the local Domain Manager,  this is usually picked up by the Installer

Click Next>

On the Configure Agent Screen leave Scalability Server the name of the Domain Manager and click Next>

 On the Configure CA IT Client Manager

click Next>

Choose to accept the default install path shown or click on Advanced and choose the desired path and or different
drive letter and click on 

Review the details on the Installer Summary page and click Next>

The installer will begin installing the MDB to the remote sql server followed by the manager components on the
local application server.

The Install Summary screen appears review it for possible errors and make sure all installed correctly and click Next>

Click Finish

The Installer will now start up the DSM Services and will complete 

Post install steps to verify the installation Complete Successfully

  1.  Run camstat to verify that CAM is running
  2.  Open a command prompt and run CAF STATUS and verify all CAF plugins are started
  3.  Open the DSM Explorer and make sure that it launches successfully