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.

112 Discovering Applications, Backup Servers and Hosts