VMware Site Recovery Manager 5 Database Setup
In this tutorial series we will be setting up VMware site recovery manager 5 within our vSphere 5 environment. Part 1 of the tutorial series will concentrate on setting up the SQL Database for site recovery manager 5 along with setting up the 32-bit system DSN to successfully connect back to the SQL database. I’m currently using the Microsoft SQL 2008 R2 Express Server that comes packages with vCenter 5. To be able to manage the SQL 2008 R2 Express Server you will need to download the Microsoft Management Studio by clicking here
VMware site recovery manager 5 Database Setup with Microsoft SQL 2008 R2 Express
1. Once you have Microsoft SQL Server Management Studio installed, go ahead and open it up. Connect to your SQL instance. Right click on the Databases folder and select New Database.



















Disclaimer:
All the tutorials included on this site are performed in a lab environment to simulate a real world production scenario. As everything is done to provide the most accurate steps to date, we take no responsibility if you implement any of these steps in a production environment.
nice post… keep it up
Hi Mark, yes in Step 6 we link the vmwaresrm user to the database
I work for VMware and a customer referenced this tutorial and missed the step to make the DB username match the schema name. I’m creating a KB article to address this, don’t know when that will go public though. Otherwise, I really like this tutorial, and am glad to see this type of material available from 3rd parties! Here is a link to the official guide with that specific section: http://pubs.vmware.com/srm-51/topic/com.vmware.srm.install_config.doc/GUID-84218C7E-3242-4A33-A771-71F944850319.html
Hi AJ not sure how they missed that step as it’s documented and screen shots are provided above. If you could reply with the KB article number once it’s know so if users come across this post they can click on the link ? Thanks