Part 1 – Site Recovery Manager Database Setup

The first part of our guide to install and configure VMware Site Recovery Manager, is to configure the database.  When installing and configuring Site Recovery Manager, there are a couple of items that you should be aware of, prior to setting up the environment:

  • Both the protected site (source) and the recovery site (destination) need to have a Site Recovery Manager server
  • Make sure that your SRM application server is created prior to performing the following steps.  I would advise that the SRM server is a dedicated application server.
  • As both locations require a functioning SRM server, both locations therefore also need to have a functioning database connection as well.
  • If you are utilising array based replication (as discussed in these instructions), you need to make sure that you have compatible arrays at both locations and that you have already configured the replication configuration between the sites.

These are the instructions on how to create the database, these instructions need to be followed on both the protected and recovery sites:

  • Log onto the SQL Server and start up SQL Server Management Studio
  • Make sure that that you have created the relevant database and log folders on the relevant disks (this is in line with Microsoft best practices)
  • Create a new database making sure that the database and log files are located in the relevant folders on the correct disks.  Name your database so that it is distinguishable, in this test environment I would suggest calling the Recovery SRM database:  RecoverySRM and the Protected SRM database:  ProtectedSRM
  • You should now create a new SQL user account for the database – I would suggest calling the user by the same name as the database name making sure that the password is relatively complex – a suggestion for Recovery Site could be:
    Protected Site could be:    pR0t3ct3D51t3RM
  • When selecting Server Roles for the new account, it only needs to have the ‘Public’ role.
  • On the ‘User Mapping’ section, make sure that both ‘Public’ and ‘db_owner’ are selected for your database.
  • You should now also create a new schema, expand the database in SSMS, then ‘Security’ and then right mouse click on ‘Schemas’ and select ‘New Schema’
  • Call your schema by the same name as your database and then click ‘OK’
  • Go back to your new user within the database, right mouse click the user and select ‘Properties’
  • On the ‘Default schema’ line, replace the ‘dbo’ with the name of the new schema:
  • Click ‘OK’ to accept the changes
  • You can now close the SSMS and log off of the SQL server
  • You will now go through and configure a DSN for connectivity to the new SRM database.
  • Log onto the SRM application server
  • Make sure that you have installed the latest SQL Native Client onto the server.
  • Start up the ODBC application.
  • Switch to the ‘System DSN’ tab and click ‘Add’
  • Select the latest ‘SQL Server Native Client’ option and then click ‘Finish’
  • Give a suitable name to the DSN and select the correct database server, click ‘Next’
  • Select ‘SQL Server Authentication’ and then enter the username and password of the user you created on the SQL server.  Click ‘Next’ to continue
  • Make sure that the default database is configured to the database created earlier, then click ‘Next’
  • Click ‘Finish’ to complete the DSN creation.  Make sure that you test the connection to the database


This ends Part 1 of our instructions… please click here to continue to Part 2 or here to return to the 10-part Site Recovery Manager menu.

About the Author


I have been in IT for the past 15 years and using virtualisation technologies for around the past 8 years. I started, as quite a lot of people do, working with PCs after playing with such iconic systems like the ZX81, ZX Spectrum and then progressing through 386s, 486s, Pentiums etc. After being headhunted at sixth form to work for a small company based around Hertfordshire, UK. I began working with small businesses and gaining a lot of hardware experience. Three years later, after helping to increase the size of the business, I needed to gain exposure to a larger environment to progress my own career. I joined a large manufacturing company around Electronic Test and Measurement which progressed my skills onto more PC work, hardware work and then onto Server Operating Systems. I progressed again onto a consultancy company based in Reading, UK. Initially working as an engineer performing hardware / software installations for larger companies contracted out to the consultancy company, I moved up into a Consultant position continuing my travel across the UK assisting and providing solutions to companies. I finally moved on again to my current position, working back in Hertfordshire, UK. Again working for a large manufacturing company, this time with over 50,000 users worldwide. I am responsible for the datacenter hardware, the storage environment, the vmware environment and also implementing their new Citrix XenApp farm. My days are busy but also productive, its a friendly environment and in my four years of being with the company, I have seen many changes in technology and infrastructure in use within the company. About the site I started this site as I had been thinking of having more of a presence on the web for a while. On a daily basis, I perform tasks and use tools that others may not use or may not think to do and therefore I thought that I would share some of these experiences and tips with others to help with their day to day work. Currently, my main focus of work is around VMware and Veeam Backup & Replication but hopefully as my tasks progress, I’ll be able to share useful bits of information about other areas of IT as well.

Leave a Reply

Your e-mail address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.