ESX Virtualization

VMware ESXi, vSphere, VMware Backup, Hyper-V... how-to, videos....

Menu
  • Shop
    • Datacenter
      • vSphere Essentials
      • vSphere Essentials PLUS
      • vSphere Standard
      • vSphere with Operations Management
      • vCenter Server Standard
      • vSphere Remote Office Branch Office
    • Desktop
      • VMware Workstation Pro
      • VMware Fusion Pro
      • VMware Fusion
      • Player Pro
    • Datacenter and Cloud
      • VMware SRM
      • vCenter Server Editions
    • Desktop
      • VMware Mirage
      • VMware Socialcast
      • Horizon Flex
      • VMware Horizon
    • Close
  • Study Guides
      • VCP6.7-DCV
          • VCP6.7-DCV 2019
        • Close
      • VCP6.5-DCV
          • VCP65-DCV-cert
        • Close
      • VCP6-DTM
          • VCP6-DTM
        • Close
      • VMware Mirage
          • miragepVMware Mirage
        • Close
    • Close
  • VMware
    • Configuration Maximums
    • vSphere
      • vSphere 6.7
      • vSphere 6.5
      • vSphere 6.0
      • vSphere 5.5
      • vSphere 5.1
      • Close
    • VMworld
      • VMworld 2018
      • VMworld 2017
      • VMworld 2016
      • VMworld 2015
      • VMworld 2014
      • VMworld 2013
      • VMworld 2012
      • VMworld 2011
      • Close
    • Close
  • Microsoft
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Close
  • Categories
    • Tips – VMware, Microsoft and General IT tips and definitions, What is this?, How this works?
    • Server Virtualization – VMware ESXi, ESXi Free Hypervizor, VMware vSphere Server Virtualization, VMware Cloud and Datacenter Virtualization
    • Backup – Virtualization Backup Solutions, VMware vSphere Backup and ESXi backup solutions.
    • Desktop Virtualization – Desktop Virtualization, VMware Workstation, VMware Fusion, VMware Horizon View, tips and tutorials
    • How To – ESXi Tutorials, IT and virtualization tutorials, VMware ESXi 4.x, ESXi 5.x and VMware vSphere. VMware Workstation and other IT tutorials.
    • Free Stuff – Free virtualization utilities, ESXi Free, Monitoring and free backup utilities for ESXi and Hyper-V. Free IT tools.
    • Videos – VMware Virtualization Videos, VMware ESXi Videos, ESXi 4.x, ESXi 5.x tips and videos.
    • Home Lab
    • Reviews – Virtualization Software and reviews, Disaster and backup recovery software reviews. Virtual infrastructure monitoring software review.
    • Close
  • Partners
    • Altaro
    • NAKIVO
    • StarWind
    • Veeam
    • Vembu
    • Zerto
    • Close
  • This Web
    • News
    • ESXi Lab
    • About
    • Advertise
    • Archives
    • Disclaimer
    • IT Books
    • Close
  • Free Tools
  • Books

vSphere 6.0 vCenter Server 6 Windows 2012 R2 Install Guide (With External SQL Server DB)

By Vladan SEGET | Last Updated: June 16, 2016

Shares

VMware vSphere 6.0 has brought simplified deployment model where the dependency on Microsoft SQL server is reduced by using the built-in vPostgre SQL provided by VMware. Supported databases for the windows installation are SQL 2008 R2, 2012 and 2014, Oracle 11g and 12c as well as the option to use an embedded vPostgres database. vPostgres on windows is limited to 20 hosts and 200 virtual machines.

Upgrades where SQL express was installed are converted to vPostgres. Check this video where vCenter Server 5.5 (with SQL Express) is upgraded to vCenter Server 6.0. The vCenter Server Appliance supports embedded vPostgres at full scale, 1000 host and 10,000 virtual machines and is the recommended database for the vCenter Server appliance

vSphere 6.0 vCenter Server 6 Windows 2012 R2 Install Guide

1. Make sure that you using static IP for your VM and you create forward and reverse DNS records on your DNS server. Also make sure that the machine is part of Windows domain.

2. Mount the vCenter server ISO and double click the autorun.exe

When you start the installer and your Windows Server VM isn't fully patched you might get a prompt to patch it like I did…

Microsoft Patches to apply first

There is two patches to install (at least for me…)

I needed two patches from Microsoft before I could install vCenter Server 6

Than you can continue the installer…

3. During the installation process you might get a prompt asking to give the administrator's account the right to Log On as a service. 

