vCenter SQL Database

1) Create vCenter Database

USE [master]
GO
CREATE DATABASE [vcenter-server] on PRIMARY
(NAME = N'vcenter-server', FILENAME = N'D:\Microsoft SQL Server\vcenter-server\vcenter-server.mdf', SIZE = 1024MB, MAXSIZE = 16384MB, FILEGROWTH = 512MB)
LOG ON
(NAME = N'vcenter-server_log', FILENAME = N'D:\Microsoft SQL Server\vcenter-server\vcenter-server.ldf', SIZE = 512MB, MAXSIZE = 2048MB, FILEGROWTH = 256MB)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO



2) Modify vCenter Database

USE [vcenter-server]
GO
ALTER DATABASE [vcenter-server] SET RECOVERY SIMPLE;
GO



3) Create user vpxdb

USE [vcenter-server]
GO
CREATE LOGIN [vpxdb] WITH PASSWORD = 'insert-a-password-here', DEFAULT_DATABASE = [vcenter-server], DEFAULT_LANGUAGE=[us_english], CHECK_POLICY=OFF
GO
CREATE USER [vpxdb] for LOGIN [vpxdb]
GO


USE [msdb]
GO
CREATE USER [vpxdb] FOR LOGIN [vpxdb]
GO



4) Add rights to vpxdb user account

USE [msdb]
GO
EXEC sp_addrolemember N'db_owner', N'vpxdb'
GO


USE [vcenter-server]
GO
sp_addrolemember [db_owner],[vpxdb]
GO