Creating a VMware Site Recovery Manager Database

Standard

In this post, I’ll show you how to begin our initial setup for our Site Recovery Manager environment by creating our databases and making sure that we have the correct permissions setup for them.

 

    1. Connect SQL Server with SQL Mgmt Studio

      1

  1. Log in with SA or Windows Admin account, which has Full Rights for SQL Server
  2. Create SQL DB ( DB Name = DR_VM_SRM)

    2
    12

  3. Create Schema for DR_VM_SRM database. The schema name must be the same as  the user name. (Schema Name : DR_SRM_User)4
    5
  4. Create Database User for server login and ODBC connection.

Login Name: “DR_SRM_User” (MUST BE SAME AS SCHEMA NAME).

Select Default DB to “DR_VM_SRM”

6
7

Select “BULKADMIN” Server Role.

8

Select User Mapping to assign “Default Schema” and Database role membership for

  • db_accessadmin
  • db_backupoperator
  • db_datareader
  • db_datawriter
  • db_ddladmin
  • db_denydatareader(DON’T SELECT)
  • db_denydatawriter(DON’T SELECT)
  • db_owner
  • db_securityadmin9
  • public
  1. Select Schema owner for DR_SRM_User10
    11

And that’s all folk!!! That wasn’t too bad, now was it?!

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s