vCenter-Server-Part1

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 http://garvis.ca/2013/01/04/installing-netfx3-on-windows-server-2012/  it is explained how to fix.

Just execute the following command:

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

    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

  6. Installation Rules – just click next.
    SQL Server 2012 SP1 - Installation Rules
  7. 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
  8. Disk Space Requirements – setup will check if you have enough disk space on selected drive
    SQL Server 2012 SP1 - Disk Space Requirements
  9. 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
  10. 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
  11. Error Reporting – I don’t want to report anything to Microsoft 🙂
    SQL Server 2012 SP1 - Error Reporting
  12. Installation Configuration Rules – again setup is checking if everything will go smoothly
    SQL Server 2012 SP1 - Installation Configuration Rules
  13. Ready to Install – summary of selected features
    SQL Server 2012 SP1 - Ready To Install
  14. Installation Progress – can’t be more clear 😉
    SQL Server 2012 SP1 - Installation Progress
  15. Installation Finished – yay we got it 🙂
    SQL Server 2012 SP1 - Installation Finished

In second post https://www.wojcieh.net/vcenter-server-5-5-on-sql-server-2012-installation-part-2/  I described next steps to install vCenter Server 5.5.

vCenter Server 5.5 on SQL Server 2012 installation – Part 1
Rate this post
Wojciech Marusiak
Social Media

Wojciech Marusiak

Solution Architect at Alibaba Cloud
I am innovative and experienced IT professional with over 12 years in the IT industry.

My experience and skills have been proven by leading vendor certifications like AWS, Alibaba Cloud, VMware, and Microsoft. I contribute to IT community and I received VMware vExpert 2014 - 2017 and VMware vExpert NSX 2017 Award.

My blog wojcieh.net - was voted #43 in Top vBlog 2017 contest!

Do what you love, and you’ll never work another day in your life.
Wojciech Marusiak
Social Media