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…
There is two patches to install (at least for me…)
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.
- 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.
- 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…..
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
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…
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.