[cisco-voip] Unified MeetingPlace - Requirements for off-box SQL Server

[Dana Tong]

Hi all,

 

>From the release notes on the cisco wiki, it appears that you can
install MeetingPlace (Enterprise) with MS SQL 2005 Standard Edition (so
long as you install the backward compatibility components). 

There's no real mention of a requirement for SQL Enterprise edition in
the release notes. 

 

Can anyone please confirm the following?

1/ That MS SQL 2005 Standard is ok to use (so long as you install the
backward compatibility component)

2/ Can you use SQL Express 2005 in a LAB environment? (for proof of
concept/ pre-staging)

3/ What is a typical size of the database? I'm assuming that only
configuration data is stored in the database so it should be quite
small? (That and the fact that if you install on-box SQL it's using MSDE
which has a limit of 2Gigabytes)

 

Thanks

Dana

 

http://docwiki.cisco.com/wiki/Cisco_Unified_MeetingPlace,_Release_7.0_--
_Hardware_Requirements#Operating_System_Requirements

SQL Server Requirements 

Cisco Unified MeetingPlace Web Conferencing requires Microsoft SQL
Server 2000 (Service Pack 4). During the installation, you can choose
the local SQL Server option or the remote SQL Server option: 

*	If you choose the local SQL Server option, the system
automatically installs SQL Server 2000 (Service Pack 4) during the Web
Conferencing software installation. Microsoft SQL Server 2000 (Service
Pack 4) is included in the Web Conferencing Release 7.0 installer. 

*	If you choose the remote SQL Server option, you must install SQL
Server 2000 (Service Pack 4) before you install Web Conferencing. You
must also install and configure your SQL Server to be case insensitive
because Web Conferencing supports only SQL Server case-insensitive
configurations. If you configure your SQL Server to be case sensitive,
Web Conferencing will not function properly. 

*	If you choose the remote SQL Server option with Microsoft SQL
Server 2005 as the backend server, you can use SQL Server 2005 (Service
Pack 2) instead of SQL Server 2000 (Service Pack 4). 

To use remote Microsoft SQL Server 2005, you must first use the
Microsoft installation program called SQLServer2005_BC.msi (Microsoft
SQL Server 2005 Backward Compatibility Components) to install the
version of SQL Distributed Management Objects (DMO) that is compatible
with Microsoft SQL Server 2000 onto the Cisco Unified MeetingPlace Web
Conferencing server. You only need to upgrade the SQL-DMO part and not
the other four components covered by this installation program. 

 

 

SQL Server Requirements-Remote (Off Box) SQL Installation 

For better performance, install full customer provided software and
hardware SQL Server 2000 or 2005 (in backward compatibility mode)on a
separate server before installing Cisco Unified MeetingPlace Web
Conferencing. During the Web Conferencing installation, you specify the
SQL Server installation location as Remote. 

You may choose to deploy more complex, remote SQL Server topologies,
such as a server farm. To properly operate in a remote SQL Server
configuration, Cisco Unified MeetingPlace Web Conferencing requires an
Open DataBase Connectivity (ODBC) Data Source Name (DSN) that points to
an installation of Microsoft SQL Server 2000 with Service Pack 4 or
Microsoft SQL Server 2005 with Service Pack 2 (in backward compatibility
mode) with correct permissions to the MPWEB database, and on the Cisco
Unified MeetingPlace Web Server the Microsoft SQL Server 2005 backward
compatibility software - DMO (Distributed Management Objects) component.


In such a topology, customers are responsible for supporting and
ensuring the stability and performance of the remote SQL Server
deployment. Any decrease in SQL Server transaction performance or
network latency between the Cisco Unified MeetingPlace Web Conferencing
server and the remote SQL Server can have a negative impact on Web
Conferencing performance up to and including a complete system outage
depending on the scale of the slow down. Cisco assumes that the SQL
environment is appropriately sized and properly installed by the
customer prior to installing Cisco Unified MeetingPlace Web
Conferencing, and is monitored and maintained properly after installing
Web Conferencing. 


NOTE: You must install and configure a remote SQL Server to be case
insensitive because Web Conferencing supports only SQL Server
case-insensitive configurations. If you configure your SQL Server to be
case sensitive, Web Conferencing will not function properly. 

 

 


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100309/638e7b0f/attachment.html>