Cisco Cisco Agent Desktop 9.0 Guide De Montage
Configuring Microsoft SQL Server 2005 for CAD 8.5
March 31, 2014
47
After the CAD installation is completed in full and you have verified that the Recording
and Statistics Database is functioning normally (including replication, if applicable),
you can turn off the xp_cmdshell and Ad Hoc Distributed Queries options that you
enabled earlier. To do this, repeat steps
and Statistics Database is functioning normally (including replication, if applicable),
you can turn off the xp_cmdshell and Ad Hoc Distributed Queries options that you
enabled earlier. To do this, repeat steps
above, using the following
configuration:
■
For the Ad Hoc Remote Queries component, clear the Enable OPENROWSET
and OPENDATASOURCE support check box.
and OPENDATASOURCE support check box.
■
For the xp_cmdshell component, clear the Enable xp_cmdshell check box.
NOTE: If you turn off the xp_cmdshell and Ad Hoc Distributed Queries
options after the installation of CAD and later run into issues that
require you to administer the Recording and Statistics Database
connection through the CAD Configuration Setup Utility, you must
again complete steps
options after the installation of CAD and later run into issues that
require you to administer the Recording and Statistics Database
connection through the CAD Configuration Setup Utility, you must
again complete steps
through
to turn these options back on.
For more information on best practices for database security, refer to the following
resources:
resources:
■
■
Upgrading from CAD 7.6 or Earlier
In CAD 7.6 or earlier, the CAD database instance was required to be named CADSQL
and was in MSDE (Microsoft SQL Server Desktop Engine) format. In CAD 8.0 and
higher, MSDE is no longer used and the database instance can be named anything
you wish.
and was in MSDE (Microsoft SQL Server Desktop Engine) format. In CAD 8.0 and
higher, MSDE is no longer used and the database instance can be named anything
you wish.
NOTE: You must use a named instance. You cannot use the default
instance.
instance.
It is recommended that you back up the data in the CADSQL MSDE instance and
restore it to the new SQL Server instance (see the Cisco CAD Installation Guide for
your old version of CAD for information on backup and restore). If you choose to
continue using CADSQL as the instance name, after you have backed up the MSDE
instance, remove it. This must be done in order to avoid conflicts with the instance
names.
restore it to the new SQL Server instance (see the Cisco CAD Installation Guide for
your old version of CAD for information on backup and restore). If you choose to
continue using CADSQL as the instance name, after you have backed up the MSDE
instance, remove it. This must be done in order to avoid conflicts with the instance
names.