I was installing SRM 5.1 and ran into a DB permissions issue when the installation was in progress. Remember that the SRM database account makes the ODBC connection via the SQL client and requires the db_owner on the MSDB system database during the installation phase. Once the install is done, you can remove the db_owner permission.
Below is the error.
The DB user entered does not have the required permissions needed to install and configure vCenter Server with the selected DB. Please correct the following error(s): The database user ‘vcenter’ does not have the following privileges on the ‘vc50′ database:
EXECUTE sp_add_category
EXECUTE sp_add_job
EXECUTE sp_add_jobschedule
EXECUTE sp_add_jobserver
EXECUTE sp_add_jobstep
EXECUTE sp_delete_job
EXECUTE sp_update_job
SELECT syscategories
SELECT sysjobs
SELECT sysjobsteps
Follow Us!