HP Storage Essentials NAS Manager Software - Manual (Page 162)

Discovering Applications, Backup Servers and Hosts 130
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.
c. Double-click Logins and view the list of users authorized to access the SQL Server.
d. If appiq_user is not listed, the management server is not able to discover the database.
6. 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.
7. Repeat steps 4 through 6 for each SQL Server you want to manage.
Step B - Provide the Microsoft SQL Server Name and Port Number
The server name for the Microsoft SQL server and port number for managing a SQL database must
be provided in the following steps: