Installation Guide
46 October 2007
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. Right-click Logins and choose New Login. The SQL Server Login Properties -
New Login dialog box appears.
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.