Guest

Cisco Security Agent

CSA 5.1 with Remote SQL Server Configuration Sample

Cisco - CSA 5.1 with Remote SQL Server Configuration Sample

Document ID: 92229

Updated: Jul 16, 2007

   Print

Introduction

This document demonstrates how to install CSAMC 5.1 to use Microsoft SQL 2000 as a remote database.

Prerequisites

Requirements

Ensure that you meet these requirements before you attempt this configuration:

  • Ensure that you have full administrative access rights to Microsoft SQL Server 2000 Management Console. This allows to you view and configure SQL Server 2000.

  • Ensure that you have successfully installed SQL 2000 database in another server.

  • Ensure that you have met Cisco Secure Agent MC installation prerequisites. Refer toSystem Requirements for more information.

Components Used

The information in this document is based on these software and hardware versions:

  • Cisco CSA MC 5.1

  • MS SQL Server 2000

The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.

Conventions

Refer to the Cisco Technical Tips Conventions for more information on document conventions.

Configure

In this section, you are presented with the information to configure the features described in this document.

Note: Use the Command Lookup Tool (registered customers only) to obtain more information on the commands used in this section.

Obtain Full Administrative Rights in MS SQL Server 2000

Refer to Assigning Users to Database Roles leavingcisco.com for more details.

MS SQL Server 2000 Configuration Steps

Complete these steps to configure CSA MC5.1 to use the MS SQL Server 2000 as a remote database.

  1. Ensure that you have successfully installed the SQL 2000 database in another server. Choose Mixed Mode Authentication and check the Blank Password box.

    CCO_CSA_with_SQL_Server1.gif

  2. Start the SQL Enterprise Manager application.

    CCO_CSA_with_SQL_Server2.gif

  3. Right-click the server and choose Edit SQL Server Registration Properties.

  4. Choose SQL Server Authentication and enter the SA account.

    CCO_CSA_with_SQL_Server3.gif

  5. Right-click the server name and choose Properties.

  6. Click the large Network Configuration button at the bottom and verify that TCP/IP is chosen and on the right side of the screen.

    CCO_CSA_with_SQL_Server4.gif

  7. Right-click the databases and choose New.

    CCO_CSA_with_SQL_Server5.gif

  8. Name the new database CSAMC5.1 and press OK.

    CCO_CSA_with_SQL_Server6.gif

  9. Right-click the new database (CSAMC5.1) and choose Properties.

  10. Click the Filegroups tab, type ANALYSIS in the empty Name field, and then press OK to finish.

    CCO_CSA_with_SQL_Server7.gif

  11. Right-click the new database (CSAMC5.1) and choose Properties.

  12. Click the Data Files tab.

    CCO_CSA_with_SQL_Server8.gif

  13. Expand the Security folder in SQL Manager.

  14. Create a username such as CSAUSER and choose SQL Server Authentication. Provide a password for the user and then choose the CSAMC5.1 database from the drop-down menu. Press OK to proceed

    CCO_CSA_with_SQL_Server9.gif

  15. Press OK and then input the SQL Server Authentication password in the Confirm Password window again.

    CCO_CSA_with_SQL_Server10.gif

  16. Press NO to grant privileges to the user CSAUSER.

    CCO_CSA_with_SQL_Server11.gif

  17. Add db_owner, db_ddladmin, db_datareader and db_datawriter permissions, and press OK.

    CCO_CSA_with_SQL_Server12.gif

Cisco Security Agent MC Installation Steps

Complete these steps to install the Cisco Security Agent (CSA) Management Center (MC).

  1. Download the installation file from the Management Center for Cisco Security Agents, and then click .exe to install the CSA Management Center.

  2. Start the CSA MC 5.1 installation. Click Next.

    CCO_CSA_with_SQL_Server13.gif

  3. Choose the option Remote Database: Place configuration information in a remote database, and then click Next.

    CCO_CSA_with_SQL_Server14.gif

  4. Type the information into these fields: the CSA MC Server Name, SQL server Database Name that corresponds, login User Name, and Password. Use the password that configured previously. Click Next.

    CCO_CSA_with_SQL_Server15.gif

  5. Verify the installation in the Destination Folder field. Click Next.

    CCO_CSA_with_SQL_Server16.gif

  6. Click Install to start the installation.

    CCO_CSA_with_SQL_Server17.gif

  7. Note the Setup Status information.

    CCO_CSA_with_SQL_Server18.gif

Verify

Use this section to confirm that your configuration works properly.

  1. Open the CSAMC 5.1 login page and log in. It now runs concurrently with MS SQL Server 2000.

    CCO_CSA_with_SQL_Server19.gif

  2. The CSAMC opens the configuration home page when it invokes the remote MS SQL Server 2000 database.

    CCO_CSA_with_SQL_Server20.gif

  3. Verify the database details in the MS SQL Server 2000.

    CCO_CSA_with_SQL_Server21.gif

  4. Note the CSA agent_kit database in the MS SQL Server 2000.

    CCO_CSA_with_SQL_Server22.gif

Troubleshoot

This section provides information you can use to troubleshoot your configuration.

Troubleshooting Procedure

Follow these instructions to troubleshoot your configuration.

  1. Ensure that the CSA MC Server and SQL Server have the same system time. The system time on the CSA MC Server and SQL Server are not synchronized.

    CCO_CSA_with_SQL_Server23.gif

  2. Correct the time issue and re-launch the CSA MC 5.1 login page.

    CCO_CSA_with_SQL_Server24.gif

Troubleshooting Commands

The Output Interpreter Tool (registered customers only) (OIT) supports certain show commands. Use the OIT to view an analysis of show command output.

Note: Refer to Important Information on Debug Commands before you use debug commands.

Related Information

Updated: Jul 16, 2007
Document ID: 92229