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

Document ID : KB000029808
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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. 

 

Solution:

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:

SQL preqs.png

You should get a message once the install completes like this

Descriptionsql mgt tools sucessful.png\

2233

 

 

 

 

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.

sqlsecur.png

 

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

ss1.png

 

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:

ss2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Install Starts

ss3.png

 

Click Next>

ss4.png

Scroll down and accept the license agreement

ss5.png

 

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

ss6.png

Choose Custom Installation and click Next>

ss7.png

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

ss8.png

 

ss9a.png

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>

ss10.png

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.

SS11.png

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>

 

ss12.png

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

 

ss13.png

 On the Configure CA IT Client Manager

click Next>

 

ss14.png

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>

 

ss15.png

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.
 

ss16.png

 

ss17.png

ss18.png

 

ss19a.png

 

ss20.png

 

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

ss21.png

Click Finish

ss23.png

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

ss24.png

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