The steps:

  • Click Start, point to Control Panel, point to Administrative Tools, and then double-click Local Security Policy.
  • In the console tree, double-click Local Policies, and then click User Rights Assignment.
  • In the details pane, double-click Log on as a service.

Add the Log on as a service Right to an Account

  • Click Add User or Group, and then add the appropriate account to the list of accounts that possess the Log on as a service right.

4. Create system DSN through ODBC data source administrator (64-bit)

SQL server native client is necessary to create the sytem DSN. If you use the default windows “SQL server” option, it won't let you go forward…..

You'll need SQL server native client

To get SQL server native client from Microsoft – Download Instructions

It's a small 4-5 megs package called sqlncli.msi

First navigate to one of the download links below, then:

  • Do NOT hit the Download button
  • Expand the “Install Instructions” section
  • Scroll down to the “MICROSOFT SQL SERVER CONNECTIVITY FEATURE PACK COMPONENTS” section (it's far down)
  • Under the “Microsoft SQL Server 2012 Native Client” heading, click one of the “sqlncli.msi” installation package links. Make sure you choose the right version:
    • X86 Package for 32-bit
    • X64 Package for 64-bit
    • seems there are no link for the Itanium CPU architecture

You'll need SQL server native client

Donwload link: SQL Server 2012 Feature Pack

5. Continue the setup wizard and leave the default values… You should see this final screen after 15-20 min depending of the speed of your system…

vSphere 6.0 vCenter Server 6 Windows 2012 R2 Install Guide (With External SQL Server DB)

I have done a video detailing the steps (partly heavy accelerated to squeeze it to something to 2:35 only). Note that the SQL db gets created on the SQL server before the start of the installation. Usually there aren't any problems with that…

Watch in HD and Full screen… Enjoy.. -:)

If you like this post you might want to check the vSphere 6.0 page where you can find other details and how-to articles for vSphere 6.0.

Shares

| Filed Under: How To, Videos, Windows Server 2012 Tagged With: vSphere 6.0 vCenter Server 6 Windows 2012 R2 Install Guide 9 Comments

About Vladan SEGET

This website is maintained by Vladan SEGET. Vladan is as an Independent consultant, professional blogger, vExpert 2009 - 2018, VCAP-DCA/DCD, VCP. ESX Virtualization site has started as a simple bookmarking site, but quickly found a large following of readers and subscribers.

Visiting Indian Ocean and Reunion Island?

My wife Nicole and I just opened our B&B with private jacuzzi. Check it out! www.aloeveranature.fr

New! AloeveraBeach - Rent a Flat 300m from the beach. Capacity 4 pers.www.aloeverabeach.fr

Connect on: Google + or Facebook. Feel free to network via Twitter @vladan.

Comments

  1. Jerome says

    March 23, 2015 at 4:40 pm

    Hi Vladan

    I found to make a full unattened for vsphere 6 but when i create a Json file with the GUI it work and install great, but when i used the json created it found an error. to make a full unattened i make my DSN with the account sa mixed mode because when i lanched the install vsphere 6 don’t find my database and with the GUI it works. I Think i don’t find in the json the parameter “vc.svcuser” : “DOMAIN\\Administrateur”, “vc.svcuserpassword” : “[email protected]!”, but the parameter exist. Finally i used the mixed mode and it works great. Do you have an idea to automate the fact that the Account must open a session as a service ?

    Thank you.

    Reply
  2. Raymond says

    April 30, 2015 at 2:12 pm

    Hi,

    Why do you only have half a guide? For example, you need to create and populate a database BEFORE you can connect to a system DNS.

    Where is this step?

    Reply
    • Vladan SEGET says

      April 30, 2015 at 3:15 pm

      Hi, it’s precised in the sentence just BEFORE the video…. “that the SQL db gets created on the SQL server before the start of the installation. Usually there aren’t any problems with that”…. I knew that I should have detailed that as well -:). Yeah, right click > create Db, through SQL management?

      Thanks for the comment.

      Reply
  3. Balaji R says

    May 12, 2016 at 2:29 am

    Hi Vladan,

    Instated of SQL server can I use the MS SQL Express 2012 as a external database? and possible to migrate the Oracle DB to SQL Express?

    Thanks,
    Balaji R

    Reply
    • Vladan SEGET says

      May 12, 2016 at 7:18 am

      Hi Balaji,

      No, I don’t think that SQL Express can be used as an External DB… -:). The 6.0 uses vPostgreSQL.

      vPostgres on windows is limited to 20 hosts and 200 virtual machines. Upgrades where SQL express was installed will be converted to vPostgres. The vCenter Server Appliance supports embedded vPostgres at full scale, 1000 host and 10,000 virtual machines and is the recommended database for the vCenter Server appliance

      http://www.vladan.fr/vsphere-6-features-vcenter-server-details/

      Reply
      • Balaji says

        May 22, 2016 at 12:41 pm

        Thanks for Kind reply Vladan and sorry for the late reply.

        Finally we desired to go the vCSA but my concern is, we have Horizon View and vCloud director. If we use vCSA embedded database, is possible to create database for view composer and vCloud director?

        Reply
        • Vladan SEGET says

          May 22, 2016 at 4:04 pm

          Yes. Each of those 2 products can have its own (external) DB.

  4. reza says

    October 18, 2016 at 10:09 pm

    Hi dear vladan,

    I have a problem with vcenter 6.0 installation,

    I backed up my Vcenter 5.5 db and then, after vcenter 6.0 installation, i restored backup db to new sql server enterprise 2008 r2, but after that Vcenter services does not starts.

    What should i do?

    Reply
    • Vladan SEGET says

      October 26, 2016 at 6:55 am

      permissions?

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Nakivo Backup and Replication
Infinio AcceleratorZerto Automated DR for VMware that simply works
Click to Become a Sponsor

