Administrative credentials are required for Oracle and SQL Server databases when installing or upgrading vCenter Server (1003052)
grant connect to <user>
grant resource to <user>
grant create view to <user>
grant create any sequence to <user> # For vCenter upgrade only
grant create any table to <user> # For vCenter upgrade only
grant execute on dbms_job to <user>
grant execute on dbms_lock to <user>
grant unlimited tablespace to <user> # To ensure space limitation is not an issue
Microsoft SQL Server 2000 and SQL Server 2005 Standard and Enterprise
For Microsoft SQL Server, the vCenter Server database login needs the db_owner role for the vCenter Server and MSDB databases.
The MSDB db_owner role is used during the vCenter Server installation or upgrade to add three scheduled SQL Server Agent jobs. During normal operations, these jobs are run by the SQL Server Agent to maintain statistical data. Once the installation or upgrade is complete, the db_owner role may be removed from the MSDB database.
Do not change the System Administrator Server role (sysadmin) for the vCenter Server database login account when upgrading from a previous release of vCenter Server. Changing the sysadmin role on your vCenter Server database login to meet permissions requirements can cause the upgrade to fail and install a new set of tables.
If during the upgrade, the license screen has an option box that says: I want to evaluate the product first, the installer has not correctly recognized the previous vCenter Server database. Press the Back button and review your database permissions in SQL Manager. When satisfied, press Next again to continue with the upgrade.