vCenter Update Manager SQL Database

1) Create vCenter Update Manager Database

USE [master]
GO
CREATE DATABASE [vcenter-update-manager] on PRIMARY
(NAME = N'vcenter-update-manager', FILENAME = N'D:\Microsoft SQL Server\vcenter-update-manager\vcenter-update-manager.mdf', SIZE = 128MB, MAXSIZE = 4096MB, FILEGROWTH = 128MB)
LOG ON
(NAME = N'vcenter-update-manager_log', FILENAME = N'D:\Microsoft SQL Server\vcenter-update-manager\vcenter-update-manager.ldf', SIZE = 64MB, MAXSIZE = 1024MB, FILEGROWTH = 64MB)
COLLATE SQL_Latin1_General_CP1_CI_AS
GO



2) Modify vCenter Update Manager Database

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




3) Create user vumdb

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


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



4) Add rights to vumdb user account

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


USE [vcenter-update-manager]
GO
sp_addrolemember [db_owner],[vumdb]
GO