Cisco Cisco Unified MeetingPlace Audio Server 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
2
 
Before You Begin
If you have SQL Server installed on a separate machine, make sure that the time on SQL Server is 
synchronized with the Cisco Unified MeetingPlace Application Server and Web Server.
Procedure
Step 1
Sign in to the end-user web interface.
Step 2
Select Admin.
Step 3
Select Database.
Step 4
Select a database command.
Step 5
Select Submit.
How to Create and Use a Least-Privileged SQL Account for Web 
Conferencing
By default, the Cisco Unified MeetingPlace Web Conferencing installer suggests using the SQL built-in 
sa administrator account as the SQL Server user name. Often, a strong password for the sa account is 
sufficiently secure to protect your system from unauthorized access. However, if you do not want to 
continue to use a SQL account that has full administration rights after the installation is complete, you 
can create a SQL account with minimal privileges that is dedicated for use with 
Cisco Unified MeetingPlace Web Conferencing, and configure the Web Server to use this account.
Complete the following procedures in the order shown to create and use a least-privileged SQL account:
  •
  •
Creating a Least-Privileged SQL Account for Web Conferencing
Caution
If you choose to create a SQL account that is dedicated for use with Cisco Unified MeetingPlace 
Web Conferencing, ensure that it meets all the specified database role requirements in this procedure. 
Failure to do so can cause a database connection failure between the web conferencing application and 
the SQL Server and result in a total outage or broken features. 
Note
If Cisco TAC determines that your SQL account does not meet requirements, 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.