beautypg.com

Removing the appiq_user account for sql server, Deleting sql server information – HP Storage Essentials NAS Manager Software User Manual

Page 156

background image

Discovering Applications, Backup Servers and Hosts

124

IMPORTANT:

Perform Get Details/Discovery Data Collection for your inputs to take effect. See

Step 3 - Discovering Applications

” on page 129.

Removing the APPIQ_USER Account for SQL Server

IMPORTANT:

Before you remove the APPIQ_USER account for the SQL Server databases on a

host, make sure no processes are running APPIQ_USER for that SQL Server database. The

management server uses APPIQ_USER to obtain information about a SQL Server database.

(Discovery from HP SE only)One of the ways to make sure APPIQ_USER is not being used is to

temporarily remove the host running SQL Server (Discovery > Topology). After you removed the

APPIQ_USER account for SQL Server, discover and perform Get Details for the host if you want to

continue monitoring it.

To remove the APPIQ_USER account for the SQL Server databases on a host:

1.

To run the script on Microsoft Windows, go to the DBIQ\sqlserver\win directory on the

CIM Extensions CD-ROM.

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 UninstallSQLServerAct.bat script on Microsoft Windows on the computer with

the SQL Server database.

4.

Type the name of the SQL Server server.

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.