Cisco Cisco Agent Desktop 9.0 Installationsanleitung
Cisco CAD Installation Guide
50
August 4, 2014
20. On the Ready to Install node, review your settings. Click the Install button.
21. On the Complete node, the following message is displayed:
“Your SQL Server 2008 R2 installation completed successfully.”
Click Close to dismiss the window.
22. Apply the latest available updates and service packs for SQL Server.
23. Open the SQL Server Management Studio. On the Connect to Server popup
window, log into the CAD SQL instance you just created.
24. Click the New Query button. In the query pane, enter the following SQL
statements:
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced
options.
options.
RECONFIGURE
GO
-- To enable xp_cmdshell.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To enable OPENROWSET and OPENDATASOURCE.
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO
25. Click Execute.
26. Close the SQL Server Management Studio.
27. Open the SQL Server Configuration Manager.
28. In the navigation tree, select SQL Server Network Configuration > Protocols
for <named instance>, where <named instance> is the new named instance
you just created.
you just created.
29. Ensure that the connection method you intend to specify in the CAD
Configuration Setup utility is enabled here.
■
If you intend to use TCP/IP (recommended), double-click the TCP/IP
protocol. On the IP Addresses tab, for every IP address, add the TCP port
number (default is 1433). The TCP port should also be added to the IPAll
protocol. On the IP Addresses tab, for every IP address, add the TCP port
number (default is 1433). The TCP port should also be added to the IPAll