Unified Communications Manager Configuration

Note For the Unified Communications Manager versions that Service Monitor supports, see Release Notes for Cisco Unified Service Monitor 2.0.1.

Service Monitor can collect and analyze data from Unified Communications Managers only if you first configure Unified Communications Manager systems as described in these topics:

Configuration Tasks for Supported Unified Communications Manager Versions

For Service Monitor to obtain CVTQ data from a Unified Communications Manager, you first need to perform configuration tasks while logged in to:

•

Unified Communications Manager—To access Unified Communications Manager Administration and Unified Communications Manager Serviceability.

•

The server where Unified Communications Manager is installed—To access Microsoft SQLServer.

Depending on the Unified Communications Manager version that you use, you need to perform some subset of the tasks listed in this section. Where tasks themselves differ slightly from one Unified Communications Manager version to another, version-specific steps are noted in the procedures.

Table B-1 lists the configuration tasks you must complete for each version of Unified Communications Manager that you want Service Monitor to obtain CVTQ data from.

Table B-1 Unified Communications Manager and Microsoft SQLServer Tasks
Configuration Task	Perform Task for These Unified Communications Manager Versions:
Configuration Task	6.x	5.x	4.x	3.3.x
Configure Unified Communications Manager
Setting Unified Communications Manager Service Parameters	X	X	X	X
Setting Unified Communications Manager Enterprise Parameters	X	X	X	X
Adding Service Monitor to Unified Communications Manager 5.x (or 6.x) as a Billing Server	X	X	—	—
Configure Microsoft SQLServer on the Server with Unified Communications Manager
Enabling Mixed Authentication in Microsoft SQL Server for Unified Communications Manager 4.x Caution Failure to complete this task as documented can prevent Unified Communications Manager from writing CDRs.	—	—	X	— Note Mixed authentication should be configured for 3.3.x by default. If it is not, you can use this procedure to configure mixed authentication for 3.3.x.
Adding Microsoft SQLServer User Accounts Caution Failure to complete this task as documented can prevent Unified Communications Manager from writing CDRs.	—	—	X	X

Configuring Unified Communications Managers

Setting Unified Communications Manager Service Parameters

Note Set these parameters on each Unified Communications Manager in a cluster.

•

For Unified Communications Manager 3.3 and 4.x, select Service > Service Parameters.

•

For Unified Communications Manager 5.x and 6.x, select System > Service Parameters.

Select the name of the Unified Communications Manager server. This is a Unified Communications Manager from which Service Monitor will gather data.

–

Call Diagnostics Enabled—Scroll down to Clusterwide Parameters (Device - General). Set to True.

–

Call Diagnostics Enabled—Scroll down to Clusterwide Parameters (Device - General). Set to Enable Only When CDR Enabled Flag is True.

Setting Unified Communications Manager Enterprise Parameters

Perform this procedure for Unified Communications Manager versions 3.3, 4.x, 5.x, and 6.x.

Step 2

Select System > Enterprise Parameters. The Enterprise Parameters Configuration page appears.

•

For Unified Communications Manager 5.x and 6.x, set CDR File Time Interval (min) to 1.

Adding Service Monitor to Unified Communications Manager 5.x (or 6.x) as a Billing Server

Note

•

Perform this task on Unified Communications Manager version 5.x and 6.x only.

Step 3

Scroll down to Billing Applications Server Parameters and click Add New.

•

Host Name / IP Address—Enter the IP address of the system where Cisco Unified Service Monitor is installed.

•

Password—Enter a password. The default password is smuser. To change this password:

–

Enter the same password that you entered for smuser while configuring other settings in Service Monitor.

Note

If you changed the password in Service Monitor and Unified Communications Manager does not immediately accept the new password, wait one minute and enter the new password again.

Note In some cases, for CDR/CMR files to be delivered to a newly added billing server, it is necessary to first restart the CDR Repository Management Service.

Step 1

