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:

 

 

Installing Management Center for Cisco Security Agents 5.2

 

 

 

 

 

 

78-17916-01

 

 

3-19

 

 

 

Page 67
Image 67
Cisco Systems DOC-78-17916 manual Microsoft SQL Server 2005 and 2000 Local Installation Notes