Cisco Cisco Agent Desktop 8.5 Guia Da Instalação
Configuring Microsoft SQL Server 2005 for CAD 8.0
February 21, 2013
37
4. If there are any firewalls running (for example the default Windows Firewall),
make sure that the firewall includes an exception for SQL Server. If there is no
exception and a firewall is enabled, the Recording & Statistics service will not
work.
exception and a firewall is enabled, the Recording & Statistics service will not
work.
5. Choose Start > Programs > Microsoft SQL Server 2005 > Configuration
Tools > SQL Server Surface Area Configuration.
6. Click Surface Area Configuration for Features. There is configuration
information for each SQL instance installed. Select the configuration for the
named instance CAD is using.
named instance CAD is using.
■
For the Ad Hoc Remote Queries component, select the Enable
OPENROWSET and OPENDATASOURCE support check box.
OPENROWSET and OPENDATASOURCE support check box.
■
For the xp_cmdshell component, select the Enable xp_cmdshell check
box.
box.
7. Click OK to save your settings and then close SQL Server Surface Area
Configuration.
8. Choose Start > All Programs > Microsoft SQL Server 2005 > Configuration
Tools > SQL Server Configuration Manager.
9. In the navigation tree, select SQL Server 2005 Network Configuration >
Protocols > <named instance>, where <named instance> is the new named
instance created in Step 1.
instance created in Step 1.
10. Ensure that the connection method you intend to specify in CAD Configuration
Setup is enabled here.
■
If you intend to use named pipes, double-click the Named Pipes protocol
and ensure that the pipe name matches what will be entered in CAD
Configuration Setup.
and ensure that the pipe name matches what will be entered in CAD
Configuration Setup.
■
If you intend to use TCP/IP, double-click the TCP/IP protocol and add the
appropriate TCP port on the IP Addresses tab (the IP addresses are
autofilled from system information).
appropriate TCP port on the IP Addresses tab (the IP addresses are
autofilled from system information).
NOTE: CAD cannot use the same named pipe or port that another
SQL instance is using. If another SQL instance is using the named
pipe or port that is entered in CAD Configuration Setup, the value in
CAD Configuration Setup must be changed to use a different named
pipe or port.
SQL instance is using. If another SQL instance is using the named
pipe or port that is entered in CAD Configuration Setup, the value in
CAD Configuration Setup must be changed to use a different named
pipe or 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 named instance and the Generic SQL Server Browser service.
You can do this by selecting SQL Server 2005 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 named instance and the Generic SQL Server Browser service.
You can do this by selecting SQL Server 2005 Services in the
navigation tree, right-clicking on these services, and then selecting
Restart.