Manualshelf

Storage Resource Manager Enterprise Edition Installation Guide

ManualsBrandsHP ManualsComputer AccessoriesCompaq SANworks Storage Resource Manager V4.0B - 1 License
21222324252627282930
2–6 Storage Resource Manager Enterprise Edition
Installation Preparation
• Make sure that you have adequate CALs for SRM database access if you are using
an SQL Server licensing model that requires CALs. SRM requires a minimum of
two CALs, one for the SRM Server and one for access to the database through the
SRM Web.
SRM SQL Server Database Configuration
This optional procedure contains SRM SQL Server database configuration
requirements and guidelines for SRM SQL Server 7.0 databases. It does not explain
how to create the database.
This section uses standard SQL Server terminology. If you are unfamiliar with these
terms or with creating and configuring SQL Server databases, consult your Microsoft
SQL Server documentation or your database administrator.
An SRM SQL Server database is created in the same location as the master database.
SRM creates and schedules a maintenance task for the database, and configures
database security. Both of these are described in Appendix A “Database Concepts.”
To configure an SRM SQL Server database:
1. Install SQL Server 7.0 on the SQL Server computer.
2. Create the database for the SRM database.
3. The new database must be empty. It cannot contain tables, procedures, indexes, or
data.
4. Use the following guidelines to ensure adequate disk space for a typical SRM
installation:
• Allow 200 MB for the SRM data device (5 MB minimum).
• Allow 20 MB for SRM’s database transaction log (required on the master
device’s disk if SRM creates the database).
• Set the SQL Server TEMPDB log to automatically expand as needed.
• Allow enough space for online backups dependent on your backup strategy.
5. Go to the target SRM Server computer and create a new System DSN for the SQL
Server ODBC driver and name it SRMDB. Configure this new System DSN to
point to the database you just created.
a. Let the SQL Server driver select the translation method for the character set
translation option.
b. Make sure that SRMDB appears in the Name field of the first dialog box.