Cisco Systems Conference Phone manual Assigning Installation and Ongoing Rights, Procedure

Page 24

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.

Installation and Upgrade Guide for Cisco Unified MeetingPlace Web Conferencing Release 5.3

2-6	OL-10029-01

Image 24

Contents Corporate Headquarters Copyright 2004-2006 Cisco Systems, Inc. All rights reserved N T E N T S About the SMA-2S Configuration with SSL and Segmented DNS Releases What to Do First Preface Naming Conventions Term DefinitionAdditional References Preface Additional References About Cisco Unified MeetingPlace Configuration Restrictions Terms for Single Sign On Software IntegrationTerms of Support for Single Sign On Software Integration New Features and Enhancements in Release Feature DescriptionFeature Description New Features and Enhancements in Release New Features and Enhancements in Release Feature Description About SQL Server Integration Msde Database Size Related TopicsAbout SQL Server Installation Options If the following conditions are metAbout Sun Java Runtime Environment Installing Cisco Unified MeetingPlace Audio Server Release Installing SQL Server on a Remote ServerCreating a Least Privileged SQL Account Assigning Installation and Ongoing Rights ProcedureTroubleshooting Tips RestrictionsInternal Full Access Installing the Operating System on the Cisco MCS Server Before You Begin Restriction Procedure Testing the Web Server Over an Http Connection Testing the Web Server Over an Https Connection Testing the Meeting Console ConnectionAbout Segmented Meeting Access About the SMA-1S Configuration LAN/WAN DMZAbout the SMA-2S Configuration About the SMA-2S Configuration with SSL and Segmented DNS ExampleGathering Basic Information About Your Web Server What to Do Next Information, see the About SQL Server Integration section on Restrictions Before You Begin OL-10029-01 A P T E R Cisco Unified MeetingPlace Web Conferencing Clusters One Cluster Configuration 121506 Then InternalDefault Behavior of Load Balancing in Video-Enabled Systems Suggestions for a Robust Cisco Unified MeetingPlace SystemVideo Meetings in Segmented Meeting Access Deployments SQL Server ConsiderationsInstall the first internal web server End-User ConsiderationsPreparing the Internal Cluster Preparing the External Cluster Creating a Common Storage Location Installing the First Internal Web Server Configuring Services for the First Internal Web ServerProcedure Installing Additional Internal Web Servers Registry Key ActionInstalling the First External Web Server Copying Guids From the Internal to the External Web ServerConfiguring Services for the First External Web Server Procedure Installing Additional External Web Servers Configuring Redirection of External Meetings Configuring Ad-Hoc Video Meetings Viewing the Amount of Web-Conferencing Load on a Server Disabling Load BalancingOL-10029-01 A P T E R User Authentication Methods in Release 5.3235 and Later Load Balancing in Release 5.3333 and LaterRight-clickMPWEB and choose All Tasks Backup Database Backing Up the Mpweb Database and MPWEB-Slave DatabaseBacking Up Cisco Unified MeetingPlace Registry Information Open ExplorerThis section contains the following procedures Upgrading a Standalone Web Server Restrictions Upgrading Web Servers Sharing the Same Database Uninstalling Cisco Unified MeetingPlace Web Conferencing Click Change/RemoveReboot your server Removing SQL Server or MsdeWhat to Do First Checking the Cisco MCS Operating System Release Locating the Software Download Page on Cisco.comObtaining Additional Assistance Resolving Http Connection Problems Resolving Https Connection ProblemsOL-10029-01 D E IN-2 IN-3 IN-4