Cisco Cisco Agent Desktop 10.0 インストールガイド
Configuring Microsoft SQL Server
October 16, 2015
55
enabled earlier. To do this, repeat steps 29 through 30 above, using the following SQL
statements:
statements:
-- To disable xp_cmdshell.
EXEC sp_configure 'xp_cmdshell', 0
GO
-- To disable OPENROWSET and OPENDATASOURCE.
EXEC sp_configure 'Ad Hoc Distributed Queries', 0
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
-- To prevent advanced options to be changed.
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 that
require you to administer the Recording and Statistics Database
connection through the CAD Configuration Setup Utility, you must
again complete steps 29 through 30 from the installation process
above to turn these options back on.
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 29 through 30 from the installation process
above to turn these options back on.
For more information on best practices for database security, refer to the topic
“Securing SQL Server” on the Microsoft Developer Network, located at:
“Securing SQL Server” on the Microsoft Developer Network, located at:
If you are upgrading from an older version of SQL Server (versions 2005–2012) to
SQL Server 2008 R2 or SQL Server 2014 and newer) on the same system, you can do
an over-the-top upgrade.
SQL Server 2008 R2 or SQL Server 2014 and newer) on the same system, you can do
an over-the-top upgrade.
■
SQL Server 2008 R2 is supported by CAD 10.0(1) and CAD 10.0(2)
■
SQL Server 2014 is supported by CAD 10.0(2) and newer