How to install Site Recovery Manager (SRM) 5.8 or 6.x Part 2: using external database.

By | June 7, 2015

In the previous post here I showed how to install Site Recovery Manager using embedded database. In this post I will show how to install Site Recovery Manager (SRM) 5.8 or 6.x using external database.

Installing Site Recovery Manager (SRM) with external database

To install Site Recovery Manager with external database please follow below steps (based on SRM 6.0, similar to 5.8):

Creating an external database on Microsoft SQL Server:

At first we need to create a database on Microsoft SQL Server. There are some prerequisites for database account as follows:

  • You can use Integrated Windows Authentication or SQL authentication to connect to SQL Server. However Integrated Windows Authentication is recommended.
  • When you use Integraed Windows Authentication, please use the database account during the SRM installation process. When the Site Recovery Manager installer detects an SQL Server data source name (DSN) that uses Integrated Windows Authentication, it configures Site Recovery Manager Server to run under the same account as you use for the installer, to guarantee that Site Recovery Manager can connect to the database.
  • The Site Recovery Manager database must be the default database for all SQL connections that Site Recovery Manager makes. You can set the default database either in the user account configuration in SQL Server or in the DSN.
  • The Site Recovery Manager database schema must have the same name as the database user account.
  • The Site Recovery Manager database user must be the owner of the Site Recovery Manager database schema.
  • The Site Recovery Manager database schema must be the default schema for the Site Recovery Manager database user.
  • The Site Recovery Manager database user account has the ADMINISTER BULK OPERATIONS, CONNECT, and CREATE TABLE permissions.

To create a database please follow the steps:

  1. Log in to the SQL Server and run the SQL Management Studio.
  2. Create a SRM login.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation login
  3. Click User Mappings and specify the schema (the same as user). Select db_owner.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation login 2
  4. Create a database and specify the above SRM login as database owner. Right click on Databases and select New Database.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation DB
  5. Type a database name and specify created login as a database owner.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation DB 2
  6. Install the SQL Server Native Client 10.0 or SQL Server Native Client 11.0. You can download SQL Native Client 11.0 for SQL 2012 here. (sqlncli.msi X64)How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation sqlnative

 

Installing SRM with external Microsoft SQL database

  1. Double-click the Site Recovery Manager installer, select an installation language, and click OK. Click Next.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation 2
  2. Click Next.
  3. Follow the installer prompts to accept the license agreement, and verify that you satisfied the installation prerequisites.
  4. Enter information about the Platform Services Controller at the site where you are installing Site Recovery Manager and click Next.
  5. If prompted, verify the Platform Services Controller certificate and click Accept,
  6. Select the vCenter Server instance with which to register SRM and click Next.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db
  7. Select the default Site Recovery Manager plug-in identifier, or create a plug-in identifier for this Site Recovery Manager Server pair, and click Next. Both Site Recovery Manager Server instances in a of pair of sites must use the same plug-in identifier.
  8. Select a certificate type and click Next.
  9. Select whether to use a custom database, and click DSN Setup.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db2
  10. Click the System DSN tab and click Add. Select SQL Server Native Client 11.0 installed earlier.Click Finish.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db3
  11. Provide the details for the data source such as: a name for this data source and the running database instance to which to connect or enter the address of the database server.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db4
  12. Select the authentication method that corresponds to the type of database user account that you created and click Next. If you select Integrated Windows Authentication, you must use the same user account, or an account with the same privileges on the Site Recovery Manager Server host machine, when you run the Site Recovery Manager.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db5
  13. Change the default database to database created earlier.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db6
  14. Click Finish.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db7
  15. Now you can select Data Source. If you still can not see the created DSN, just type manually the DSN it and click Next.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db9
  16. You can specify connection count and max connections. Click Next.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external db10
  17. Specify password for the user account under which to run the Site Recovery Manager Server service and click Next.
  18. Start the installation process.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external 10
  19. The SRM should be installed successfully.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation external 11
  20. When you log out and log back to the Web Client, you should see the SRM icon.How to install and configure Site Recovery Manager (SRM) 5.8 or 6.x Part 1: Installation icon

Note: All above steps should be repeated in the secondary (DR) site.

3 thoughts on “How to install Site Recovery Manager (SRM) 5.8 or 6.x Part 2: using external database.

  1. Henry Gomez

    When you said:"All above steps should be repeated in the secondary (DR) site.", the DSN is the same? its ets, I will use the same database or I need to create a New one?

    Reply
    1. Mariusz Post author

      Hi Henry,

      You have to create the second (=dedicate) database and DSN in the DR site.

      Reply
  2. Kamal MOULINE

    Hello Mariusz,

    On step 3. Click User Mappings and specify the schema (the same as user). Select db_owner.
    you specify the dabase name but at this step it is not yet created, is it created on step 4.

    Can you please advise ?

    Thank You,
    Kamal

    Reply

Leave a Reply to Mariusz Cancel reply

Your email address will not be published. Required fields are marked *

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