ILIKESQL - Dandy Weyn's Blog

A query walked into a bar ...saw 2 tables and asked .. "Can I join you?"

SQL Server BareMetal Workshop series - part 1: How to build an installation VHD file that includes all software needed to start with SQL Server 2012 Database and Business Intelligence

SQL Server BareMetal Workshop series - part 1: How to build an installation VHD file that includes all software needed to start with SQL Server 2012 Database and Business Intelligence

  • Comments 3
  • Likes

I truly wanted to write this type of blog long time ago, but given the fact that next week I am teaching our SQL Server 2012 Workshop, for which I did the primary design and development (and thus also delivery),
I think it is very time appropriate to start with these series now.

In these series, I will start writing about how to build your own demo / test environment for SQL Server 2012 and business intelligence on a Windows Server 2008 R2 SP1 Hyper-V based installation.

This blog is written using my own method of installation, (unattended installations), and is purely based on publicly available Microsoft evalation copies of Sharepoint 2010, Visual Studio, SQL Server 2012 RC0, SQL Server Data tools, sample databases, and anything else you need to build your own VHD file (or non-vhd install base) that has everything offline that you need to do anything you always wanted to do with SQL Server and/or business intelligence.

In this blog, I will work based on a publicly available download of Windows Server 2008 R2 SP1, for which we will download the .ISO file to install the base operating system for my Virtual machine.

Bear in mind that this blog will be part of a series, in this part we only focus on getting you the right bits.

The BareMetal framework is a framework I use for the development of our hands-on-labs (www.microsoft.com/sqlserverlabs), and the outcome of these series is to have your own local copy of the Virtual machines used in the hands-on-labs on our lab portal.

 

Task 0: Assumptions and basic understanding

The scripting and file locations displayed below and I would suggest you follow the same folder structure,
you can however replace the drive letter X:\ wIth the driveletter where you actually extract and download your files to.

For some of the downloads you need to register with your Windows Live ID.

Some of the scripting could definetely be done in Powershell, VBscripting, WSH or any scripting language.
You'll see that I did stick to the basics - which frequently is just a simple .CMD file to perform some basic steps.

Task 1: Creating a folder that will hold all of your downloads:

Diskspace is mandatory if you want to create an install base, you will need approximately 40Gb of diskspace, since we will download files that need to be extracted.
Now what we want to accomplish with this, is to make sure that we have everything downloaded that we need, and of course we want to be able to use that in the most flexible way, by putting that into a VHD file so we can easily mount it into a VM,
or on any Windows 7 or Windows Server platform.

The folder structure will hold each of the downloads we perform in Task 2.

Now ofcourse I don't want you to manually create those, and when you extract the handy-dandy (what's in a name)  BareMetalWorkshopSeries-part1.zip file, as per attachement to the root folder of the drive you want to place al of your VMs and install bases,
you are pretty much ready to go.

 After extraction you are ready to go and pretty much will spend the next couple of hours downloading your all favorite software.

