SRM 5.1 AND MSSQL PERMISSIONS ISSUE DURING INSTALL

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

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Post Navigation