Creating vCenter and VUM 5.5 databases.

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.

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

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

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