Installing sql server on a remote server, Creating a least privileged sql account – Cisco Conference Phone User Manual
Page 23
2-5
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
•
Installing Cisco Unified MeetingPlace Audio Server Release 5.3, page 2-5
•
(Optional)
Installing SQL Server on a Remote Server, page 2-5
•
Creating a Least Privileged SQL Account, page 2-5
•
Gathering Cisco Unified MeetingPlace Web Conferencing Installation Values, page 2-7
Installing Cisco Unified MeetingPlace Audio Server Release 5.3
You must install and configure the audio server software on a Cisco Unified MeetingPlace 8100 series
server before you begin your Release 5.3 installation. For installation instructions, see the
Installing SQL Server on a Remote Server
Cisco Unified MeetingPlace Web Conferencing requires SQL Server. You can choose to install SQL
Server (or MSDE) on either the same machine as Cisco Unified MeetingPlace Web Conferencing or on
a separate machine. If you choose to install SQL Server on a separate machine, install both SQL Server
2000 and the appropriate Service Pack on a separate Windows machine before installing Cisco
Unified MeetingPlace Web Conferencing. This can be a Cisco MCS or legacy non-Cisco MCS.
Note
While we support Microsoft SQL Server Database Engine (MSDE), we strongly recommend that all
Cisco Unified MeetingPlace systems, particularly production systems, use a fully licensed SQL Server.
Creating a Least Privileged SQL Account
By default, Cisco Unified MeetingPlace Web Conferencing uses the SQL and MSDE built-in sa
administrator account to connect to its database. Depending on your server hardware and the options that
you choose during installation, Cisco Unified MeetingPlace Web Conferencing may install SQL or
MSDE for you. For more information about SQL and MSDE installation, see the
Integration” section on page 2-1
During the SQL or MSDE installation, you will be asked to set a password for the sa account. Be sure
to set a strong password, without spaces. Often, a strong password is sufficiently secure to protect your
system from unauthorized access. However, if you do not want to use a SQL account that has full
administration rights, you can create a least-privileged SQL account for use by Cisco
Unified MeetingPlace Web Conferencing.
Caution
If you choose to create a SQL account that is dedicated to Cisco Unified MeetingPlace Web
Conferencing use, ensure that it meets all the specified requirements in this procedure. Failure to do so
can cause a database connection failure between Cisco Unified MeetingPlace Web Conferencing and the
SQL Server and result in a total outage or broken features.