ESX Virtualization

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

Nakivo Backup and Replication - #1 Backup solution for Virtual, physical, cloud, NAS and SaaS

Menu
  • Certification
      • VCP-DCV vSphere 8
          • vcp2024-125.
        • Close
    • Close
  • VMware
    • Configuration Maximums
    • vSphere
      • vSphere 8.0
      • vSphere 7.0
      • vSphere 6.7
      • vSphere 6.5
      • vSphere 6.0
      • Close
    • VMworld
      • VMware EXPLORE 2024
      • VMware EXPLORE 2023
      • VMware EXPLORE 2022
      • VMworld 2019
      • 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 – 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
    • NAKIVO
    • StarWind
    • Zerto
    • Xorux
    • Close
  • This Web
    • News
    • ESXi Lab
    • About
    • Advertise
    • Archives
    • Disclaimer
    • PDFs and Books
    • Close
  • Free
  • Privacy policy

Install vCenter Server on Windows Server 2012 – SQL Setup (Part 1)

By Vladan SEGET | Last Updated: June 16, 2016

Shares

Since vSphere 5.1 U1 it's possible to install vCenter Server on Windows Server 2012. Also a Microsoft SQL 2012 is supported as an external database. The software requirements of the latest vSphere has been outlined in my post which discuss the new features of VMware vSphere 5.1 Update 1.

Since the vSphere 5.1, the architecture of vCenter has changed and another DB is present – SSO (single sign on DB). So there are now three databases present:

  • VMware vSphere 5.1 Single Sign-On DB
  • VMware vSphere vCenter server DB
  • VMware Update Manager DB

All those DB can be installed on a separate Microsoft SQL Server 2012 (this post)  or on the same VM as vCenter server (with simple install or individually). SQL 2008R2 Express is still the DB bundled with the latest version of vSphere.

As a side note, the vCSA (vCenter as Linux VM) has still the same limitations in terms of functions and scalability, but I'm sure it will be getting better… The deployment is really simple and easy, also the upgrades. So if you don't need Linked vCenter functionality or don't have requirement for more than 5 host or 50 VMs, the embedded DB with the vCSA is 10′ deployment…

Now lets come back to our project. You should check the Product Interoperability Matrixes first. We will be preparing two Windows Server 2012 VMs. One for vCenter and one for SQL. I skip here the installation of the base OS, setting fixed IP address and proper DNS configuration, as I suppose that anyone know how to do it. It's possible that you've seen different kind of setup for Windows Server 2012, as I'm not claiming to be the only one out there writing about it. But as I progress through the study/installs in my lab, I like documenting the steps, mostly for my own purpose e. If it can help others, that's even better.

The vCenter Server VM requirements:

  • 64-bit system DSN to connect to its database (installed from the same media as SQL Server 2012 – just install the “management tools”)
  • I recommend getting the latest patches from Microsoft before going further.

The SQL Server 2012 VM:

  •  .NET 4.5 is normally installed by default after a fresh installation of Windows Server 2012. If not, add this as a feature through the server manager.
  • Run the SQL Configuration Checker (use Run as an Administrator option)  which shows you the missing requirements before you install the SQL server. Note that

SQL-config

If you see a warning saying that the Windows firewall needs to open some ports, there is no need to do it now, and you can continue with the installation process.

When clicking the Installation link, choose your own option depending which type of installation you're doing. In our case we just do fresh install (no upgrade).

sql-install

  • On the next screen you'll have to enter the product key (or you can use the 180 days trial) – the second option.
  • Accepting the license terms don't need a screenshot either..
  • You have the option to include SQL server products updates (my case) which are directly downloaded from the Microsoft update site. I took that option.

updates

  • Chose the SQL server feature installation which allow you to install the SQL server database engine services along with the analysis, reporting and integration services.

SQL-setup

  • On the next page you can choose the features that you will want to install and use. You'll definitely need the Database Engine Services. And from the shared features Management Tools Basic and complete, Client tools connectivity. I picked also client tools backwards compatibility option (update: finally, it's not needed). You can always come back, re-execute the installer to add/remove those features later. What I usually do is to keep the shared directory on the system drive (default option) even if you can also change the installation folder there.

sql-options

  • On the next page, there is a choice between the Windows authentication mode and Mixed mode (SQL server and Windows authentication).

SA-account2

I've setup the SQL Server agent with automatic startup, as well checked the SQL Server Database engine (not changed), but disabled the SQL Server Browser.

SQL-services

Concerning the directories, I just create a separate folder on the C drive. It might not be the best practice as you might would want to install the DB data to separate drive(s) but I'll stick with that for now.

sql-data

Next following the setup pages, there is   “Specify SQL Server administrators” part where you can add any other users which will have access to the SQL Server. By clicking the next button, after a validation page (or two), you'll start the installation process… and the finish should look like this…

SQL-complete

That clores the Installation part for the SQL server. But it's not finished yet, as we need to configure few things and create our DBs for vCenter server, SSO and VUM. The steps for Configuring Microsoft SQL Server Databases are documented in the official VMware documentation page.

  • First, we need to connect by using the Microsoft SQL Server Management studio with the “SA” account. We will be using a script which is available from the VMware vSphere 5.1 documentation page. You just need to change the path where you want to store your database and the vpxd user's password. See the screenshot from my lab. (click to enlarge).

Location of the scripts is on the vCenter Installation ISO – in this path:

/<installation directory>/vCenter-Server/dbschema/DB_and_schema_creation_scripts_MSSQL.txt.

Creating vCenter Server database.

First script – the example is located here – is to create SQL server database and user for vCenter server.

script-vcdb

The second script – the example is located here – is to create a vCenter Server User by using the dbo schema and db_owner database role.

