HP Storage Essentials V5.1 User Guide First Edition (T4283-96026, August 2006)

Storage Essentials 5.1 User Guide 121
Step A - Create the APPIQ_USER for the SQL Server
The management server accesses SQL Server through the APPIQ_USER account. This account is
created when you run the CreateSQLServerAct.bat script on Microsoft Windows on the
computer running the SQL Server database you want to monitor. The account has create session
and select dictionary privileges to be used with the management server.
Keep in mind the following:
• The script must run under SA user. 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
• Create APPIQ_USER account on SQL Server database you want to monitor.
• 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 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. Run the CreateSQLServerAct.bat script on Microsoft Windows on the computer with the
SQL Server database.
The script creates a user with login to master and select privilege on data dictionary tables on a
managed SQL Server instance.
NOTE: You can use a remote SQL Server isql to run this script.
4. Type the SQL Server instance name, which must be visible to the client, as the first input when
running the script. The script prompts you for the name of the SQL Server on which to create
user for SQL Server management packages and the password of the SA account.
This script does the following in order:
• Creates the APPIQ_USER account.
• Grant create session and select on dictionary tables privileges to APPIQ_USER enabling
management server to view statistics for the SQL Server.
5. To determine if the appiq_user user was added correctly to your SQL server:
a. Open SQL Server Enterprise Manager.
b. Expand the user interface for SQL Server Enterprise Manager. Then, expand the specific
SQL Server and select Security.