Cisco Cisco Agent Desktop 8.5 Guia De Resolução De Problemas
Cisco CAD Troubleshooting Guide
58
April 3, 2014
■
To assist with troubleshooting, if you cannot connect to the local CAD SQL
instance using either the hostname or IP address of the system, you can
try replacing either the hostname or IP address with the local loopback
address (127.0.0.1) or with one of the Local Server specifiers: (local),
localhost, or a period (.). For example:
instance using either the hostname or IP address of the system, you can
try replacing either the hostname or IP address with the local loopback
address (127.0.0.1) or with one of the Local Server specifiers: (local),
localhost, or a period (.). For example:
sqlcmd -E -S tcp:(local)\CADSQL,1433 -d FCRasSvr -Q "SELECT
@@VERSION"
@@VERSION"
If you can connect when you specify the loopback address or Local Server
specifier, but not when using the local IP address or hostname, a
permissions/configuration issue specified in the troubleshooting steps
above is most likely the cause. If you cannot connect to the local instance
even when specifying the loopback address, then the instance is either
not running, the installation is corrupt, or some other serious
misconfiguration has occurred.
specifier, but not when using the local IP address or hostname, a
permissions/configuration issue specified in the troubleshooting steps
above is most likely the cause. If you cannot connect to the local instance
even when specifying the loopback address, then the instance is either
not running, the installation is corrupt, or some other serious
misconfiguration has occurred.
■
If the queries do not execute successfully when using the credentials of
the user entered in the CAD Configuration Setup utility (either when using
Run-As with NT Authentication or by supplying the credentials directly with
SQL Authentication), try to use the credentials of a full system
administrator. If the queries can successfully execute with a full
administrator, this suggests a permissions or firewall issue with the user
entered in the CAD Configuration Setup utility.
the user entered in the CAD Configuration Setup utility (either when using
Run-As with NT Authentication or by supplying the credentials directly with
SQL Authentication), try to use the credentials of a full system
administrator. If the queries can successfully execute with a full
administrator, this suggests a permissions or firewall issue with the user
entered in the CAD Configuration Setup utility.
■
When all of the above steps have been attempted and query execution
still fails for the CAD Configuration Setup utility user, look at the SQL
Server or Event Viewer logs for more details as to why the failure is
occurring (see troubleshooting item 10). If the errors encountered cannot
be overcome, it might require engaging Microsoft Support.
still fails for the CAD Configuration Setup utility user, look at the SQL
Server or Event Viewer logs for more details as to why the failure is
occurring (see troubleshooting item 10). If the errors encountered cannot
be overcome, it might require engaging Microsoft Support.
10. Ensure that the install directory of the SQL instance that CAD uses is mapped
correctly in the CAD Configuration Setup utility using the Database Directory
field on the Recording and Statistics Database Connection node.
field on the Recording and Statistics Database Connection node.
This field is automatically populated with the default location, but this might
not be the correct one for your configuration. To verify the location of the
instance in SQL Server Management Studio, right-click the instance name
and select Properties. In the Properties window, the Root Directory points to
the path of the instance location.
not be the correct one for your configuration. To verify the location of the
instance in SQL Server Management Studio, right-click the instance name
and select Properties. In the Properties window, the Root Directory points to
the path of the instance location.
NOTE: The Root Directory field does not give the precise
location of the CAD installation directory required by the CAD
Configuration Setup utility. You must specify the actual
location of the LDF and MDF files. By default, they are located
one subdirectory down from the end of the Root Directory,
under the Data subfolder.
location of the CAD installation directory required by the CAD
Configuration Setup utility. You must specify the actual
location of the LDF and MDF files. By default, they are located
one subdirectory down from the end of the Root Directory,
under the Data subfolder.
NOTE: The default install directory of the first instance on a
SQL Server 2005 system is always
SQL Server 2005 system is always