Create a baseline environment for a BI test environment


Applies to: SharePoint Server 2010

This series of hands-on labs describe how to create a Microsoft SharePoint Server 2010 farm in an isolated Hyper-V test environment. This is the baseline environment that you will use for completing the further labs for configuring the business intelligence service applications available in SharePoint Server 2010.


The labs in this series give you hands-on experience configuring the business intelligence offerings in SharePoint Server 2010 by using an isolated Hyper-V test environment. These labs should not be used to create a production deployment of SharePoint Server 2010 on Hyper-V. For information about how to deploy your production SharePoint Server 2010 farm by using Hyper-V, see Use best practice configurations to prepare the Hyper-V environment (SharePoint Server 2010).

Creating the baseline environment consists of the following steps:

  1. Configure Hyper-V on the host computer

  2. Set up a virtual machine with a domain controller for the virtual test domain

  3. Add additional virtual machines to the virtual domain

  4. Set up accounts that are needed to deploy the SharePoint Server 2010 farm

  5. Set up Microsoft SQL Server 2008 R2

  6. Install and configure SharePoint Server 2010

  7. Configure the Secure Store Service

  8. Create a Business Intelligence Center

A hands-on lab is provided for each of these steps.


These labs assume that you are using Windows Server 2008 R2 and SQL Server 2008 R2. Windows Server 2008 and Microsoft SQL Server 2008 can also be used, although there may be some minor differences in procedures. Also, you may be unable to complete some labs, such as those using PowerPivot for SharePoint 2010, if you are using SQL Server 2008.

To get started creating the baseline environment, see Hyper-V quick start for creating a BI test environment, or, if you have already configured Hyper-V, see Set up a domain controller for a BI test environment.