Cisco Cisco Agent Desktop 10.0 Installation Guide
Cisco CAD Installation Guide
40
October 16, 2015
Installing and Configuring SQL Server 2008 R2
NOTE: If CAD and SQL Server 2008 R2 are co-resident on the
Peripheral Gateway, and Unified ICM is upgraded to release 11.0, SQL
Server 2008 R2 might cause the upgrade to fail. To prevent this
issue, you must upgrade to SQL Server 2014 or move SQL Server
2008 R2 to an offboard server.
Peripheral Gateway, and Unified ICM is upgraded to release 11.0, SQL
Server 2008 R2 might cause the upgrade to fail. To prevent this
issue, you must upgrade to SQL Server 2014 or move SQL Server
2008 R2 to an offboard server.
Before proceeding with the SQL Server 2008 R2 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.
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.
You must use this account to install SQL Server 2008 R2 and CAD base services.
Later, you must specify this user in step
Later, you must specify this user in step
of the procedure below.
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.
Verify that you have an active internet connection.
The following settings must be configured during the SQL Server 2008 R2 installation
for CAD to function properly. Navigate between nodes using the Next and Back
buttons.
for CAD to function properly. Navigate between nodes using the Next and Back
buttons.
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.
To install and configure a Microsoft SQL Server 2008 R2 named instance for CAD 10.0:
1. Start the SQL Server 2008 R2 installer (setup.exe).
2. On the SQL Server Installation Center window, select Installation in the left
navigation pane.
3. Select New installation or add features to an existing installation. The SQL
Server 2008 R2 Setup window appears.
4. Accept the prompts and allow the support files to install.