Installation Guide

27 Installation Guide for Cisco Unified Contact Center Management Portal 7.2(3)
2. Run services.msc, locate the SQLSERVERAGENT service and edit its
properties to use the <DOMAIN>\SQLAgentStart user
3. Open SQL Server Enterprise Manager, navigate to the Security
folder, and add the SQLAgentStart user to SQL Server logins
4. On the Database Access tab, give the SQLAgentStart user access to
the Unified Contact Center Management Portal database with the
db_datawriter and db_datareader roles
5. Open the Local Security Policy tool to give the SQLAgentStart user
log on as a service privileges
6. Log out of Windows and login as the new SQLAgentStart user
7. On the subscriber, locate the ReplData folder (this is configured in
SQL Server, and by default can be found in C:\Program
Files\Microsoft SQL Server\MSSQL). Create a share for this folder
with Full Control for Everyone
8. Check that this share is accessible from the publisher while logged on
as the SQLAgentStart user and that you can create and delete files in it
9. On the publisher, open the SQL Server Query Analyzer and check
connectivity to side B using Integrated Security
10. Check the reverse is the same (side B connectivity to side A)
The Cluster Configuration Manager is used to replicate data between
Unified Contact Center Management Portal master and slave databases,
which are called the Publisher and Subscriber databases respectively.
Before data replication between Unified Contact Center Management
Portal databases can be performed, the server(s) in the cluster must first be
setup with all the required prerequisite software and Unified Contact
Center Management Portal components. Once prepared the servers need to
be assigned publisher or distributor (subscriber) roles. See Tab 2 –
Databases on page 31.
Note The user running the Cluster Configuration Manager requires
administrative privileges to connect to both publisher and subscriber
servers using Windows Authentication and also requires access to the
Unified Contact Center Management Portal database.
1. Test the connectivity between both machines. Login to both sides
using the above domain account and test whether you can connect to
SQL Server (from both sides) using Windows Authentication.
2. Now log back onto both machines as the domain administrator
You are now prepared to set up replication as part of cluster configuration.
Platform Server Cluster Configuration
Large deployments may require multiple servers to host the Unified
Contact Center Management Portal platform to improve performance or
data security. The platform hosts are connected together as a server
cluster. This section details how to configure the Unified Contact Center
Management Portal server cluster and data replication.