Cisco Cisco Agent Desktop 8.5 Guide De Dépannage
Troubleshooting Recording and Statistics Service SQL Server Replication Problems
April 3, 2014
57
sqlcmd -E -S np:\\<ServerB HostName or IP address>\pipe\
MSSQL$<CAD SQL Instance Name>\sql\query -d FCRasSvr -Q
"SELECT @@VERSION"
MSSQL$<CAD SQL Instance Name>\sql\query -d FCRasSvr -Q
"SELECT @@VERSION"
where:
<ServerA HostName or IP address>
is the hostname or IP address of
server A
<ServerB HostName or IP address>
is the hostname or IP address of
server B
<CAD SQL Instance Name>
is the name of the CAD SQL instance
<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.