Cisco Cisco Agent Desktop 9.0 Guía Para Resolver Problemas
Cisco CAD Troubleshooting Guide
58
March 13, 2015
8. Ensure that the FCRasSvr database exists on both servers. This can be
verified by viewing the databases present in SQL Server Management Studio.
If this database does not exist, try the following troubleshooting steps:
a. Verify that all the steps in the “Configuring SQL Server 2008 R2 for
CAD 9.0” and the “Recording and Statistics Database” sections of the
Cisco CAD Installation Guide were correctly performed.
Cisco CAD Installation Guide were correctly performed.
b. If the steps were performed correctly, but the FCRasSvr database still
cannot be created, verify that the SQL Server, SQL Server Agent, and the
SQL Server Browser services for the CAD SQL instance are all running in
the Windows Services list. If they are not set to automatic startup, then
you must turn automatic startup on.
SQL Server Browser services for the CAD SQL instance are all running in
the Windows Services list. If they are not set to automatic startup, then
you must turn automatic startup on.
c. If the required SQL services are running properly, but the FCRasSvr
database is still not created, try the following:
— If you are using Windows (NT) Authentication (recommended), ensure
that the user entered in the Recording and Statistics Database
Configuration node of the CAD Configuration Setup utility exists on
the local machine or the specified domain, with correct credentials
and administrator permissions. This user must also exist as a
provisioned administrator for the CAD SQL instance.
Configuration node of the CAD Configuration Setup utility exists on
the local machine or the specified domain, with correct credentials
and administrator permissions. This user must also exist as a
provisioned administrator for the CAD SQL instance.
— If you are using SQL Authentication, ensure that the user entered in
the Recording and Statistics Database Configuration node exists as a
login on the CAD SQL instance and has sysadmin privileges on the
CAD SQL instance.
login on the CAD SQL instance and has sysadmin privileges on the
CAD SQL instance.
Also, the CAD SQL instance Server Authentication mode must be
configured to use both SQL Server and Windows (NT) Authentication
(Mixed Mode). The default is Windows (NT) Authentication only. These
settings can be configured with SQL Server Management Studio.
Refer to your Microsoft SQL Server documentation for more
information.
configured to use both SQL Server and Windows (NT) Authentication
(Mixed Mode). The default is Windows (NT) Authentication only. These
settings can be configured with SQL Server Management Studio.
Refer to your Microsoft SQL Server documentation for more
information.
NOTE: SQL Server Authentication is not recommended as a
login mechanism by Microsoft. The security best practice is to
use Windows (NT) Authentication only.
login mechanism by Microsoft. The security best practice is to
use Windows (NT) Authentication only.
d. Ensure that the port or named pipe used to connect to the CAD SQL
instance on the Recording and Statistics Database Configuration node is
valid and available for use by the CAD SQL instance on each server.
valid and available for use by the CAD SQL instance on each server.
You can see what ports are in use on the system and what the CAD SQL
instance is using to listen for connections with the
instance is using to listen for connections with the
netstat
command.
Verify that what the CAD SQL instance on both servers are using to listen
for connections are the same and match what is entered on the
Recording and Statistics Database Configuration node.
for connections are the same and match what is entered on the
Recording and Statistics Database Configuration node.