Cisco Cisco Agent Desktop 8.5 Guida All'Installazione
Cisco CAD Installation Guide
44
March 31, 2014
Configuring Microsoft SQL Server 2005 for
CAD 8.5
CAD 8.5
If you choose to use SQL Server and not flat files for data storage, it is required that
your system include a separate SQL Server instance that hosts the CAD base services
(on both servers in a replicated system). SQL Server and CAD base services must be
installed on the same machine.
your system include a separate SQL Server instance that hosts the CAD base services
(on both servers in a replicated system). SQL Server and CAD base services must be
installed on the same machine.
NOTE: As a best practice, use NT (Windows) authentication as per the
procedure below. If you want to use SQL authentication, some steps
must be modified. Consult your SQL Server documentation for more
information.
procedure below. If you want to use SQL authentication, some steps
must be modified. Consult your SQL Server documentation for more
information.
Installing and Configuring SQL Server 2005
Before proceeding with the SQL Server 2005 installation, you must create the user
account detailed in
account detailed in
. For CAD
to function properly, the Recording and Statistics service must connect to both the
Admin Workstation database as well as its own local database. If you are using NT
(Windows) Authentication to connect to both databases, the same user must be used
for authentication. If this user is different than the local user that is currently logged
in, you must first create this user with local administrator privileges in Windows
Computer Management before you install SQL Server.
Admin Workstation database as well as its own local database. If you are using NT
(Windows) Authentication to connect to both databases, the same user must be used
for authentication. If this user is different than the local user that is currently logged
in, you must first create this user with local administrator privileges in Windows
Computer Management before you install SQL Server.
You must use this account to install SQL Server 2005 and CAD base services.
If there are any firewalls running (for example, the default Windows Firewall), make
sure that the firewall includes an exception for SQL Server. If there is no exception and
a firewall is enabled, the Recording & Statistics service will not work.
sure that the firewall includes an exception for SQL Server. If there is no exception and
a firewall is enabled, the Recording & Statistics service will not work.
Also, verify you have an active internet connection.
The following settings must be configured during the SQL Server 2005 installation for
CAD to function properly.
CAD to function properly.
To configure a Microsoft SQL Server 2005 named instance for CAD 8.5:
1. Run the SQL Server installer (setup.exe) to create a new named instance (you
cannot use the default instance). The following settings are required for CAD:
■
On the Components to Install window, select the SQL Database Services
and Workstation components, Books Online and developments tools
check boxes.
and Workstation components, Books Online and developments tools
check boxes.
■
On the Service Account window, select Use the built-in System account
option, and select the SQL Server Agent check box.
option, and select the SQL Server Agent check box.