Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Administrator's Guide

Page of 448
 
Chapter 5      Provisioning Additional Subsystems
Provisioning the Database Subsystem
5-12
Cisco Customer Response Solutions Administration Guide, Release 6.0(1)
Provisioning the Database Subsystem 
Note
The database subsystem is available only if your system has a license installed for 
the Unified IP IVR and Unified CCX Premium packages.
The Cisco CRS system uses the Database subsystem to enable CRS applications 
to interact with database servers in order to make database information accessible 
to contacts. 
Tip
If the enterprise database is an external SQL server, then you must configure this 
SQL server to run in SQL Mixed Mode Authentication. 
Note
In CRS 4.0, SQL Server 2000/MSDE was installed in Windows mode 
authentication.
In CRS 4.1 standalone installations, SQL Server 2000/MSDE is installed in 
Mixed mode authentication on CRS servers with CRS Engine and CRS datastores 
activated or CRS server with just CRS datastores activated). Despite this 
difference in authentication modes, almost all CRS components accessing SQL 
Server 2000/MSDE 2000 continue to use Windows authentication mode, as in 
CRS 4.0. Only the CRS configuration datastores (CDS), Cds1LinkedServer (a 
linked server used for CDS data replication), is configured to use SQL 
Authentication.
CRS 4.1 co-resident deployments (Unified CM with CRS) continue to have the 
same authentication setup as CRS 4.0.
To provision the Database subsystem, you will need to perform the following 
tasks:
1.
Define an Open Database Connectivity (OBDC) data source. The ODBC data 
source name provides information to Microsoft Windows about how to 
connect the application server to an enterprise database such as Microsoft 
SQL Server, Sybase, Oracle, or IBM DB2.