Build your own SQL2012 Demo Machine Part 1 – Preparation & Summary

I’ve been through many a trauma building all-up demo virtual machines with SQL 2012 Denali and RC0 editions. Now that RTM is here, I’m going to go through it again. However to save all of you many of those pains, I’m going to help you out by giving precise, every step of the way instructions.

At the end of it all you will have a blank demo server with all features of SQL2012, SharePoint 2010 with Reporting Services, PowerPivot and PowerView, and Office 2010 ready to demo.

Note there’s some bits I missed out in the first version of the posts which are highlighted in red and dated.

Step 1: Get some hardware

  • Find yourself a machine with a 64 bit operating system and at least 100GB of spare disk space and 8GB of RAM
  • If this machine has only one internal Hard Drive get an External drive with 100GB of spare disk space
  • Download all the software
  • Obtain valid license keys
  • Follow this guide

Important Hard Drive recommendation: VM’s run significantly better if they aren’t sharing a Hard Drive with the Host Operating System, so all installation should be on a secondary drive. If your machine has two internal drives, create the VM on the secondary one. If your machine only has one internal hard drive I strongly recommend getting an external USB drive to create the VM on.

Step 2: Download all the software you’ll need

These are the components you’ll need. You’ll need access to an MSDN subscription or the install media for core Microsoft components.

If you are a VMWare or other Virtualisation technology fan, use that instead. Be aware Microsoft’s own VirtualPC is of no use as it doesn’t support 64 bit guest OS’s.

Step 3: Build your base VM

Click here for the detailed walkthrough.

In summary we:

  • Create a VM to host a Windows Server 2008R2 environment
  • Give it a 80GB fixed disk to install to
  • Give it at least 4GB RAM

Step 4: Install Windows Server 2008R2

Click here for the detailed walkthrough.

In summary we:

  • Do a Full Installation of Windows Server 2008R2 SP1 – Enterprise Edition
  • Make it a Domain Controller (guide here)
  • Turn Off Internet Explorer Enhanced Security Configuration
  • Install Silverlight (needed for PowerView)

Step 5: Install SQL Server 2012 twice

Click here for the detailed walkthrough.

In summary we:

  • Do a Full Feature Install of SQL Server 2012 Enterprise Edition
  • Do a Second Install of Analysis Services in Tabular Mode
  • Configure Data Quality Services (added 01 May 2012)
  • Configure Master Data Services (added 22 May 2012)

Step 6: Install SharePoint and PowerPivot for SharePoint

Click here for the detailed walkthrough.

In summary we:

  • Run the SharePoint 2010 Prerequisites Installer
  • Install but do not configure SharePoint 2010
  • Install SharePoint 2010 Service Pack 1
  • Install SQL Server again for PowerPivot for SharePoint features
  • Run the PowerPivot for SharePoint configuration tool
  • Install and Start the Reporting Services SharePoint Service
  • Create the Reporting Services SharePoint Application
  • Enable Report Builder components in SharePoint (added 02 May 2012)

Step 7: Install Office Components

Click here for the detailed walkthrough.

In summary we:

  • Install Office 2010 Professional components (notably Excel)
  • Install the Data Mining for Excel AddIn
  • Install the PowerPivot for Excel AddIn

 Step 8: Tweak Windows Server 2008R2 (optional)

Click here for the detailed walkthrough.

In summary we:

  • Disable some unused services for performance reasons

Step 9: Use it!

This concludes what has been one of my most epic blog posts ever. I hope it helps you on your SQL Server journey :)

About BI Monkey

Comments

8 Responses to “Build your own SQL2012 Demo Machine Part 1 – Preparation & Summary”
  1. Mark says:

    James, you may want to add this step in the Server Setup

    http://www.msprojectnow.com/Blog/tabid/142/entryid/290/Default.aspx

    It is a necessary feature for being able to publish to Sharepoint from Excel 2010

    Thanks soooooo much for these awesome walkthroughs by the way.

  2. Andreas says:

    Just found these awefull walkthroughs. Thanks a lot.

    Why are you using Office 64bit instead of 32 bit? Any special reason?

  3. BI Monkey says:

    Hoping you mean awesome, not awful…

    Office 64 bit purely for additional memory access for PowerPivot

Trackbacks

Check out what others are saying about this post...
  1. […] Build your own SQL2012 Demo Machine Part 1 – Preparation & Summary Share this:EmailPrintFacebookShareDiggRedditStumbleUpon […]

  2. SQL Server says:

    Resources for Installing and Configuring BI with SharePoint 2013 and SQL Server 2012…

    I’m embarking on a new project to build a brand new squeaky clean VM environment from the ground…

  3. SQL Server says:

    Resources for Installing and Configuring BI with SharePoint 2013 and SQL Server 2012…

    I’m embarking on a new project to build a brand new squeaky clean VM environment from the ground…

  4. SQL Server says:

    Resources for Installing and Configuring BI with SharePoint 2013 and SQL Server 2012…

    I’m embarking on a new project to build a brand new squeaky clean VM environment from the ground…

  5. […] and share all the steps I’ve taken in these blog posts. This series will be a lot like the one by BI Monkey (blog | twitter), except that I’ll be using SharePoint 2013 and SQL Server 2012 SP1 features. […]



Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!