vCenter-5.5--on-Windows-Server-2012-R2--with-SQL-Server-2014---Part-1

It has been a while since I was dealing with vCenter on SQL Server simply because I used vCenter Server appliance. In series of post, I would like to guide you through the installation of Microsoft SQL Server 2014, vCenter database creation and preparation and vCenter 5.5 Update 2 installation.

In my guide I will use following software:

  • Operating System – Windows Server 2012 R2 Datacenter Edition
  • Database – Microsoft SQL Server 2014 Enterprise Edition
  • VMware – VMware vSphere 5.5 Update 2b

Microsoft SQL Server 2014 preparation

Following Microsoft SQL Server best practices  I will install SQL Server 2014 with following disk layout:

  • Disk 1: OS/SQL Binaries
  • Disk 2: System databases (aside from tempdb)
  • Disk 3: tempdb
  • Disk 4: User databases
  • Disk 5: User DB transaction logs
  • DIsk 6: VMware vCenter Server binaries

vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 1

  1. Before installation, I recommend running System Configuration Checker. It is a tool which checks if all necessary components required by SQL Server 2014 are installed.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 2
  2. Another thing that we have to do before installation is enabling of.Net Framework 3.5 Service Pack 1. We can do it simply from PowerShell by executing following command.

    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 11
  3. We will create application users: ap-mssql and ap-vcenter and we will use it to run SQL Server services and vCenter services. I described how to do it in this post: https://www.wojcieh.net/how-to-create-application-user-in-active-directory/

Microsoft SQL Server 2014 installation

  1. We switch to Installation section and select New SQL Server stand-alone installation or add features to existing installation.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 3
  2. Provide SQL Server 2014 product key or select evaluation.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 4
  3. Accept the license terms and if you want you can join Customer Experience Improvement Program also called CEIP.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 5
  4. Choose if you want to receive Microsoft Updates to patch SQL Server 2014.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 6
  5. Click next and Setup will initiate another check to make sure that there will be no problems.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 7
  6. Click next and select SQL Server Feature Installation
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 8
  7. Choose following features:
      • Database Engine Services
      • Client Tools Connectivity
      • Integration Services
      • Management Tools – Basic
      • Management Tools – Complete

    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 9

  8. And select following directories:
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 10
  9. In Instance Configuration, I selected Default instance and I clicked Next.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 12
  10. To run all SQL services we will use user called ap-mssql.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 13
  11. I added my user as SQL Server administrator. I selected Windows authentication mode.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 15
  12. As I wrote at the beginning I will distribute directories across different disks.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 16
  13. Select Install and watch the progress.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 17

This concludes the installation of Microsoft SQL Server 2014 on Windows Server 2012 R2. In the next post, I will proceed with SQL Server configuration.

Rate this post
Social Media

Wojciech Marusiak

Solution Architect at Alibaba Cloud
I am an innovative and experienced IT professional with over 13 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 the IT community and I received VMware vExpert 2014 - 2019, vExpert Pro and VMware vExpert NSX 2017 Award.

My blog wojcieh.net - was voted #76 in Top vBlog 2018 contest!

Do what you love, and you’ll never work another day in your life.
Wojciech Marusiak
Social Media
%d bloggers like this: