vCenter Server 5.5 on SQL Server 2012 installation – Part 2

In the second post of vCenter 5.5 installation, I will cover following topics.

• MSSQL databases preparation
• MSSQL ODBC connectivity

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)

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 the database (in my case local).

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

Before installing vCenter server I added user ap-vcenter@marusiak.local 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 Marusiak\ap-vcenter. Go to Server Roles and grant user sysadmin rights.

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 which I will cover in third and last part of series.

In third post https://www.wojcieh.net/vcenter-server-5-5-on-sql-server-2012-installation-part-3/ I went through vCenter Server components installation.