vCenter Server 5.5 on SQL Server 2012 installation – Part 1

Page content

vCenter Server Part - 1

In the first post, I will show you how to install Microsoft SQL Server 2012 to use it by vCenter Server 5.5 on Windows Server 2012. Next posts will cover Databases preparation and vCenter Server 5.5 installation.

Microsoft SQL Server 2012 SP1 installation

Before you actually launch SQL Server installation I recommend to run System Configuration Checker. This tool might really save your time when your installation will fail or you will have problems.

In my case, it was all ok.

Microsoft SQL Server 2012 System Configuration Checker

Installation of SQL Server is really not difficult (almost like 95% of Windows software - Next, Next, Next) and it has only FOUR steps.

  1. Insert product key or choose Evaluation or Express version
  2. Accept License terms
  3. Accept or not product updates
  4. Wait for finish

Next step is SQL Server Role Setup which is a bit more complicated.

Warning - NetFx3 during SQL Server 2012 SP1 installation

I ran into an error during SQL Server 2012 SP1 installation. When you selected desired/required for vCenter Server SQL Server Features setup will finish but you will receive an error that Windows feature NetFx3 was not enabled. It happened 1 out of 3 SQL Server installations but it is good to know how to fix it.

You will see following error:

SQL Server 2012 SP1 - NetFx3 error

And installation will fail with following errors:

“SQL Server 2012 SP1 - NetFx3 error summary

On blog it is explained how to fix.

Just execute the following command:

dism /online /enable-feature /featurename:netfx3 /all /source:D:\sources\sxs

SQL Server 2012 SP1 Feature Installation

In this section, we will go through the process of SQL Server installation.

  1. Setup Support Rules - In this screen setup will check if all prerequisites are met

    SQL Server 2012 SP1 - Setup Support Rules

  2. Product Key - just enter product key or select evaluation version

    SQL Server 2012 SP1 - Product Key

  3. License Agreement - accept license agreement

    SQL Server 2012 SP1 - License Agreement

  4. Setup Role - select **SQL Server Feature Installation

    SQL Server 2012 SP1 - Setup Role

  5. Feature Selection - choose following Features:
  • Database Engine Services
  • Client Tools Connectivity
  • Integration Services
  • Management Tools - Basic
  • Management Tools - Complete
  1. You can change as well directories where SQL are installed. I selected another drive to avoid filling OS partition.

    SQL Server 2012 SP1 - Feature Selection”

  2. Installation Rules - just click next.

    SQL Server 2012 SP1 - Installation Rules

  3. Instance Configuration - here you can change SQL Server instance name and instance directory. Again I changed it to a different drive.

    SQL Server 2012 SP1 - Instance Configuration

  4. Disk Space Requirements - setup will check if you have enough disk space on selected drive

    SQL Server 2012 SP1 - Disk Space Requirements

  5. Server Configuration - as I wrote at the beginning, I created a dedicated SQL domain user with strong password which will not expire. I set all services to automatic start.

    SQL Server 2012 SP1 - Server Configuration

  6. Database Engine Configuration - in this section I added mssql, vcenter, and my current account as SQL Administrators. I used Windows Authentication mode.

    SQL Server 2012 SP1 - Database Engine Configuration

  7. Error Reporting - I don’t want to report anything to Microsoft 🙂

    SQL Server 2012 SP1 - Error Reporting

  8. Installation Configuration Rules - again setup is checking if everything will go smoothly

    SQL Server 2012 SP1 - Installation Configuration Rules

  9. Ready to Install - summary of selected features

    SQL Server 2012 SP1 - Ready To Install

  10. Installation Progress - can’t be more clear 😉

    SQL Server 2012 SP1 - Installation Progress

  11. Installation Finished - yay we got it 🙂

    QL Server 2012 SP1 - Installation Finished


In second post I described next steps to install vCenter Server 5.5.