Bander's Blog

Welcome to the 3rd part of this guide. We have a vanilla cream Windows Server 2008 installation with Active Directory Domain Services and DNS roles installed and configured. The next step is installing SQL Server 2008.

First of all we need to mount the SQL Server image on the virtual machine drive. Using the Hyper-V Virtual Machine Connection window click on Media, DVD Drive, and select Insert Disk. If you do a have a DVD media instead of an ISO image then select Capture.

A browse dialog will be opened. You need to browse to the image location, select it, and click Open.

AutoPlay dialog will open. Click on Run Setup.

SQL Server setup will prompt you for .net Framework 3.5 with SP1 setup. You don’t need an active Internet connection because the framework files are available on the DVD. Click OK.

The framework setup will start loading.

Read the license terms and if you are ok with it select I have read and ACCEPT the terms of the License Agreement. Click Install.

The wizard will start installing the framework.

After you get a successful installation of the .net Framework click Exit.

Setup will now prompt you for another prerequisite which is Windows Installer 4.5. Click OK.

The wizard will start installing Windows Installer.

After the installation is complete you will be asked to restart. Click Restart Now.

After the restart launch the setup again. This time the SQL Server Installation Center will be loaded. Click on Installation.

Click on SQL Server stand-alone installation or add features to an existing installation.

Setup will run a prerequisite check before launching the setup. Click OK.

Enter the product key and click Next.

Read the license terms and if you are ok with it place a check next to I accept the license terms and click Next.

Click Install to start installing the Setup Support files.

Setup will start the installation of the Setup Support files.

When the installation of the Setup Support files is finished another prerequisites check will be made. You will get warnings about its not ok to install SQL Server on a domain controller and that SQL Server ports rules are not configured on the firewall. Ignore these 2 warnings because we need to install everything on one virtual machine for our sandbox.

Enter the Product Key and click Next.

Read the license terms and if you are OK with place a check next to I accept the license terms and click Next.

Click Select All to install all SQL Server features and click Next.

Keep the default Instance Id and click Next.

A disk space check will run to make sure that the target disk drive have enough space for SQL Server. Click Next.

Best practice is to run each service with a different account. Since we are building a sandbox I don’t think it’s necessary. We will all the services under the administrator account. Click on Use the same account for all SQL Server services, enter the administrator user name including the domain name and the password, and click OK.

As you can see all services now run under one domain account. Click Next.

Select Mixed Mode and specify a password for the SA account. Make sure to add the current user which is the administrator by clicking on Add Current User and click Next.

Click on Add Current User to grant the administrator domain user administrative privileges on Analysis Services. Click Next.

Select Install the native mode default configuration. Click Next.

Since this is not a production environment, no need to send error reports to Microsoft. Click Next.

One last check is done before starting the actual installation. Click Next.

A summary of the SQL Server features to be installed will be displayed. Click Install.

The wizard will start installing SQL Server. This will take around 5 to 10 minutes. It depends on the features selected.

A summary will be displayed when the installation is complete. Click Next.

The setup completion screen and a link to the log file will be displayed. Click Close.

Now we are done with the preparation of the SharePoint 2010 Server virtual machine. In the next post we will start with the 4th and last part of this guide which is installing SharePoint 2010 Server. If you ran into any issues during the SQL Server 2008 installation, please don’t hesitate to contact me