Articles

Thursday, October 17, 2013

The database user 'vpxuser' does not have the following privileges on the 'VCDB' database

I ran into a minor issue while updating my vCenter Server to version 5.5 tonight. Below is screenshot of the error:


Simply add the permissions to the database to fix it:

use MSDB
go
sp_addrolemember @rolename = 'db_owner', @membername = 'vpxuser'
go
GRANT EXECUTE ON msdb.dbo.sp_add_category TO vpxuser
go
GRANT SELECT on msdb.dbo.sysjobsteps to vpxuser
go
GRANT SELECT ON msdb.dbo.sysjobs to vpxuser

No comments:

Post a Comment