Featured

  • Free Backup for VMware and Hyper-V - NAKIVO Backup & Replication
  • FREE Forever—Back up VMware with Altaro VM Backup. Grab your Free copy now!

Most Recent

  • How To Migrate Shares and Files with ease by using Microsoft Storage Migration Service
  • VCP6.7-DCV Objective 4.4 – Set up ESXi hosts
  • USB Network Native Driver for ESXi Released as Fling
  • StarWind Storage Gateway for Wasabi Released
  • Top 3 Free Backup Software For VMware and Microsoft and their limitations
  • What is Host Guardian Service?
  • Vembu BDR Suite 4.0 Product Review
  • How To deploy VMware VCSA 6.7 U1 in VMware Workstation
  • Veeam Backup Community Edition – Download Now
  • Veeam Availability Suite 9.5 Update 4 Released with vSphere 6.7 U1 and Server 2019 Support

Most Read Posts

  • What are Open VM Tools and How to use them?
  • VMware vSAN 6.6 Announced
  • Veeam Backup And Replication 9.5 Update 2 Released
  • VCP6.5-DCV Objective 3.2 - Configure Software-Defined Storage
  • VCP6.5-DCV Objective 2 - Secure ESXi and vCenter Server
  • VCP6.5-DCV Objective 2.1 - Configure policies/features and verify vSphere networking
  • VCP6.5-DCV Objective 3.4 - Perform VMFS and NFS configurations and upgrades
  • VCP6.5-DCV Objective 1 - Configure and Administer Role-based Access Control
  • VMware vSphere Standard vs Enterprise Plus
  • What is VMware vSAN Disk Group?


Most Liked

  • VCP6.5-DCV Study Guide
  • vSphere 6.5
  • VCP6.7-DCV Study Guide
  • VCP6.5-DCV Objective 4.3 - Perform vCenter Server migration to VCSA
  • Zerto Virtual Replication 5.5 Update 3 Released


Virtualization Software From VMware

  • VMware vSphere 6.7 U1 Essentials PLUS - vMotion, vSphere Replication...Included
  • VMware vSphere 6.7 U1 Essentials - 3 hosts, vCenter
  • vSphere Hypervisor Per Incident Support Click Here.
  • VMware Workstation 15 Pro and Upgrades - Best Desktop Virtualization Software
  • VMware Fusion 11 - Run Windows on MAC, and Upgrades
  • VMware Fusion 11 Professional - Restricted VMs, Virtualized VT-X/EPT... and Upgrades
**************************************************************************
  • Upgrade to vSphere Editions
  • Upgrade to vSphere Enterprise Plus
  • Upgrade to vSphere with vSOM Enterprise Plus
  • Upgrade to vSphere with Operations Management Editions
  • Upgrade to vSphere with Operations Management Enterprise Plus

Free Software

Altaro VM Backup – Protect your VMware and Hyper-V VMs for Free with Altaro VM Backup. 2 VM for Free, forever. Grab your copy now!
Veeam One 9.5 U4 Free Edition – updated version of Veeam One Free edition

Free Trials

Veeam Backup and Replication 9.5 Trial DownloadVeeam Backup & Replication 9.5 U4 Full Version Download (30 Days Trial – Get Your Copy !

Find us on Facebook

ESX Virtualization

YouTube


Copyright © 2019 ·Dynamik Website Builder · Genesis Framework · Hosted with HostColor.com

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read More
X
Veeam Backup 9.5 U4 Community Edition
Download NOW