I recently decided to upgrade my vSphere 4 lab to vSphere 5, one of the things I did at the time was consolidate my SQL environments to a single platform (I have in the past had SQL 2005, 2008 and various SQL Express environments up for one reason or another), I decided at this time that I was going to install a dedicated SQL server (VM of course) that would be my single source for any db. requirements.
I decided to install Microsoft SQL Server 2008 R2 as this happens to be the latest supported product (Denali having only just come out I am not sure on the number of the products that support it), like most of my environment SQL 2008 R2 will be hosted on a Windows 2008 R2 server joined to my AD domain.
Installing SQL 2008 R2 isn’t taxing, for the most part it’s a next next next but there are a couple of caveats that you need to be aware of, especially if you’re going to be using it as the host for any VMware products.
Using my TechNet subscription I downloaded SQL 2008 R2 to run the installation.
(more…)