From Unified Communications Manager Serviceability, select Tools > Control Center - Network Services.

Step 2

From the list of Unified Communications servers, select the publisher.

Changing the Password for smuser in Unified Communications Manager 5.x and 6.x

Note Perform this task on Unified Communications Manager versions 5.x and 6.x only.

The SFTP password for smuser in Service Monitor and the password for the Service Monitor Applications Billing Server smuser in Unified Communications Manager 5.x and 6.x must be identical. Any time you change one, you must change the other to match. To change the SFTP password for smuser in Service Monitor, see Configuring and Viewing Other Settings.

Use this procedure to change the password for the Service Monitor Applications Billing Server smuser in Unified Communications Manager 5.x and 6.x.

Step 3

Scroll down to Billing Applications Server Parameters and double-click the link for the Service Monitor.

Note

If you changed the password in Service Monitor and Unified Communications Manager does not immediately accept the new password, wait one minute and enter the new password again.

Do not change the values in any other fields; Host Name / IP Address, User Name, SFTP Protocol, and Directory Path must remain the same.

Configuring MicroSoft SQLServer on a Unified Communications Manager System

Enabling Mixed Authentication in Microsoft SQL Server for Unified Communications Manager 4.x

Step 1

Step 2

Select Start > Programs > Microsoft SQL Server Enterprise Manager.

Step 3

Select Console Root > Microsoft SQL Servers > SQL Server Group and right-click (local). A dialog box appears.

Click OK. A message appears, asking whether to restart the SQL server. Click No.

Note

If Cisco Security Agent runs on the Unified Communications Manager server, it might block the message that asks whether to restart the SQL server and the change is not applied. To work around this problem, open Windows Services user interface and stop Cisco Security Agent. After you complete steps 4 b and 5, restart Cisco Security Agent.

Select Start > Settings > Control Panel > Administrative Tools > Services. The Services window appears.

Right-click MSSQLSERVER and click Stop. A list of services that will be stopped in addition to MSSQLSERVER will be displayed. Note them; you will need to start each one in step 5 c.

Right-click MSSQLSERVER and click Start. For each of the additional services that were stopped during the previous step, right-click the service and click Start.

Adding Microsoft SQLServer User Accounts

Add Microsoft SQLServer user accounts for Unified Communications Manager 3.x and 4.x as directed in this topic.

Service Monitor needs a Microsoft SQLServer user account to access local databases on the system with Unified Communications Manager. Use this procedure to add user accounts on these Unified Communications Manager versions:

•

3.3.x—Add an account to enable Service Monitor to access the CDR database and the device database, named CCM030n; for example, CCM0300. Alternatively, add two accounts: one for the CDR database and another for the CCM030n database.

Step 1

Step 2

Select Start > Programs > Microsoft SQL Server Enterprise Manager > Security.

Note

Make sure that SQL Authentication is selected and not Windows Authentication, which can sometimes be selected by default.

Step 5

Select the Server Roles tab and select the System Administrators role.

–

For Unified Communications Manager version 4.x, check the Permit column for the CDR database.

–

For Unified Communications Manager version 3.3.x, check the Permit column for the CDR database and for the device database, named CCM030n; for example, CCM0300. Alternatively, select only one database, CDR or the device database, and continue creating the account. After creating one account, repeat the procedure to create another account for the other database.

Note

Each time you upgrade Unified Communications Manager, the n in CCM030n is increased by 1 and a new device database is created. If there are multiple device databases, choose the most recent one (the one with the highest number); for example, CCM0302. If you upgrade Unified Communications Manager 3.3 after you complete this step, you must return to this procedure and repeat this step ( Step 6).

Note

Alternatively, select only one database, CDR or the device database, and continue creating the account. After creating one account, repeat the procedure to create another account for the other database.

At the bottom of the window, database roles for the selected databases are displayed; public is checked by default.

Step 8

Confirm the password (previously entered in step 4 b) by entering it again in the dialog box.

Table Of Contents