HP Storage Essentials Enterprise Edition Software User Manual
Page 140
Discovering Applications, Backup Hosts and Hosts
102
The management server accesses Microsoft SQL Server through the appiq_user account. This
account is created when you run the CreateSQLServerAct.bat or
CreateSQLServerActCustom.bat
script on the computer running the Microsoft SQL Server
database you want to monitor. This account has create session and select dictionary privileges,
which allow the management server to view statistics for the Microsoft SQL Server.
NOTE:
For more information about creating the appiq_user account with a custom password, see
Creating Custom Passwords on Managed Database Instances
Keep in mind the following:
•
The script must run under the SA user account. To verify that the SA account is enabled, launch
SQL Server’s Query Analyzer tool and attempt to connect to the database as SA with the SA
user’s password.
•
Obtain the SQL Server name before you run the script
•
You should have already installed the database for the management server.
•
Make sure you have all the necessary information before you begin the installation. Read
through the following steps before you begin.
To create the appiq_user account for Microsoft SQL Server:
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 SA user account.
You are prompted for the password for this user account when you run the script.
3.
In a new command window, run the CreateSQLServerAct.bat script on the computer with
the SQL Server database.
NOTE:
You can use a remote SQL Server isql to run this script.
4.
The script prompts you for the name of the Microsoft SQL Server on which to create the
appiq_user account. If you are creating the account on a default instance, enter the host name if
the instance is non-clustered and the SQLNetwork Name if the instance is clustered. If you are
creating the account on a named instance, enter the host name and the instance name as
follows:
For a non-clustered instance:
For a clustered instance:
5.
If you are running the CreateSQLServerActCustom.bat script, you will be prompted for a
password for the appiq_user account. Provide a password that meets the password policy