Building the first SQL Server in the Lab – Part 2
We have a server with all of our hardware resources set up, now we will need to set up service accounts. You will need a service account… Read More »Building the first SQL Server in the Lab – Part 2
Building the first SQL Server in the Lab – Part 1
Now that I have a domain controller, I can start adding SQL servers. The first thing I need to do is to create another clone from my template. I did so, and named that new server SQL01. Before I start up this server, however, I want to add additional drives, so I can follow best practices of isolating the MDF, LDF, tempdb, and backup files. For a lab, it may seem a little like overkill, but I want to set up automated SQL installs, so having all of my disk partitions set up ahead of time is worth the effort for me.
To accomplish this, open up the VirtualBox console. I right-click on the newly created image, and select Settings (or highlight the server and click the Settings gear icon). I select the Storage page, and I see the currently allocated disk.
Here I want to click on Controller:SATA and then click the ‘plus’ icon on the right side.
This will bring up a dialog that asks is I want to create a new disk or use an existing one.
Read More »Building the first SQL Server in the Lab – Part 1
Create a Domain
The next step in creating a test lab is to take my first cloned machine created previously, and make it a domain controller. Although this is… Read More »Create a Domain
Cloning a Server
In the previous post, we laid the ground work for creating our test environment. Now that the groundwork has been completed, we will clone the server. Although this process will be for cloning my template to create a server that will become a domain controller, that is irrelevant here. The process is the same for any server.
To clone the image, in VirtualBox, right-click on the server template you have created, and select “Clone” from the context menu. Give the machine an appropriate name (in this case DC1) and select the option to reinitialize the MAC address. If you do not do this you will have MAC address conflicts when you run multiple cloned images.
Creating a Template
Once you have VirtualBox installed it is time to create your first virtual machine. It will become a template for all of the other machines. I will be using Windows Server 2008 R2, x64. You can download a 180 evaluation copy from Microsoft. You can download and then mount the ISO, or have a physical DVD.
Once you have some Windows Media available, fire up VirtualBox. When you do, you will see a screen that looks a little like the following image. This was not the first time I had fired up VirtualBox, so I had already played around and created a Linux image. Once the application is open, click the blue icon on the ribbon labled ‘New’.
Setting up Virtual Box
The first step in creating my test lab is to set up a virtual environment. As mentioned in a prior blog, I am using VirtualBox. … Read More »Setting up Virtual Box