3-19
Installing Management Center for Cisco Security Agents 5.2
78-17916-01
Chapter 3 Installing the Management Center for Cisco Security Agents
Local and Remote DB Installation Overview
Microsoft SQL Server 2005 and 2000 Local Installation Notes
Note The following instructions are only intended for administrators choosing to install
CSA MC and Microsoft SQL Server 2005(or 2000) to the same system. These
instructions are not for administrators using CSA MC with a remote database. If
you are choosing to use Microsoft SQL Server 2005 as a remote database,
information is provided in the section titled Installing CSA MC with a Remote
Database, page 3-21. All instructions apply to both Microsoft SQL Server 2005
and 2000 unless otherwise specified.
Caution CSA MC supports Microsoft SQL Server 2005 with Service Pack 0 , Service Pack
1, or Service Pack 2. You should note that if you install a SQL Server 2005 build
that is lower than build number 2153 (released after SP1), the service "SQL
Server Integration Services" will fail upon system reboot. You can manually start
the service or you can upgrade to Microsoft SQL Server 2005 SP1 build number
2153 or higher.
For local database installations exceeding 1,000 agents, it is recommended that
you install Microsoft SQL Server 2005 instead of using the Microsoft SQL Server
Express Edition that is provided with the product. Microsoft SQL Server Express
Edition has a 4 GB limit. SQL Server 2005 must be licensed separately and it must
be installed on the local system before you begin the CSA MC installation.
In order for Microsoft SQL Server 2005 to function properly with CSA MC, you
must select certain settings during the installation. Those settings are listed here.
(Refer to your Microsoft SQL Server 2005 manual for detailed installation
information.)
Note You should not change the default instance name of “MSSQLSERVER” for the
SQL Server 2005 database. If you change this, the CSA MC installation will not
detect the database.
When installing Microsoft SQL Server 2005, choose the default settings except in
the following instances: