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.
Installation of SQL Server is really not difficult (almost like 95% of Windows software – Next, Next, Next) and it has onlyFOUR steps.
- Insert product key or choose Evaluation or Express version
- Accept License terms
- Accept or not product updates
- 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:
And installation will fail with following errors:
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.
- Setup Support Rules – In this screen setup will check if all prerequisites are met
- Product Key – just enter product key or select evaluation version
- License Agreement – accept license agreement
- Setup Role – select SQL Server Feature Installation
- 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.
- Installation Rules – just click next.
- Instance Configuration – here you can change SQL Server instance name and instance directory. Again I changed it to different drive.
- Disk Space Requirements – setup will check if you have enough disk space on selected drive
- 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.
- Database Engine Configuration – in this section I added mssql, vcenter and my current account as SQL Administrators. I used Windows Authentication mode.
- Error Reporting – I don’t want to report anything to Microsoft
- Installation Configuration Rules – again setup is checking if everything will go smoothly
- Ready to Install – summary of selected features
- Installation Progress – can’t be more clear
- Installation Finished – yay we got it
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.
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)
and select System DSN. Click Add and select SQL Server Native Client 11.0.
In new window provide data source name, description and location of database (in my case local).
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.
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.
In new window provide username – in my case local\administrator. Go to Server Roles and grant user sysadminrights.
Next go to User Mappings, select vCenterDB and grant user db_owner rights.
After all preparation was done we can easily install vCenter Server 5.5