use VCDB
go
sp_addrolemember @rolename = 'db_owner', @membername = 'vpxuser'
go
use MSDB
go
sp_addrolemember @rolename = 'db_owner', @membername = 'vpxuser'
go

The result should looks like this:

script-vcdb2

Third Script – located here – Create MS SQL server DB schema and Roles. You should get clean output with no errors.

third

Creating vCenter SSO (single sign on) database.

The database creation scripts are located at this location when you mount the vCenter installation DVD:

Single Sign OnDBScriptsSSOServerschemamssql

There are two scripts which we will need:  rsaIMSLiteMSSQLSetupTablespaces.sql and also rsaIMSLiteMSSQLSetupUsers.sql. 

First, open the first script and modify the necessary name of the Database (I renamed the default “RSA” to “SSO”) and the paths to where the database data will be located.

SSO-creation

Then similarly, change the second script (rsaIMSLiteMSSQLSetupUsers.sql )to fit your needs.

sso-db

Make sure that the RSA_DBA user and vpxuser do have sysadmin roles in the user mappings.

Single Sign On

Creating vCenter Update Manager Database

The same punition, we need a database for VUM. Remember, that it's 32bit DSN that we will need to create when we will configure the DSN connection to this database, later on. To create the VUM database, use this script (change to fit your needs concerning the path and the user's password. This is my lab output):

go

CREATE DATABASE [VUM] ON PRIMARY
(NAME = N'vum', FILENAME = N'C:SQL_DATAMSSQL11.VMWAREMSSQLDATAVUM.mdf', SIZE = 3000KB, FILEGROWTH = 10% )
LOG ON
(NAME = N'vum_log', FILENAME = N'C:SQL_DATAMSSQL11.VMWAREMSSQLDATAVUM.ldf', SIZE = 1000KB, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
go
use VUM
go
sp_addlogin @loginame=[vumuser], @passwd=N'Your_super_Password', @defdb='VUM', @deflanguage='us_english'
go
ALTER LOGIN [vumuser] WITH CHECK_POLICY = OFF
go
CREATE USER [vumuser] for LOGIN [vumuser]
go
use MSDB
go
CREATE USER [vumuser] for LOGIN [vumuser]
go

vum-db

Now, make sure that all 3 databases are setup to Recovery Model – Simple. If not, you'll receive a warning message during the installation saying that the full recovery model will eventually consume all available disk space.

simple

You have created 3 essentials databases that are needed before you start installing vCenter server.

At this point, we need to make sure that the TCP/IP settings are configure the right way in order to connect remotely to the SQL server. Go to the start menu and start the SQL server configuration manager.  Make sure that the TCP/IP protocol is set to enabled Yes and that the IP address tab, where the appropriate interface's TCP Dynapic Ports is set to 0.

enabled

Now, go over to the vCenter VM. The vCenter VM needs a SQL driver for the SQL ODBC connection. To install it on the vCenter VM, just mount the SQL server installation ISO as we need to install the exact same version of the driver as used for the SQL server installation.

Do exactly the same steps as we did on the SQL server VM, but as for the installation options choose the Management Tools – Basic only.

basic

Find the second part where we'll configure ODBC, install SSO, vCenter Server and other components.

Shares
5/5 - (1 vote)

| Filed Under: How To, Windows Server 2012

About Vladan SEGET

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

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

Comments

  1. karlochacon says

    May 7, 2013 at 4:51 am

    really nice guide I was thinking it was pretty light SQL installation demostration but it cover all topics cool guide

    by the way why did you choose “client tools backwards compatibility”? I don’t select it but I want to know what I am missing

    thanks

    • Vladan SEGET says

      May 7, 2013 at 8:16 am

      Thanks. No particular reason, forget about those. After checking the MSDN site, there isn’t any reason for that.

  2. chris says

    February 3, 2016 at 1:47 am

    Follow with the installation on next page – > lead to nothing

    • Vladan SEGET says

      February 3, 2016 at 6:56 am

      Now corrected. The page has no more page breaks, and there is a follow up post… Thanks a lot…

Private Sponsors

Featured

  • Thinking about HCI? G2, an independent tech solutions peer review platform, has published its Winter 2023 Reports on Hyperconverged Infrastructure (HCI) Solutions.
  • Zerto: One Platform for Disaster Recovery, Backup & Cloud Mobility: Try FREE Hands-On Labs Today!
Click to Become a Sponsor

Most Recent

  • FREE version of StarWind VSAN vs Trial of Full version
  • Commvault’s Innovations at RSA Conference 2025 San Francisco
  • VMware ESXi FREE is FREE again!
  • Installation of StarWind VSAN Plugin for vSphere
  • Protect Mixed environments with Nakivo Physical Machine recovery (bare metal)
  • No more FREE licenses of VMware vSphere for vExperts – What’s your options?
  • Tails – Your Private OS on USB Stick
  • StarWind V2V Converter Now has CLI
  • Veeam VHR ISO v2 – 2025 Download and Install
  • Deployment OVA and Installation of Nakivo Backup and Replication for VMware

Get new posts by email:

 

 

 

 

Support us on Ko-Fi

 

 

Buy Me a Coffee at ko-fi.com

Sponsors

Free Trials

  • DC Scope for VMware vSphere – optimization, capacity planning, and cost management. Download FREE Trial Here.
  • Augmented Inline Deduplication, Altaro VM Backup v9 For #VMware and #Hyper-V – Grab your copy now download TRIAL.

VMware Engineer Jobs

VMware Engineer Jobs

YouTube

…

Find us on Facebook

ESX Virtualization

…

Copyright © 2025 ·Dynamik-Gen · Genesis Framework · Log in