Cisco Cisco Agent Desktop 9.0 설치 가이드
Configuring Microsoft SQL Server 2008 R2 for CAD 9.0
August 4, 2014
51
section, if present. Take note of the port number. You will enter it in the
CAD Configuration Setup utility (the IP addresses are autofilled from
system information). Click Apply and then click OK.
CAD Configuration Setup utility (the IP addresses are autofilled from
system information). Click Apply and then click OK.
NOTE: CAD cannot use the same port that another SQL instance is
using. If another SQL instance is using the port that is entered on the
Recording and Statistics Database Configuration node of the CAD
Configuration Setup utility, the value in the CAD Configuration Setup
utility must be changed to use a different port.
using. If another SQL instance is using the port that is entered on the
Recording and Statistics Database Configuration node of the CAD
Configuration Setup utility, the value in the CAD Configuration Setup
utility must be changed to use a different port.
NOTE: After you specify the named pipe or port, you must restart the
SQL Server and SQL Server Agent services that correspond to the
CAD SQL named instance and the Generic SQL Server Browser
service. You can do this by selecting SQL Server Services in the
navigation tree, right-clicking on these services, and then selecting
Restart.
SQL Server and SQL Server Agent services that correspond to the
CAD SQL named instance and the Generic SQL Server Browser
service. You can do this by selecting SQL Server Services in the
navigation tree, right-clicking on these services, and then selecting
Restart.
30. Click Apply, and then click OK. Close the SQL Server Configuration Manager.
If you are using a replicated system, you must complete these steps on both servers.
You are responsible for maintaining the security of your database. No lockdown scripts
are run by CAD installers. However, before performing any hardening of your SQL
instance, complete the CAD installation in full, including replication setup steps if you
plan on using a replicated environment. You must also ensure the Recording and
Statistics service is functioning properly with SQL Server 2008 R2.
are run by CAD installers. However, before performing any hardening of your SQL
instance, complete the CAD installation in full, including replication setup steps if you
plan on using a replicated environment. You must also ensure the Recording and
Statistics service is functioning properly with SQL Server 2008 R2.
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
through
above, using the following SQL
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.