Cisco Cisco Agent Desktop 9.0 Fehlerbehebungsanleitung
Cisco CAD Troubleshooting Guide
60
March 13, 2015
<port number>
is the port number that the CAD SQL instance is using
according to the SQL Configuration Manager
NOTE: If you are attempting to use SQL Authentication (not
recommended) instead of Windows (NT) Authentication, you
must remove the
recommended) instead of Windows (NT) Authentication, you
must remove the
-E
parameter from the queries and replace
it with the username and password parameters
(
(
-U <username> -P <password>
) using your SQL
credentials.
More information on SQL connection syntax can be found here:
c. Repeat the two queries on server B. Ensure that all queries run
successfully and that you can see the version information display in the
terminal.
terminal.
■
These queries assume that the Recording and Statistics Database exists
on both Side A and Side B. If this database does not exist, the option
on both Side A and Side B. If this database does not exist, the option
-d FCRasSvr
will not work. To troubleshoot this, replace -
d FCRasSvr
with
-d master
to access the CAD SQL instance. After you have
successfully created FCRasSvr database on both sides, you can go back
to troubleshooting with the above commands using
to troubleshooting with the above commands using
-d FCRasSvr
.
■
If the queries do not execute successfully using the IP address but do run
successfully with the hostname (or vice versa), make sure that the
Recording and Statistics Database Configuration node on the CAD
Configuration Setup utility uses that method to identify the servers.
successfully with the hostname (or vice versa), make sure that the
Recording and Statistics Database Configuration node on the CAD
Configuration Setup utility uses that method to identify the servers.
■
If the queries do not run successfully, try dropping the port number or
named pipe from the commands. If the queries execute successfully
when there is no port number or named pipe specified, this suggests that
the port number or named pipe used in the configuration is not correct.
Use
named pipe from the commands. If the queries execute successfully
when there is no port number or named pipe specified, this suggests that
the port number or named pipe used in the configuration is not correct.
Use
netstat
as per the troubleshooting steps above to determine which
port or named pipe with which to correctly set up the CAD SQL instance.
■
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
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