IMPORTANT: You must complete the following steps.

2.Verify you have the password to the server administrator user account.

You are prompted for the password for this user account when you run the script.

3.Run the DropSQLServerAct.bat script on Microsoft Windows on the computer with the SQL Server database.

4.Enter the name of the SQL Server server.

5.Enter 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 Microsoft SQL Server Information

If you do not want the management server to monitor a Microsoft SQL Server instance, you can remove its information, as described in the following steps:

1.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. See 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 Discovery Data Collection to make the management server aware of your changes.

Monitoring Microsoft SQL Server Clusters

IMPORTANT: Make sure the Microsoft SQL Server cluster database is in “Mixed Mode authentication.” To switch to mixed mode authentication, see ”Switching to Mixed Mode Authentication” on page 312.

To monitor and manage Microsoft SQL Server clusters:

1.Install CIM Extensions on each of the participating nodes.

2.Create the appiq_user account as described in ”Step A — Create the appiq_user Account for the Microsoft SQL Server” on page 313.

NOTE: This step needs to be run on any one of the participating host nodes of the Microsoft SQL Server cluster.

3.Enter the server name and port number as described in ”Provide the Microsoft SQL Server Name and Port Number for a Cluster” on page 319.

318 Discovering Applications, Backup Hosts and Hosts