beautypg.com

Deleting sql server information, Monitoring sybase adaptive server enterprise, Step a - create the appiq_user account for sybase – HP Storage Essentials NAS Manager Software User Manual

Page 142

background image

Discovering Applications, Backup Servers and Hosts

112

5.

Type the password for the server administrator account.
The account for APPIQ_USER is removed. The management server can no longer monitor the

SQL Server databases on this host.

Deleting SQL Server Information

If you do not want the management server to monitor a SQL Server instance, you can remove its

information, as described in the following steps:

1.

Do one of the following:
Discovery from HP SE - Select Tools > Storage Essentials > Home > Discovery >

Setup

. Then, click the Applications tab

Discovery from HP SIM - Select Options > Protocol Settings > Storage Essentials >

System Application

Discovery Settings. To select a target, you must have at least one

element designated as a server, workstation or desktop. If you see the message, “No Targets

Currently Selected,” change your element from unknown to either a server, workstation or

desktop. Refer to the documentation for HP Systems Insight Manager. Select a target, and

then, click Run Now.

2.

In the Database Information table, click the button, corresponding to the SQL Server instance

you do not want the management server to monitor.

3.

Perform Get Details/Discovery Data Collection to make the management server aware of your

changes.

Monitoring Sybase Adaptive Server Enterprise

If you want to monitor Sybase Adaptive Server Enterprise you must:

Create APPIQ_USER account on the database for Sybase

Provide the database server name and port number

Discover the application.

The required drivers for Sybase Adapter Server Enterprise were automatically installed along with

the management server.

IMPORTANT:

Before you begin these steps, make sure you purchased Sybase IQ, which is the

module that lets you monitor Sybase Adaptive Server Enterprise. Contact your customer support if

you are unsure if you purchased this module.

Step A - Create the APPIQ_USER account for Sybase

The management server accesses Sybase through the APPIQ_USER account. This account is created

when you run the CreateSybaseAct.bat script on Microsoft Windows or CreateSybaseAct.sh on

UNIX on the computer running the Sybase database you want to monitor. The account has create

session and select dictionary privileges to be used with the management server.
Keep in mind the following:

The script must run under SA user.