5.5

Table Of Contents
If you install SQL Server on a different machine to SRM Server, both of the SRM Server and SQL Server
machines must belong to the same domain. You then create a domain user that has the SQL Server login and
that also has access to SRM Server.
For information about database sizing, see the Sizing calculator for vCenter Site Recovery Manager databases -
MSSQL at http://www.vmware.com/products/site-recovery-manager/resource.html.
Procedure
1 Select an authentication mode when you create the database instance.
Option Description
Windows authentication
The database user account must be the same user account that you use to
run the SRM service.
SQL Authentication
Leave the default local system user.
2 Create the SRM database user account.
3 Grant the SRM database user account the bulk insert, connect, and create table permissions.
4 Create the database schema.
The SRM database schema must have the same name as the database user account.
5 Set the SRM database user as the owner of the SRM database schema.
6 Set the SRM database schema as the default schema for the SRM database user.
7 (Optional) If you are using SQL Server 2012, configure the NT AUTHORITY\SYSTEM login.
Option Action
General:: Default database
Type the database name.
Server Roles
Select the Public and Admin roles.
User Mapping
Select the check box to map the login to the database.
Configure Oracle Server for SRM
When you create a Oracle Server database, you must configure it correctly to support SRM.
You create and configure an Oracle Server database for SRM by using the tools that Oracle Server provides.
This information provides the general steps that you must perform to configure an Oracle Server database
for SRM. For instructions about how to perform the relevant steps, see the Oracle documentation.
For information about database sizing, see the Sizing calculator for vCenter Site Recovery Manager databases -
Oracle at http://www.vmware.com/products/site-recovery-manager/resource.html.
Procedure
1 When creating the database instance, specify UTF-8 encoding.
2 Create the SRM database user account.
3 Grant the SRM database user account the connect, resource, create session privileges and permissions.
Create an ODBC System DSN for SRM
You must provide SRM with a system database source name (DSN) for a 64-bit open database connectivity
(ODBC) connector. The ODBC connector allows SRM to connect to the SRM database.
You can create the ODBC system DSN before you run the SRM installer by running Odbcad32.exe, the 64-bit
Windows ODBC Administrator tool.
Site Recovery Manager Installation and Configuration
24 VMware, Inc.