SQL Server Virtual Lab Section 1

Back to Main page

**New** This Video was produced to assist and enhance this tutorial Click Here.

A. Installing Hyper-V Role and Management Tools

No need to reinvent the wheel here. Just follow the directions on this site:

B. Create Virtual Switch

1. Click on Virtual Switch Manager on the right hand side


2. In the box on the right select Internal and click to create a new Virtual Switch

3. Name your Virtual Switch and press Ok.

C. Create a new Virtual Machine (VM) using Hyper-V

1. Press the ACTION > New > Virtual Machine
HyperV12. Give your Machine a name and a save location.

3. Set the amount of RAM you wish to use (for Server Core just use 512MB for a Full Windows 2012 Installation we will use 2048MB of RAM- No need to configure Dynamic Memory)
4. Select your Virtual Switch in the networking section (the one created in Part B)
5. Create a new Virtual Hard Drive that is 20GB in size if you are doing the Core install and 30GB in size for the Full install. Make sure you change the default location if you want it to be stored elsewhere. By default a Dynamically expanding disk will be created, so the space will only increase as it is used up.

6. Select the source for your Windows .ISO installation disk

7. Click Next and then Finish
8. Double click your VM to connect and then click the Green Start button to start it up.

D. Create Windows 2012 Full Installation Base Virtual Hard Drive

***We will create a new Base VM for the Windows 2012 Full Installations using differencing disks***
1. Once the VM boots up it should go to the Windows Installation. This should be easy to follow, but make sure you select a Full Installation.
2. Once the installation is done, login with a new password you will create and then shut down the virtual machine. Yes you heard me right, shut down 🙂
3. We’re going to use this installation as a Base for our other Windows 2012 Full Installations using a great Hyper-V feature called Differencing Disks.
4. In Hyper-V Manager right click on that new VM you just created and press Delete. YES PRESS DELETE!!
5. OK remember where you stored the Virtual HD you created for the VM? Great… because it has not been deleted and we will use it to create our SQL Machine.

E. Creating your first SQL Server 2012 Test machine using a Base Windows 2012 Full Installation

1. In Hyper-V Manager click ACTION > New > Hard Disk
2. Click Next on the First screen and keep the default (VHDX) and click next
3. Select Differencing Disk on the next screen

4. On the next screen name your drive and select the location. For mine, I already created a folder where I’m going to put the VM and I’m putting the Virtual Hard Drive there. For example my new Differncing will be placed under V:\Hyper-V Machines\SQL2012NodeA (since my first VM will be called SQL2012NodeA)

5. On the next screen specify the parent… the Virtual Hard Drive we created for the Base Windows 2012 Full Installation in Part D. For example my Base Windows 2012 Installation is under V:\Hyper-V Machines\Windows2012Base.

6. Click Finish then ACTION > New > Virtual Machine
7. Name your VM and select the save location (preferably where you put that Differencing Disk or wherever you want just don’t blame me if you are disorganized). I named my VM SQL2012NodeA since I’m going to make it the first node when I start clustering.
8. Select 2048MB for Memory and select your Virtual Switch in the networking section as you did the when you created your first VM.
9. Now for your Hard Disk, select the Differencing Disk that you just created. Click Next and Finish.

10. In Hyper-V Manager, right click your latest VM and click on Settings. Click on Hard Drive under IDE Controller 0, then on Inspect, and on the first pop- up click Inspect Parent. Just verify the settings so everything is alright.

11. Start up the virtual machine and verify that everything works. The Base Virtual Hard Drive should cease growth, and your new Differencing drive should start to grow when you install SQL Server. Nice technology right? Well, we’re going to add another SQL Server VM using the same base! Yep, you can add more servers to the same Base drive, it remains intact so you an have multiple environments using one installation.

Continue to Section 2


One response to “SQL Server Virtual Lab Section 1

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: