Cisco Cisco Agent Desktop 8.5 Guia Da Instalação

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 

 through 

 above, using the following 

configuration:

■

For the Ad Hoc Remote Queries component, clear the Enable OPENROWSET 
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 

 through 

 from the installation process above 

to turn these options back on.

For more information on best practices for database security, refer to the following 
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.

NOTE:  You must use a named instance. You cannot use the default 
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.