Cisco Cisco Agent Desktop 9.0 Fehlerbehebungsanleitung
Troubleshooting Recording and Statistics Service SQL Server Replication Problems
March 13, 2015
61
even when specifying the loopback address, then the instance is either
not running, the installation is corrupt, or some other serious
misconfiguration has occurred.
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 Windows (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 Windows (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 the 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 the 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 2008 R2 system is always
SQL Server 2008 R2 system is always
C:\Program Files (x86)\Microsoft SQL Server\
MSSQL10_50.<SQL instance>\MSSQL\DATA\, where
<SQL instance> is the name given to the SQL instance during
installation.
<SQL instance> is the name given to the SQL instance during
installation.
NOTE: The Database Directory field, unlike other fields in the
CAD Configuration Setup utility, is not replicated between
sides when you make changes. If you change the value on
one side, you must also change the value on the other side,
as applicable.
CAD Configuration Setup utility, is not replicated between
sides when you make changes. If you change the value on
one side, you must also change the value on the other side,
as applicable.