Cisco Unified Communications Manager version 4.x does not permit connections to SQL Server using SQL authentication. You must connect using Windows authentication.
Before running the AddDataSource_CiscoCallMgr Knowledge Script, take the following steps to grant the minimum permissions that allow the Call Data Analysis module to function properly.
Use the following steps to create a user account that has minimal permissions on the CallManager server. The new account can access only specific databases in SQL Server, and has read-only permission. It cannot change data and has no other authority on the CallManager server.
To set permissions on the CallManager server:
Navigate to the Control Panel, double-click Administrative Tools, and then double-click Computer Management.
Expand Local Users and Groups and click Users.
In the right pane, right-click anywhere and select New User.
Type the user name and password of the user for whom you are setting permissions.
Ensure the User must change password at next logon option is not selected.
Click Create and then click Close.
Start the Microsoft SQL Server Enterprise Manager application.
In the left pane, expand Microsoft SQL Servers > SQL Server Group > [local computer name] (Windows NT) > Security > Logins.
In the right pane, right-click anywhere and select New Login.
In the Name field, select the name you added in steps 3 - 6.
Click Add and then click OK.
In the New Login dialog box, select Windows Authentication.
On the Database Access tab, select the options in the Permit column for the following databases:
master
CDR
All databases that begin with “CCM”
For each database you permit, select db_datareader in the Permit in Database Role list.
Click OK.
Use the following steps to set SQL Server Agent logon permissions for the same user account you created in Section 2.11.1, Setting Permissions on the Communications Manager Server. Ensure you secure the password so no unauthorized person can log onto the Data Mart computer using the new account.
To set permissions on the Data Mart computer:
In Control Panel, double-click Administrative Tools, and then double-click Computer Management.
Expand Local Users and Groups and click Users.
In the right pane, right-click anywhere and select New User.
Type the user name and password of the user for whom you are setting permissions.
Ensure the User must change password at next logon option is not selected.
Click Create and then click Close.
In the left pane of the Computer Management window, click Groups, and then double-click Administrators in the right pane.
Click Add, select the new user name from the list, and then click OK.
Navigate to the Control Panel, double-click Administrative Tools, and then double-click Services.
Double-click SQLSERVERAGENT, and then click the Log On tab in the Properties dialog box.
Select This account and then click Browse.
In the list of names, double-click the new user name.
Type the new password in the Password and Confirm password fields, and then click OK.
In the Services window, right-click SQLSERVERAGENT and select Restart.