HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

HP Storage Essentials SRM 6.0 User Guide 109
a. Open SQL Server Enterprise Manager.
b. Expand the user interface for SQL Server Enterprise Manager, and then select the specific
SQL server. Right-click and then select Properties from the menu.
c. Click the Network Configurations button. On the General Tab, select the TCP/IP entry under
the Enabled Protocols section, then click the Properties button.
d. The resulting window shows you the TCP/IP port your SQL server uses. Provide this port
number in the Port Number box on the management server.
Microsoft SQL Server 2005 Cluster
a. Open SQL Server Configuration Manager.
b. Select the specific SQL Server 2005 Network Configuration entry for the SQL Server 2005
instance.
c. Select the TCP/IP entry on the right pane, and then click the Properties right click menu.
d. From the IP Addresses tab, obtain the Port Number configured for the instance. Provide this
port number in the Port Number box on the management server. If Dynamic Ports are used,
the Port Number is located under IPAll > TCP Dynamic Ports.
7. Select SQLSERVER from the Database Type menu.
8. Click OK.
IMPORTANT: Perform Discovery Data Collection for your inputs to take effect. See ”Step 3
Discovering Applications” on page 123.
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 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.