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

Products

CA Client Automation - IT Client Manager

Issue/Introduction

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.

Environment

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

Resolution

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

1. 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 Next>

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