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:

<Host Name>\<Instance Name>

For a clustered instance:

<SQL Network Name>\<Instance Name>

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

102 Discovering Applications, Backup Hosts and Hosts