vCenter Server SQL Server 2012 installation

Microsoft SQL Server 2012 SP1 installation

Before you actually launch SQL Server installation I recommend to run System Configuration Checker. This tool might really save your time when your installation will fail or you will have problems.

In my case it was all ok.

Microsoft SQL Server 2012 System Configuration Checker

Installation of SQL Server is really not difficult (almost like 95% of Windows software – Next, Next, Next) and it has onlyFOUR steps.

  1. Insert product key or choose Evaluation or Express version
  2. Accept License terms
  3. Accept or not product updates
  4. Wait for finish

Next step is SQL Server Role Setup which is bit more complicated.

Warning – NetFx3 during SQL Server 2012 SP1 installation

I ran on error during SQL Server 2012 SP1 installation. When you selected desired / required for vCenter Server SQL Server Features setup will finish but you will receive error that Windows feature NetFx3 was not enabled. It happened 1 out of 3 SQL Server installations but it is good to know how to fix it.

You will see following error:

SQL Server 2012 SP1 - NetFx3 error

And installation will fail with following errors:

SQL Server 2012 SP1 - NetFx3 error summary

On blog http://garvis.ca/2013/01/04/installing-netfx3-on-windows-server-2012/  it is explained how to fix.

Just execute following command:

dism /online /enable-feature /featurename:netfx3 /all /source:D:\sources\sxs

SQL Server 2012 SP1 Feature Installation

In this section we will go through process of SQL Server installation.

  1. Setup Support Rules – In this screen setup will check if all prerequisites are met
    SQL Server 2012 SP1 - Setup Support Rules
  2. Product Key – just enter product key or select evaluation version
    SQL Server 2012 SP1 - Product Key
  3. License Agreement – accept license agreement
    SQL Server 2012 SP1 - License Agreement
  4. Setup Role – select SQL Server Feature Installation
    SQL Server 2012 SP1 - Setup Role
  5. Feature Selection – choose following Features:
    • Database Engine Services
    • Client Tools Connectivity
    • Integration Services
    • Management Tools – Basic
    • Management Tools – Complete

    You can change as well directories where SQL are installed. I selected another drive to avoid filling OS partition.
    SQL Server 2012 SP1 - Feature Selection

  6. Installation Rules – just click next.
    SQL Server 2012 SP1 - Installation Rules
  7. Instance Configuration – here you can change SQL Server instance name and instance directory. Again I changed it to different drive.
    SQL Server 2012 SP1 - Instance Configuration
  8. Disk Space Requirements – setup will check if you have enough disk space on selected drive
    SQL Server 2012 SP1 - Disk Space Requirements
  9. Server Configuration – as I wrote at the beginning, I created dedicated SQL domain user with strong password which will not expire. I set all services to automatic start.
    SQL Server 2012 SP1 - Server Configuration
  10. Database Engine Configuration – in this section I added mssql, vcenter and my current account as SQL Administrators. I used Windows Authentication mode.
    SQL Server 2012 SP1 - Database Engine Configuration
  11. Error Reporting – I don’t want to report anything to Microsoft :)
    SQL Server 2012 SP1 - Error Reporting
  12. Installation Configuration Rules – again setup is checking if everything will go smoothly
    SQL Server 2012 SP1 - Installation Configuration Rules
  13. Ready to Install – summary of selected features
    SQL Server 2012 SP1 - Ready To Install
  14. Installation Progress – can’t be more clear ;)
    SQL Server 2012 SP1 - Installation Progress
  15. Installation Finished – yay we got it :)
    SQL Server 2012 SP1 - Installation Finished

vCenter Server 5.5 database creation

In order to create database execute following script //vCenter-Server/dbschema/DB_and_schema_creation_scripts_MSSQL.txt

Change database name, username, password and database location according to your setup.

use [master]
go
CREATE DATABASE [VCDB] ON PRIMARY
(NAME = N'vcdb', FILENAME = N'C:VCDB.mdf', SIZE = 3000KB, FILEGROWTH = 10% )
LOG ON
(NAME = N'vcdb_log', FILENAME = N'C:VCDB.ldf', SIZE = 1000KB, FILEGROWTH = 10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
go
use VCDB
go
sp_addlogin @loginame=[vpxuser], @passwd=N'vpxuser!0', @defdb='VCDB', @deflanguage='us_english'
go
ALTER LOGIN [vpxuser] WITH CHECK_POLICY = OFF
go
CREATE USER [vpxuser] for LOGIN [vpxuser]
go
use MSDB
go
CREATE USER [vpxuser] for LOGIN [vpxuser]
go

After Database is successfully created we should create ODBC connection which will allow vCenter to communicate with SQL Server.

MSSQL ODBC configuration

In your vCenter Server go to Control Panel Administrative Tools ODBC Data Sources (64-bit)

Windows Server 2012 ODBC Data Source (64-bit)

and select System DSN. Click Add and select SQL Server Native Client 11.0.

Windows Server 2012 SQL Server Native Client DSN

In new window provide data source name, description and location of database (in my case local).

Windows Server 2012 DSN 1

Change default database to vCenterDB, click next and Finish. Next step is to test if connection works. Click Test Data Source and you should receive information about successful connection.

Windows Server 2012 DSN 3

Before installing vCenter server I added the local administrator to security logins and I granted sysadmin rights to vCenterDB.

In order to do that go to SQL Server Management Studio and navigate to Security Logins and click New Login.

Windows Server 2012 New Security Login

In new window provide username – in my case local\administrator. Go to Server Roles and grant user sysadminrights.

Windows Server 2012 New Security Login Sysadmin

Next go to User Mappings, select vCenterDB and grant user db_owner rights.

Windows Server 2012 New Security Login dbowner

After all preparation was done we can easily install vCenter Server 5.5

Advertisements

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: