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

HP Storage Essentials SRM 6.0 User Guide 103
criteria described in ”Creating Custom Passwords on Managed Database Instances” on
page 88. If you are running the CreateSQLServerAct.bat script, the default password
(password) is automatically used.
6. The script prompts you for the SA user password. Enter the password.
The appiq_user account is created.
7. To determine if the appiq_user account was added correctly to your Microsoft 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.
c. Double-click Logins and view the list of users authorized to access the SQL Server.
d. Click the refresh button in SQL Server Enterprise Manager. If the appiq_user is not listed, the
management server is not able to discover the database.
8. To determine if the SQL Server is ready to accept connections from the management server:
a. Connect to the SQL Server installation through Query Analyzer using the account
appiq_user and the password password.
b. Create a sample ODBC datasource for the SQL Server installation using the appiq_user
account.
c. Click the Test button to test the datasource.
9. Repeat these steps for each Microsoft SQL Server 2000 instance you want to manage.
Microsoft SQL Server 2005:
The management server accesses Microsoft SQL Server through the appiq_user account. To create
this account, run the CreateSQLServerActCustomPwd.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.
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.