Cisco Cisco Unified IP Interactive Voice Response (IVR) 8.0(1) Administrator's Guide
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 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.
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.
SQL server to run in SQL Mixed Mode Authentication.
Note
In CRS 4.0, SQL Server 2000/MSDE was installed in Windows mode
authentication.
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.
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.
same authentication setup as CRS 4.0.
To provision the Database subsystem, you will need to perform the following
tasks:
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.
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.