Search the VMware Knowledge Base (KB)
View by Article ID

Administrative credentials are required for Oracle and SQL Server databases when installing or upgrading vCenter Server (1003052)

  • 16 Ratings

Details

When preparing an Oracle or Microsoft SQL Server database for a fresh install or upgrade of vCenter Server, special permissions must be granted to the user account that vCenter Server uses to access the database.

Solution

Oracle Database

For Oracle databases, assign the DBA role to the user, or grant these permissions to the user:

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, 2005, 2008, and 2012 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. After the installation or upgrade is complete, the db_owner role may be removed from the MSDB database.

Important upgrade notes:
  • 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 Back and review your database permissions in SQL Manager. Press Next again to continue with the upgrade.
Note: For more information on Database user permissions, see the Database Permission Requirements for vCenter Server section in the vSphere Upgrade Guide.

Additional Information

For translated versions of this article, see:

Tags

database-credentials

Update History

04/19/2010 - Added vCenter Server 4.0 to Products. 11/09/2015 - Added vCenter Server 5.x and 6.0 products.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 16 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 16 Ratings
Actions
KB: