Cisco Cisco Agent Desktop 8.5 Guia Da Instalação
Cisco CAD Installation Guide
36
February 21, 2013
Configuring Microsoft SQL Server 2005 for
CAD 8.0
CAD 8.0
If you choose to use SQL Server and not flat files for data storage, it is recommended
that your system include a separate SQL Server instance on the server that hosts the
CAD Base services.
that your system include a separate SQL Server instance on the server that hosts the
CAD Base services.
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.
Upgrading from CAD 7.5 or Earlier
In CAD 7.6 or earlier, the CAD database instance was required to be named CADSQL
and was in MSDE (Microsoft SQL Server Desktop Engine) format. In CAD 8.0 and
higher, MSDE is no longer used and the database instance can be named anything
you wish.
In CAD 7.6 or earlier, the CAD database instance was required to be named CADSQL
and was in MSDE (Microsoft SQL Server Desktop Engine) format. In CAD 8.0 and
higher, MSDE is no longer used and the database instance can be named anything
you wish.
NOTE: You must use a named instance. You cannot use the default
instance.
instance.
It is recommended that you back up the data in the CADSQL MSDE instance and
restore it to the new SQL Server instance (see the Cisco CAD Installation Guide for
your old version of CAD for information on backup and restore). If you choose to
continue using CADSQL as the instance name, after you have backed up the MSDE
instance, remove it. This must be done in order to avoid conflicts with the instance
names.
restore it to the new SQL Server instance (see the Cisco CAD Installation Guide for
your old version of CAD for information on backup and restore). If you choose to
continue using CADSQL as the instance name, after you have backed up the MSDE
instance, remove it. This must be done in order to avoid conflicts with the instance
names.
To configure a Microsoft SQL Server 2005 named instance for CAD 8.0:
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 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.
■
On the Authentication Mode window, select Windows Authentication
Mode option.
Mode option.
■
On the Collation Settings window, keep the default collation (Dictionary
order, case-insensitive, for use with 1252 Character Set).
order, case-insensitive, for use with 1252 Character Set).
2. Complete the installation wizard.
3. Apply the latest available updates and service packs for SQL Server.