Installation Guide
Step 3. Granting the New User Access to the
Unified CCX Database
NOTE: The following procedure is written assuming that the
Unified CCX database is in Microsoft SQL Server 2000.
To grant the new user access to the Unified CCX database:
1.On the Unified CCX server, start Microsoft SQL Server Enterprise Manager.
2.Under the Unified CCX instance, choose Security > Logins. A list of Windows and SQL Server users who have permission to access the databases in this instance appears.
3.
4.Click the button to the right of the name field to browse for the new user you created in Step 1 (page 43). A second SQL Server Login Properties - New Login dialog box appears.
5.Select the machine name from the List Names From list. A list of users and groups defined on the machine appears.
6.Select the new user, then click Add. The user name appears in the Add Name field.
7.Click OK to dismiss the second SQL Server Login Properties - New Login dialog box.
8.On the Database Access tab, select the Permit check box for the side A database, then select the Permit in Database Role check box for db_datareader.
9.If there is a side B database, select the Permit check box for the side B database, then select the Permit in Database Role check box for db_datareader.
10.Click OK to dismiss the SQL Server Login Properties - New Login dialog box.
11.Choose Console > Exit to close SQL Server Enterprise Manager.
46 | October 2007 |