Cisco Cisco Agent Desktop 8.5 문제 해결 가이드
Troubleshooting Recording and Statistics Service SQL Server Replication Problems
April 3, 2014
53
Troubleshooting Recording and Statistics
Service SQL Server Replication Problems
Service SQL Server Replication Problems
To verify if replication is actually working correctly ensure that you can see the
following item under the Replication view in SQL Server Management Studio:
following item under the Replication view in SQL Server Management Studio:
— A publication item on the primary node
— A subscription item to this publication directly underneath the publication
item on the primary node
— A subscription item to this publication on the secondary node
If you see all three of these items, replication should be working correctly. If you see
some, but not all, of these items, right-click a replication item that does exist and
launch the Replication Monitor. If any errors are encountered, they can be viewed
here.
some, but not all, of these items, right-click a replication item that does exist and
launch the Replication Monitor. If any errors are encountered, they can be viewed
here.
It is possible that the CAD Configuration Setup utility returns the message, Replication
Setup was successful, but that replication still does not work properly. If replication is
not working properly, turn off replication in the CAD Configuration Setup utility, and
continue troubleshooting using the process below.
Setup was successful, but that replication still does not work properly. If replication is
not working properly, turn off replication in the CAD Configuration Setup utility, and
continue troubleshooting using the process below.
The general process to use these troubleshooting items is a follows:
1. In the CAD Configuration Setup utility, on the Replication node, turn on
Recording and Statistics Replication.
2. If step 1 results in a failure, complete the next troubleshooting item below.
3. Repeat step 1.
Troubleshooting Steps
1. Ensure that both SQL Servers are on.
2. Ensure that the latest Microsoft SQL Server service pack and updates are
installed.
3. Ensure that you are running the CAD Configuration Setup utility as a user that
has been provisioned as an administrator for the CAD SQL instance. Any
administrator will not suffice. For example, if you are logged in as a domain
administrator that is not a provisioned CAD SQL instance administrator and
you run the CAD Configuration Setup utility as this user, then all Recording
and Statistics Service related scripts will fail.
administrator will not suffice. For example, if you are logged in as a domain
administrator that is not a provisioned CAD SQL instance administrator and
you run the CAD Configuration Setup utility as this user, then all Recording
and Statistics Service related scripts will fail.
To run the CAD Configuration Setup utility as a different user, log out the
current user and log in with a user that has been provisioned as an
administrator for the CAD SQL instance.
current user and log in with a user that has been provisioned as an
administrator for the CAD SQL instance.