HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

Discovering Applications, Backup Hosts and Hosts102

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” on page 88.

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