SRM with VMAX 20K – Part II: Configuring SQL Databases

The installation of Site Recovery Manager requires an SQL Database. I took the decision to install SQL Server 2012, running on Windows Server 2012R2.

Both the Server and SQL database were built in accordance with best practices and procedures as documented within my organisation.

Here are the steps of the SQL setup needed for SRM to work.

Database Creation

1) Login to the SQL Server via RDP

2) Open SQL 2012 Management Studio and connect to the correct instance.

3) Create a SQL Service account to use for Site Recovery Manager. Under the Navigation -> Security tab, right click logins and select “New Login”. Enter in the login name you want for the account and set it up for SQL Server Authentication.

SRM_SQL1

4) Ensure that the user is given necessary permissions on the SQL Server itself.

SRM_SQL2

5) Create the SRM database by right clicking Databases and selecting “New Database…”

6) Enter in a name for your SRM DB and select the Owner as the account created in step 3.

SRM_SQL3

Setup Database Connection

1) Login to your SRM Server on the first site.

2) Install the SQL Native client, which will be needed for the ODBC connection.

3) Open C:\windows\system32\odbcad32.exe

4) Under the System Tab, Create a new DSN as follows.

SRM_SQL4

SRM_SQL5

SRM_SQL6

SRM_SQL7

SRM_SQL8

5) To finish, test the data source and ensure connectivity works as expected.

After I had done this, I completed the same above steps but on the Secondary (Recovery) site SRM server. Therefore each SRM instance in each site had a working local SQL database to use and was ready to proceed with the SRM installation!

Leave a Reply

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