6.1

Table Of Contents
n
Create an ODBC System DSN for Site Recovery Manager on page 20
You must provide Site Recovery Manager with a system database source name (DSN) for a 64-bit open
database connectivity (ODBC) connector. The ODBC connector allows Site Recovery Manager to
connect to the Site Recovery Manager database.
Requirements when Using Microsoft SQL Server with
Site Recovery Manager
When you create a Microsoft SQL Server database, you must configure it correctly to support
Site Recovery Manager.
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.
n
Database user account:
n
If you use Integrated Windows Authentication to connect to SQL Server and SQL Server runs on
the same machine as Site Recovery Manager Server, use a local or domain account that has
administrative privileges on the Site Recovery Manager Server machine. Use the same account or
an account with the same privileges when you install Site Recovery Manager Server. When the
Site Recovery Manager installer detects an SQL Server data source name (DSN) that uses
Integrated Windows Authentication, it configures Site Recovery Manager Server to run under the
same account as you use for the installer, to guarantee that Site Recovery Manager can connect to
the database.
n
If you use Integrated Windows Authentication to connect to SQL Server and SQL Server runs on a
different machine from Site Recovery Manager Server, use a domain account with administrative
privileges on the Site Recovery Manager Server machine. Use the same account or an account with
the same privileges when you install Site Recovery Manager Server. When the
Site Recovery Manager installer detects an SQL Server data source name (DSN) that uses
Integrated Windows Authentication, it configures Site Recovery Manager Server to run under the
same account as you use for the installer, to guarantee that Site Recovery Manager can connect to
the database.
n
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.
n
Make sure that the Site Recovery Manager database user account has the ADMINISTER BULK
OPERATIONS, CONNECT, and CREATE TABLE permissions.
n
Database schema:
n
The Site Recovery Manager database schema must have the same name as the database user
account.
n
The Site Recovery Manager database user must be the owner of the Site Recovery Manager
database schema.
n
The Site Recovery Manager database schema must be the default schema for the
Site Recovery Manager database user.
n
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.
n
Map the database user account to the database login.
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.
Site Recovery Manager Installation and Configuration
18 VMware, Inc.