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 and to create the database user account for Site Recovery Manager to use.

This information provides the requirements for an SQL Server database for use with Site Recovery Manager. For specific instructions about creating an SQL Server database, see the SQL Server documentation.

  • Database user account:

    • If you use Windows authentication to connect to SQL Server, and SQL Server runs on a different machine from Site Recovery Manager Server, use a domain account that also has administrative privileges on the Site Recovery Manager Server machine. Instead of using a local administrator account, use the same domain account to install Site Recovery Manager Server. You must use this domain account so that the Site Recovery Manager installer can perform database operations during installation. After installing Site Recovery Manager Server, ensure that the Site Recovery Manager service is running under the domain account, rather than under the local system account.

    • If SQL Server is running on the same machine as Site Recovery Manager Server and you use Windows authentication, the same requirements apply as for a remote SQL Server, but you can use a local administrator account instead of a domain user account.

    • If you use SQL authentication, you can run the Site Recovery Manager service under the Windows Local System account, even if SQL Server is running on a different machine to Site Recovery Manager Server. The Site Recovery Manager installer configures the Site Recovery Manager service to run under the Windows Local System account by default.

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

  • Database schema:

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

    • The Site Recovery Manager database user must be the owner of the Site Recovery Manager database schema.

    • The Site Recovery Manager database schema must be the default schema for the Site Recovery Manager database user.

  • The Site Recovery Manager database must be the default database for all SQL connections that Site Recovery Manager makes. You can set the default database either in the user account configuration in SQL Server or in the DSN.

    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.

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.