SRM Installation using SQL Express

Installation Accounts:

 

SQL Install Account – SQLService

vCenter and SRM Install Account – VMService

(Optional) Enterprise Manager Install Account – EMService

Note 1: These accounts should be domain user accounts, and they must be local admin on the relevant servers.

Note 2: The EMService is optional as can install the Enterprise Manager Data Collector as a Local Service Account

 

Part 1: Install the SQL Servers

 

DB01

1.1 Login with the SQLService account

1.2 Launch the en_sql_server_2008_r2_express_x64 application and follow the ‘New installation…’ wizard to install all components to the D drive

Image

Note: A typical install of SQL 2008 R2 Express with all features, installed to the D drive is fine for hosting the vCenter and SRM databases

1.3 After installation of SQL 2008 R2 Express, open up SQL Server Configuration Manager, expand SQL Server Network Configuration, select Protocols for SQLEXPRESS, enable Named Pipes, enable TCP/IP, right-click TCP/IP, select properties, and for every IP Address listed in TCP/IP Properties, enter the TCP Port number 1433

.Image

1.4 SQL Server Services – restart SQL Server (SQLEXPRESS)

1.5 SQL Server Services – SQL Server Browser set to automatic start and start

1.6 Install SQL Server 2008 R2 Management Studio Express x64

1.7 Open up SQL Server Management studio, and create the following databases – SRM

1.8 Create a new SQL login for the DOMAIN\VMService account and assign it the sysadmin server role, and db_owner roles for the newly created databases

 Image

DB02

1.9 Repeat 1.1 to 1.8!

** Note if using Equallogic SANs and doing SAN to SAN replication. Download and install the SRA from Equallogics website on both SRM servers. If using any other vendor install the SRA from that Vendors Website**

Your SQL Database is now setup and configured. You can go back to you vSphere client and manage your plugins. Download and install the SRM plugin.

Advertisements