vCenter 5.1 Update Manager: Installation

After the installation of vCenter 5.1, you can then proceed with the Update Manager if yu do use it and its strongly you use it to scan and check for update and apply these updates or patches to your VMware environment.

Refer to the vCenter Update Manager documentation page.  Here you will find the installation guide and the requirements for the database rights requirement.  I am using MS SQL in my demo here.  For other database please refer to the installation document.  In short for MS SQL, you need either a sysadmin role or db_owner of the database for the upgrade or installation.  In a corporate environment, typically sysadmin role is not allowed that leads to only the db_owner.

Also the requirement for MSDB is need as sysadmin or dbo_owner during installation or upgrade only.


Create vCenter Update Manager database with the rights.  The revoke of dbo role for the vumuser is at the bottom of the script commented out.
===========================================
use [master]
go

CREATE DATABASE [VUMDB] ON PRIMARY

(NAME = N'vumdb', FILENAME = N'd:\VUMDB.mdf' , SIZE = 2000KB , FILEGROWTH = 10% )

LOG ON

(NAME = N'vumdb_log', FILENAME = 'd:\VUMDB.ldf' , SIZE = 1000KB , FILEGROWTH = 10%)

COLLATE SQL_Latin1_General_CP1_CI_AS
go

ALTER DATABASE [VUMDB] SET RECOVERY SIMPLE /*or FULL*/
go

use VUMDB
go

sp_addlogin @loginame=[vumuser], @passwd=N'P@ssw0rd', @defdb='VUMDB', @deflanguage='us_english'
go

ALTER LOGIN [vumuser] WITH CHECK_POLICY = OFF
go

CREATE USER [vumuser] for LOGIN [vumuser]
go

sp_addrolemember @rolename = 'db_owner', @membername = 'vumuser'
go



use MSDB
go

CREATE USER [vumuser] for LOGIN [vumuser]
go

sp_addrolemember @rolename = 'db_owner', @membername = 'vumuser'
go

/* remove vumuser from dbo role from MSDB
use MSDB
go

sp_droprolemember @rolename = 'db_owner', @membername = 'vumuser'
go
*/

===========================================
Post a Comment

Popular posts from this blog

VMware VCIX Certification Clarification

Credit to VMware Certification

VMware vSphere 6.5 What's New