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
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.
- Storage Essentials Provisioning Manager Software Storage Essentials Backup Manager Software Storage Essentials Chargeback Manager Software Storage Essentials Report Designer Software Storage Essentials Global Reporter Software Storage Essentials Enterprise Edition Software Storage Essentials Exchange Viewer Software Storage Essentials File System Viewer Software