Creating vCenter and VUM 5.5 databases.

29th September 2013 0 By Simon

As a precursor to installing vCenter 5.5 in my 2012R2 lab at home I needed to create the vCenter and VUM databases in SQL 2012 and make sure that everything was setup correctly before the vCenter installation.

To make things easier I used the SQL Scripts below to create two DBs (VC55 and VUMDB) as well as creating the vc_user account and password.

[code lang=”sql”]USE MASTER;
GO
CREATE DATABASE [VC55] ON PRIMARY(
NAME=’VC55′,
FILENAME=’D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\VC55.mdf’,
SIZE=5000KB,
FILEGROWTH=10%)
LOG ON
(NAME=’VC55_log’,
FILENAME=’E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\VC55.ldf’,
SIZE=1000KB,
FILEGROWTH=10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
[/code]

[code lang=”sql”]USE MASTER;
GO
CREATE LOGIN vc_user WITH PASSWORD = ‘changeme’, DEFAULT_DATABASE = VC55
GO
USE VC55;
GO
ALTER AUTHORIZATION ON DATABASE::VC55 TO [vc_user]
GO
USE MSDB;
GO
CREATE USER [vc_user] FOR LOGIN [vc_user]
GO
EXEC sp_addrolemember ‘db_owner’, ‘vc_user’
GO[/code]

[code lang=”sql”]
USE [MASTER];
GO
CREATE DATABASE [VUMDB] ON PRIMARY
(NAME=’vumdb’,
FILENAME=’D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\VUMDB.mdf’,
SIZE=5000KB,
FILEGROWTH=10%)
LOG ON
(NAME=’vumdb_log’,
FILENAME=’E:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\VUMDB.ldf’,
SIZE=1000KB,
FILEGROWTH=10%)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO

USE VUMDB;
GO
ALTER AUTHORIZATION ON DATABASE::VUMDB TO [vc_user][/code]

Copy the above scripts in to SQL Management Studio and you should be good to go with the creation of the DBs and the user account.

VC55 DB Creationvc_user creationVUMDB creation

It’s important to change the Recovery model from Full to Simple (you don’t want to be running out of disk space.

29-09-2013 02-00-1629-09-2013 02-01-07

And finally make sure that the IP Address is enabled for your IP4 address (by default it’s disabled).

29-09-2013 02-10-03

In the next post I will show you how to install vCenter 5.5 on to Windows 2012R2 Server.