Part 1 VMware Site Recovery Manager 5 Database Install and Setup

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.

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

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.

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

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

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.

7. Expand Databases – vmwaresrm – Security – Schemas. Right click Schemas and select New Schema.

8. I will also name my schema vmwaresrm. Click Ok.

9. Expand the Security folder under the vmwaresrm tree. Right click the vmwaresrm user and select properties.

10. Next to Default schema select or type in vmwaresrm. Click Ok.

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.

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.

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

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.

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.

16. Select Change the default database to, and select vmwaresrm. Click Next.

17. Accept the defaults and click Finish.

18. A summary of your new System DSN will be displayed.

19. Click Test Data Source, and you should see TESTS COMPLETED SUCCESSFULLY!. Click Ok.

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.

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

David Rodriguez says:
September 5, 2013 at 17:07
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
Reply

Tejas says:
September 20, 2012 at 23:36
nice post… keep it up
David Rodriguez says:
February 22, 2013 at 09:19
Hi Mark, yes in Step 6 we link the vmwaresrm user to the database
ajbeen says:
September 5, 2013 at 06:56
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
- David Rodriguez says:
  September 5, 2013 at 17:07
  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