Cisco Conference Phone - Manual (Page 24)

2-6
Installation and Upgrade Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3
OL-10029-01
Chapter 2 Installing Cisco Unified MeetingPlace Web Conferencing Release 5.3
Preinstallation Tasks: Cisco Unified MeetingPlace Web Conferencing Release 5.3
Note If Cisco TAC determines that your SQL account does not meet the requirements specified in this guide,
you will be asked to reconfigure your SQL account and to delete any existing Cisco
Unified MeetingPlace Web Conferencing database so that a new database can be created once the
account problem is remedied.
The Cisco Unified MeetingPlace Web Conferencing installer does not verify the existence of the SQL
account or the validity of its username-password combination. As such, you must verify that the SQL
Server account that you plan to use exists and that it conforms to the required access rights before you
install Cisco Unified MeetingPlace Web Conferencing. Therefore, to create a SQL account that you can
use to access the Cisco Unified MeetingPlace database with authentication, complete the following
procedures:
• Assigning Installation and Ongoing Rights, page 2-6
• Assigning Server and Database Roles, page 2-6
Assigning Installation and Ongoing Rights
During the installation of Cisco Unified MeetingPlace Web Conferencing, you are prompted to enter a
SQL Server username and password. This SQL Server user must have the right to log in to the SQL
Server instance that you specify during the installation. To assign and verify rights, complete the
following procedure.
Procedure
Step 1 Assign the following additional rights to the SQL Server user:
• Create Database
• Create Table
• Create Default
Step 2 (Optional) After the installation is complete, remove the Create Database right from this SQL Server
user.
Step 3 Verify that the SQL Server user has the following rights for all tables in the MPWEB database:
• Select
• Insert
• Update
• Delete
Note This user must be able to alter the MPWEB database.
Step 4 Proceed to “Assigning Server and Database Roles” section on page 2-6 .
Assigning Server and Database Roles
SQL Server provides some built-in roles that simplify the process of granting and denying rights.