When you create a Microsoft SQL Server database, you must configure it correctly to support Site Recovery Manager.

You use SQL Server Management Studio to create and configure an SQL Server database for Site Recovery Manager to use.

This information provides the general steps that you must perform to configure an SQL Server database for Site Recovery Manager to use. For specific instructions, see the SQL Server documentation.

If you install SQL Server on a different machine to Site Recovery Manager Server, both of the Site Recovery Manager 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 Site Recovery Manager 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.

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 Site Recovery Manager service.

SQL Authentication

Leave the default local system user.

2

Create the Site Recovery Manager database user account.

3

Grant the Site Recovery Manager database user account the bulk insert, connect, and create table permissions.

4

Create the database schema.

The Site Recovery Manager database schema must have the same name as the database user account.

5

Set the Site Recovery Manager database user as the owner of the Site Recovery Manager database schema.

6

Set the Site Recovery Manager database schema as the default schema for the Site Recovery Manager database user.

7

(Optional) If you are using SQL Server 2012, configure the NT AUTHORITY\SYSTEM login.

You can use an SQL Server 2012 database with Site Recovery Manager Server 5.1.1 and later.

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.