Removing the appiq_user account for sql server, Deleting sql server information – HP Storage Essentials NAS Manager Software User Manual
Page 156
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
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.