Installation Manual

HP Storage Essentials SRM 6.0 Installation Guide 313
5. For “Server Authentication,” select SQL Server and Windows Authentication Mode, and then
click OK. You may be prompted to restart the SQL server.
6. Open SQL Server Configuration Manager (Start Menu > Programs > Microsoft SQL Server
2005 > SQLServer Configuration Manager). Make sure that the SQL instance is logged on with
a Domain Administrator account if it is a clustered instance and System Account if it is a
non-clustered instance.
Step A — Create the appiq_user Account for the Microsoft SQL Server
Microsoft SQL Server 2000:
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 303.
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