To use SQL Server 2008 or SQL Server 2008 R2 for the VMM database, SQL Server Management Tools must be installed on the VMM server. Instead I am going to install SQL 2008 R2. I want to integrate my implementation with SCOM so I will NOT use Express. If you use the SCVMM Setup Wizard to install SQL Server, the VMM 2008 R2 Setup Wizard installs SQL Server 2005 Express Edition SP3 (the VMM 2008 Setup Wizard installs SQL Server 2005 Express Edition SP2). For more information about integrating VMM with Operations Manager, see Configuring Operations Manager Integration with VMM ( ). Therefore, it is recommended that you use a full version of SQL Server when you are managing more than 150 hosts or when you want to integrate VMM with Operations Manager.

The SQL Server 2005 Express Edition database size is limited to 4 GB and is not supported for integrating VMM with System Center Operations Manager 2007 for Reporting and Monitoring features in VMM. For more information about supported versions of SQL Server, see System Requirements: VMM Database.

A supported version of Microsoft SQL Server is needed.

You can find it at How To Install IIS 7 on Windows Server 2008 R2 SP1 For Use With SCVMM 2008 R2 SP1. I created a detailed step by step post on how to do this. Because I plan on using reporting services, I am going to setup IIS on this machine.

I need to install some prerequisite software before I can install SQL Server.

Once I get the system up and running, I will bump up the memory to be close to what I actually need but I will leave it dynamic. I have allocated 2 processors and 512mb memory to the guest using dynamic memory.

I am starting with a sysprep’d Windows Server 2008 R2 Server.

Download sql server 2008 r2 iso