Creating vCenter and VUM 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.

28-09-2013-20-07-13_thumb228-09-2013-20-27-29_thumb128-09-2013-20-31-37_thumb2

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-16_thumb129-09-2013-02-01-07_thumb1

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_thumb1

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

Leave a Reply

Your email address will not be published. Required fields are marked *