9 Microsoft SQL Server 2008R2 VM with Virtual Box

 

Software

• SQL Server 2008 R2 Standard on Windows Server 2008 R2 SP1 Standard (x64)
• Oracle Virtual Box 4.2.6

Create the VM

Since we are going to attached the Virtual disk later, Select Do not add a virtual drive.

 

Copy TD01WS08SFR2SP1x64.vhd to the VM folder

Remove the SATA control

Add TD01WS08SFR2SP1x64.vhd  under IDE control .If we add under SATA, we would receive the BLUE SCREEN upon the OS bootup.

In my Lab environment , I choice Bridged Adapter and ase t

Now start the VM.

If you receive the error like below, it is probably you already have another VM created with the same VHD file. ( Even it is the different COPY but each VHD have its own UUID when register with Virtual BOX).

Cannot register the hard disk 'D:\VirtualBoxVM\MSSQL1\TD01WS08SFR2SP1x64.vhd' {f7d3a3ca-d4c6-43be-84c5-ab5fb91e4a28} because a hard disk 'D:\VirtualBoxVM\MSSQL\TD01WS08SFR2SP1x64.vhd' with UUID {f7d3a3ca-d4c6-43be-84c5-ab5fb91e4a28} already exists.

Result Code: E_INVALIDARG (0x80070057)
Component: VirtualBox
Interface: IVirtualBox {3b2f08eb-b810-4715-bee0-bb06b9880ad2}
Callee RC: VBOX_E_OBJECT_NOT_FOUND (0x80BB0001)

The solution is to re generate the UUID for the VHD

 

"C:\Program Files\Oracle\VirtualBox\VBoxManage" internalcommands sethduuid D:\VirtualBoxVM\MSSQL1\TD01WS08SFR2SP1x64.vhd

 

The password is pass@word1

Reference

• http://www.sqlpanda.com/2011/10/virtual-box-with-microsoft-windows.html
• http://www.microsoft.com/en-ca/download/details.aspx?id=26113