Cisco Cisco Agent Desktop 9.0 Installationsanleitung

Cisco CAD Installation Guide

52

August 4, 2014

EXEC sp_configure ‘show advanced options’, 0

GO

-- To update the currently configured value for advanced options.

RECONFIGURE

GO

NOTE:  If you turn off the xp_cmdshell and Ad Hoc Distributed Queries 
options after the installation of CAD and later run into issues which 
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:

■

http://msdn.microsoft.com/en-us/library/bb283235%28v=sql.105%29.aspx

■

http://msdn.microsoft.com/en-us/library/ff648664.aspx

Upgrading from SQL Server 2005

If you are upgrading from SQL Server 2005 to SQL Server 2008 R2 on the same 
system, you can do an over-the-top upgrade.

1. Start the SQL Server 2008 R2 installer (setup.exe). 

2. On the SQL Server Installation Center window, select Installation in the left 

navigation pane.

3. Select Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008 

to SQL Server 2008 R2. The SQL Server 2008 R2 Setup window appears. 

4. Accept the prompts and allow the support files to install.

5. Select the SQL Server instance that CAD is using.

6. Accept the prompts. Close the window.

There is no further configuration or replication setup required.