Configuring the sql database, Permissions, Installing storage mirroring reporting center – HP Storage Mirroring Software User Manual
Page 8
2 - 2
Configuring the SQL database
If you are using the default SQL Express database, you may skip this section and proceed to
When you install Storage Mirroring Reporting Center, two data stores are automatically created,
which are by default named
config
and
datamine
. The following table describes the recommended
minimum sizes for these databases.
The data stores require user IDs that Storage Mirroring Reporting Center uses to access these data
stores. Each of these user accounts will be owners of their respective data store. These account are
created during the Storage Mirroring installation. The login accounts must have full access to create
and drop tables as well as to update the tables that are created.
Permissions
Storage Mirroring Reporting Center requires the following permissions:
z
The username and password entered during installation is used to setup the Storage Mirroring
Collector service, which performs data gathering. This must be a Windows account with Local
Administrator permissions, which will enable it to gather data through WMI from the local
machine.
z
If you are connecting the Storage Mirroring Reporting Center server to a pre-existing version of
MSSQL, the username and password you enter must have adequate permissions to access MSSQL
and create databases.
z
The username and password entered is used to connect to the Storage Mirroring Server and
collect local host data and Storage Mirroring specific data. To gather both Storage Mirroring and
other server configuration and performance data, an account must be specified in Storage
Mirroring when configuring a new host (called “Nodes”) to be monitored. The user account can be
either a local administrator account or a domain administrator account, but the account must
have Local Administrator and Storage Mirroring Administrator permissions on the Storage
Mirroring node to be monitored.
For help troubleshooting connectivity issues related to invalid permissions, see
Installing Storage Mirroring Reporting Center
Storage Mirroring Reporting Center is installed separately from Storage Mirroring. The installation
provides both server and client reporting components. The server component provides the data
collection and monitoring engine and stores the collected information within a SQL Server
environment. The client component provides the configuration, graphical reporting, and monitoring
capabilities.
Before you install Storage Mirroring Reporting Center, ensure that you have a username and
password created that meet the permission requirements described in
To install the Storage Mirroring Reporting Center Server, launch the installation wizard. Follow the
prompts to install Storage Mirroring Reporting Center.
In order for WMI to collect server information, DCOM must be turned on. The following registry string
value is used to enable or disable DCOM on all operating systems. Changes will be applied after you
restart the operating system.
Database Name
Minimum Size
config
150 MB
datamine
5 GB
NOTE:
You may use a local account that is part of the local Administrator's group, or a
Domain User account that is part of the local Administrator's Group, as long as the
account is entered in the NTLM “
domain\user
” format. The UPN format,
“
user@domain
” will
not work and the installation will fail.