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

In the second post of vCenter installation on Windows Server 2012 R2 with Microsoft SQL Server 2014 I will cover vCenter Databases creation and ODBC connectivity.

I used ISO VMware-VIMSetup-all-5.5.0-2183112-20140901-update02.iso which translates to following version of  vCenter Server 5.5 Update 2b, released 09 OCT 2014 with build number 2183111.

Microsoft SQL Server 2014 configuration

  1. Open SQL Server 2014 Management Studio and authenticate with username and password.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 2vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 3
  2. In SQL Server 2014 Management Studio and navigate to Security \ Logins  and click New Login.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 4
  3. In previous post we created application user called ap-mssql and ap-vcenter. I used ap-mssql user to start all SQL Server 2014 services and ap-vcenter will be used to start all VMware services. I will use ap-mssql user to connect between vCenter and SQL server.
  4. In General section I provided username
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 5
  5. In Server Roles section we select only public.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 6

vCenter Server 5.5 database creation

We will create vCenter database manually. We will use following options:

  • Collation – SQL Server Collation Model: SQL_Latin1_General_CP1_CI_AS.
  •  Recovery model – Full
  • Compatibility type – SQL Server 2014
  1. Click on Databases  and select New Database.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 7
  2. Enter your database name. I used a simple name vCenterDB and owner of DB is previously created user ap-mssql.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 8
  3. In Options I changed collation to SQL_Latin1_General_CP1_CI_AS, recovery mode to Simple and SQL compatibility model to SQL Server 2014.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 9
  4. Click OK.
  5. Last step is to change application user ap-mssql Default Database. Navigate to Logins and select your user. In General select Default Database to your vCenter Database.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 14
  6. Now we are ready to install vCenter.

vCenter Database backup

In earlier post I wrote that I will follow SQL Server Best Practices and I would like to configure Transaction Log backup in advance. Before we can execute Transaction Log backup we have to start full backup.

After full backup is completed we can prepare Transaction Log backup.

  1. Click on vCenter Database, select Tasks and Back up.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 10
  2. In General select backup type as Transaction Log. If you configured disks and SQL server as I did in earlier post, then backup destination will be pre-selected.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 11
  3. In Media  I selected Append to the existing backup set, Verify backup when finished and Back up the tail of  the log, and leave the database in the restoring state.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 12
  4. In Backup Options I selected expiration date of backup and compression level.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 13
  5. Click ok.

More detailed description is available on Microsoft MSDN article http://msdn.microsoft.com/en-us/library/ms189606.aspx.

MSSQL ODBC configuration

Last step before we will install vCenter Server Database is ODBC configuration.

  1.  Go to Control Panel and then to Administrative Tools and we select ODBC Data Sources (64-bit).
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 15
  2. Click System DSN, select Add and click SQL Server Native Client 11.0.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 16
  3. Provide name for the ODBC connection and select your SQL Server.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 17
  4. Select Change the default database to: and select your database.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 18
  5. Click next and finish. At the end click Test Data Source. If you configured everything correctly then you should see same result as I have.
    vcenter 5.5 on windows server 2012 r2 with sql server 2014 part 2 - 19

After preparing ODBC connectivity we can proceed with vCenter Server installation. This will be covered in third post.

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