Cisco Cisco MeetingTime Quick Setup Guide

Page of 766
Configuring Cisco Unified MeetingPlace Web Conferencing and SQL Server
How to Create and Use a Least-Privileged SQL Account for Web Conferencing
3
 
Procedure
Step 1
Open the SQL Server Enterprise Manager and create a new login:
a.
On the Start menu, select Programs > SQL Server 2000 > Enterprise Manager.
b.
Select a server group to expand it, then select the name of a server.
c.
Select Security > New Login
The SQL Server Login Properties window displays.
Step 2
Enter a name for the login on the General tab.
Step 3
Select SQL Server Authentication.
Step 4
Enter a password for the account.
Step 5
Select MPWEB from the Database drop-down menu to set the MPWEB database as the default database.
Step 6
Select the Database Access tab.
Step 7
Specify the database roles for the MPWEB database:
a.
Check the MPWEB database in the Databases table.
b.
Check the boxes for the following roles in the Database Roles table:
  –
db_datareader
  –
db_datawriter
  –
db_ddladmin
Step 8
Repeat 
Step 7
 for each additional MPWEB slave database. 
The slave databases have names that begin with “MPWEB_”. Depending on your deployment, your SQL 
Server will have either one or two slave databases.
Step 9
Select OK to complete the account configuration.
Updating SQL Account Access from the MeetingPlace Gateway Configurations 
Utility
The MeetingPlace Gateway Configurations utility allows you to update the Web Server with the 
least-privileged SQL login account that you have already created. It does not create a SQL Server login 
or update the SQL Server for you.
Before You Begin
Change the username and password on SQL Server. See the 
 for instructions.
Procedure
Step 1
Stop the Cisco Unified MeetingPlace Web Conferencing Service.
Step 2
Open the MeetingPlace Gateway Configurations utility.
Step 3
Select the Web Conferencing tab.