5.0

Table Of Contents
Configuring the SRM Database
Each SRM server requires its own database to store recovery plans, inventory information, and similar data.
Before installing the SRM server, you must configure and initialize the SRM database.
If you are updating SRM to a new release, you can use the existing database. Before attempting an SRM
environment upgrade, ensure both SRM server databases are backed up. This helps ensure you can revert after
the upgrade, if required.
SRM cannot use the vCenter database because it has different database schema requirements, though you can
use the vCenter database server to create and support the SRM database. Each SRM site requires its own
instance of the SRM database. The database must exist before SRM can be installed.
NOTE If you reinitialize the database after you install SRM, you must run the SRM installer in maintenance
mode and specify a new database connection.
Microsoft SQL Server Configuration
A Microsoft SQL Server configuration must meet specific requirements to support SRM.
SRM requires that the Microsoft SQL Server must have a 32-bit DSN. Microsoft SQL Server has the following
configuration requirements when used as the SRM database.
n
The database schema has three requirements:
n
It must be owned by the SRM database user (the database user name you supply when configuring
the SRM database connection).
n
It must be the default schema for the SRM database user.
n
The DB schema name must be the same as the DB user name.
n
You must grant the SRM database user the following permissions:
n
bulk insert
n
connect
n
create table
n
If you are using Windows authentication, the database user account must be the same user account that
you use to run the SRM service.
n
If you are using SQL Authentication, you can leave the default local System user.
n
If the SRM server and database server run on different hosts, you must use mixed mode authentication.
n
If SQL Server is installed locally, you might need to disable the Shared Memory network setting on the
database server.
Oracle Server Configuration
An Oracle Server configuration must meet specific requirements to support SRM.
Oracle Server has the following configuration requirements when used as the SRM database.
n
When creating the database instance, specify utf-8 encoding.
n
You must grant the following permissions to the SRM database user (the database user name you supply
when configuring the SRM database connection):
n
connect
n
resource
Site Recovery Manager Administration Guide
28 VMware, Inc.