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 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 to run System Configuration Checker. It is 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 fromPowerShell 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://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 progress.
    vCenter 5.5 on Windows Server 2012 R2 with SQL Server 2014 - 17

This concludes 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
Wojciech Marusiak
Social Media

Wojciech Marusiak

Consultant at VMware Global, Inc.
I am innovative and experienced VMware and Windows Server Engineer with over 10 years in the IT industry specializing in VMware virtualization and Microsoft Server environment.

My experience and skills has been proven by leading vendor certifications like VMware Certified Advanced Professional 5 – Data Center Administration, VMware Certified Advanced Professional 5 – Data Center Design, VMware Certified Professional 6 - Data Center Virtualization, VMware Certified Professional 6 - Network Virtualization, Microsoft MCITP Server Administrator, ITIL V3, VMware vExpert 2014, 2015, 2016 and 2017 Award.

My blog wojcieh.net - was voted #50 in TopvBlog 2016 contest!
Wojciech Marusiak
Social Media
%d bloggers like this: