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.


VMware Site Recovery Manager 5
2. I’m going to name my site recovery manager 5 database vmwaresrm. Click Ok.


VMware Site Recovery Manager 5
3. Now I will create an SQL user account for my vmwaresrm database. Expand the Security folder and right click on Logins and select New Login.


VMware Site Recovery Manager 5
4. I will also name my SQL user account vmwaresrm and give it a password. Make sure you untick Enforce password expiration.


VMware Site Recovery Manager 5
5. Click on Server Roles on the left hand side and make sure public is selected.


VMware Site Recovery Manager 5
6. Click on User Mapping on the left hand side and select the vmwaresrm database, for role membership make sure both public and db_owner are selected. Click Ok.


VMware Site Recovery Manager 5
7. Expand Databases – vmwaresrm – Security – Schemas. Right click Schemas and select New Schema.


VMware Site Recovery Manager 5
8. I will also name my schema vmwaresrm. Click Ok.


VMware Site Recovery Manager 5
9. Expand the Security folder under the vmwaresrm tree. Right click the vmwaresrm user and select properties.


VMware Site Recovery Manager 5
10. Next to Default schema select or type in vmwaresrm. Click Ok.


VMware Site Recovery Manager 5
11. Because we are using SQL authentication for our site recovery manager 5 database, we need to make sure our SQL server allows it. Right click your SQL server from the left hand sane pane and select properties. Select the Security menu from the left hand side and under Server Authentication make sure SQL Server and Windows Authentication mode is selected. If Windows Authentication mode was previously selected and you change to mixed mode authentication, you will need to restart your SQL services. Click Ok.


VMware Site Recovery Manager 5
12. You can now close SQL Management Studio as we have completed setting up our site recovery manager 5 database. Now we will configure the System DSN so that we can connect successfully through to SQL. VMware site recovery manager 5 requires a 32-bit ODBC connection, therefore to launch this we need to browse to C:WindowsSysWOW64 and launch the odbcad32.exe application.


VMware Site Recovery Manager 5
13. Select the System DSN tab and click Add. Make sure you select the SQL Server Native Client 10.0 and click Finish.


VMware Site Recovery Manager 5
14. Give your site recovery manager 5 System DSN a name, I will call mine vmware srm. Select the server that you wish to connect to. If you are using the SQL 2008 R2 express edition that comes with vCenter 5 your SQL server instance will be servernameVIM_SQLEXP. Click Next.


VMware Site Recovery Manager 5
15. Select With SQL authentication and type in the SQL username that we created earlier. In this tutorial we created the vmwaresrm user. Click Next.


VMware Site Recovery Manager 5
16. Select Change the default database to, and select vmwaresrm. Click Next.


VMware Site Recovery Manager 5
17. Accept the defaults and click Finish.


VMware Site Recovery Manager 5
18. A summary of your new System DSN will be displayed.


VMware Site Recovery Manager 5
19. Click Test Data Source, and you should see TESTS COMPLETED SUCCESSFULLY!. Click Ok.


VMware Site Recovery Manager 5
Continue onto Part 2 VMware Site Recovery Manager 5 Install

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.

4 Comments

  1. 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

Leave a Reply

Your email address will not be published.


*


*

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