Task 2: Downloading everything you ever need to get started with SQL Server 2012 and Business Intelligence

 (Now look at this list - you'll have fun downloading for a bit)

Windows Server 2008 R2 64bit Edition, Installation .ISO file – with SP1

Required for:

VirtualMachine based installations

Download URL:

http://www.microsoft.com/windowsserver2008/en/us/trial-software.aspx

Destination Folder

x:\BareMetal\ServerISO

Notes

ONLY GET 64 BIT VERSION IN ISO FILE FORMAT

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Installs\ServerISO\WindowsServer2008R2.ISO

NOTE: you might have to rename the downloaded file

 


 

SQL Server 2008 R2 installation bits

Required for:

SQL Server 2008 R2 (nice if you want to do upgrade testing)

Download URL:

http://go.microsoft.com/fwlink/?LinkID=186656&clcid=0x409

Destination Folder

x:\BareMetal\Installs\SQL2008R2

Notes

ONLY GET 64 BIT VERSION in .EXE

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Installs\SQL2008R2 if not downloaded to the correct destination folder.

 

 


 

SQL Server 2008 R2 SP1

Required for:

SQL Server 2008 R2 (scripting will show how to slipstream)

Download URL:

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26727

 

Destination Folder

x:\BareMetal\Installs\SQL2008R2SP1

Notes

Download all the files as part of the SP1 update

After Download

Copy file to x:\BareMetal\Installs\SQL2008R2SP1 if not downloaded to the correct destination folder.

 

 


 

SQL Server 2012 installation files

Required for:

SQL Server 2012 Database & Business Intelligence

Download URL:

http://www.microsoft.com/sqlserver/en/us/future-editions.aspx

 

Destination Folder

x:\BareMetal\Installs\SQL2012

Notes

Download the ISO file version only

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Installs\SQL2012 if not downloaded to the correct destination folder

 

 


 

SharePoint 2010

Required for:

SQL Server 2012 Business Intelligence

Download URL:

http://www.microsoft.com/download/en/details.aspx?DisplayLang=EN&id=13768

 

Destination Folder

x:\BareMetal\Installs\SharePoint2010

Notes

ONLY GET 64 BIT VERSION in .EXE

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Installs\SharePoint2010 if not downloaded to the right folder location.

 

 


 

SharePoint 2010 SP1

Required for:

SQL Server 2012 Business Intelligence

Download URL:

http://www.microsoft.com/download/en/details.aspx?id=26623

Destination Folder

x:\BareMetal\Installs\SharePoint2010SP1

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Installs\SharePoint2010SP1 if not downloaded to the right folder location.

 


 

SharePoint 2010 Prerequisites

Required for:

SQL Server 2012 Business Intelligence

Download URL:

http://technet.microsoft.com/en-us/library/cc262485.aspx

Download all the required components

Destination Folder

x:\BareMetal\Installs\SharePointPrerequisites

After Download

Copy file to x:\BareMetal\Installs\SharePoinPrerequisites if not downloaded to the right folder location.

 


 

Office 2010 Professional Plus

Required for:

SQL Server 2012 Business Intelligence

Download URL:

http://technet.microsoft.com/en-us/evalcenter/ee390818

Destination Folder

x:\BareMetal\Office2010

Notes

ONLY GET 32 BIT VERSION

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Office2010 if not downloaded to the right folder location.

NOTE: SAVE the product key displayed as part of the download

 

 


 

Office 2010 SP1

Required for:

SQL Server 2012 Business Intelligence

Download URL:

Download Office 2010 SP1 (http://go.microsoft.com/fwlink/?LinkId=220084)

 

Destination Folder

x:\BareMetal\Office2010SP1

Notes

ONLY GET 32 BIT VERSION

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Office2010SP1 If you didn’t download to the right destination folder.

 


 

Visual Studio 2010 Ultimate ISO

Required for:

SQL Server 2012 Database & Business Intelligence

Download URL:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=06a32b1c-80e9-41df-ba0c-79d56cb823f7

Destination Folder

X:\BareMetal\Installs\VS2010Ultimate

Notes

Download All Files (4 files)

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to X:\BareMetal\Installs\VisualStudio2010 if not downloaded to this folder

 


 

SharePoint 2010 SP1

Required for:

SQL Server 2012 Business Intelligence

Download URL:

http://www.microsoft.com/download/en/details.aspx?id=26623

Destination Folder

x:\BareMetal\Installs\SharePoint2010SP1

Alternate locations

MSDN / TECHNET Subscription (MUST HAVE EXISTING ACCOUNT)

After Download

Copy file to x:\BareMetal\Installs\SharePoint2010SP1 if not downloaded to this folder

 


 

PowerPivot Client Software

Required for:

SQL Server 2012 Business Intelligence

Download URL:

http://www.microsoft.com/download/en/details.aspx?id=28150

 

Destination Folder

X:\BareMetal\Installs\PowerPivot

Notes

Download All Files

After Download

Copy file to X:\BareMetal\Installs\PowerPivot if not downloaded to this folder

 

 


 

SQL Server Data Tools CTP4

Required for:

SQL Server 2012 Database & Business Intelligence

Download URL:

http://msdn.microsoft.com/en-us/data/hh297027

Read the notes on how to Create an Administrative Install Point and perform those tasks after download in the folder where you downloaded the SSDT executable to.

Destination Folder

X:\BareMetal\Installs\SSDTCTP4

After Download

See steps described on the download page

 


 

Silverlight 5

Required for:

SQL Server Business Intelligence

Download URL:

http://www.silverlight.net/downloads

Download Silverlight Developer Runtime (32 bit) and (64 bit)

Destination Folder

X:\BareMetal\Installs\Silverlight

After Download

Copy file to X:\BareMetal\Installs\Silverlight if not downloaded to this folder

 

 


 

SQL Server Sample Databases

Required for:

SQL Server 2012 Database & Business Intelligence

Download URL:

http://msftdbprodsamples.codeplex.com/

Destination Folder

X:\BareMetal\Installs\Samples\SQL2008R2

X:\Baremetal\Installs\Sampes\SQL2012

Notes

Download All Files

After Download

Copy file to  X:\BareMetal\Installs\Samples\SQL2008R2

Copy file to  X:\BareMetal\Installs\Samples\SQL2012

 


 

Winrar (3rd party software – evaluation copy)

Required for:

Automated extraction during installation of several components

Download URL:

http://www.rarlab.com/download.htm

Destination Folder

X:\BareMetal\Installs\Winrar

Notes

Download All Files, extract to the x:\BareMEtal\Installs\Winrar

 


 

PowerShell Management Library for Hyper-V

Required for:

Automation of the creation of Virtual Machines

Download URL:

http://pshyperv.codeplex.com/

Destination Folder

X:\BareMetal\Installs\PSHyperV

Notes

Download All Files

 


 

BGINFO

Required for:

Automate the setting of desktop backgrounds

Download URL:

http://technet.microsoft.com/en-us/sysinternals/bb897557.aspx

Destination Folder

X:\BareMetal\Installs\Tools\BGINFO

Notes

Download All Files

 

 

 

 

 

 

 

 

Task 3: How to extract all these downloads with the least administrative effort?

Extracting of downloaded files (.ISO, .ZIP, .EXE) etc can be a tough one, depending on what your purpose of the extraction is,
Some of the downloads would automatically start the installation process, which we want to prevent of course, we rather extract and have a solid installation base that we put into a VHD file, so that it is easy
to mount in both Windows, as a Windows Server 2008 R2 based Hyper-V image.

If any graphical UI interface pops up (including a request to format your newly mapped VHD file, please ignore)

Step 1: Creating a VHD file using diskpart

Open and administrative command prompt to x:\BareMetal\Hostscripts

type the following command:

BuildInstallVHD.VHD

This script will create a VHD file in x:\BareMetal\InstallVHD using DiskPart

Step 2: Extract all of the downloaded files into the VHD file

In the same administrative command prompt type LoadInstallsVHD.CMD

This script will run for a bit and 'voila' - after that you will have a drive letter (mapped as M: drive) with all your installation bits

Step 3: Dismount the VHD if you want to attach it to a Virtual Machine

In the same administrative command prompt [x:\Baremetal\Hostscripts], type the following command

UnmountInstallVHD.CMD

Task 4: What's next?

In the next part of these series will write about the automated creation of a Virtual Machine using the Hyper-V Powershell Management Library.
in the series post after that we will then look into the installation process and correct installation steps to get you going with:

  • SQL Server installations on Windows Server Core
  • SQL Server installations and configuration of AlwaysOn
  • SQL Server and Sharepoint 2010 integrated (PowerPivot, Power View)

 

Attachment: BareMetalWorkshopSeries-part1.zip
Comments
  • I hate to be snarky but nothing has been done.  I hope your posts are proof read better for errors.

    When will the zip file be updated?

  • Congradulations!  3 months and still no response.  My last comment was even left off.  My guess your "excuse" will be the launch events.

  • Hi Gene - certainly not an excuse around launch events or whatsoever --- The Baremetal effort is primarily a personal effort which gets impacted by work prioritizations. At this stage I am in the process of updating the content to RTM bits - with updated materials.

    We are bringing some of this content to events like TechED North America and PASS Summit, and I will update by that timeframe.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment