Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides

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)

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, either 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 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.

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 the Back button and review your database permissions in SQL Manager. When satisfied, press Next again to continue with the upgrade.

Note: For further information on Database user permissions you can reference the Database Prerequisites section in the vSphere Upgrade Guide.

Keywords

dba permission; db_owner

Update History

04/19/2010 - Added vCenter Server 4.0 to 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

1 2 3 4 5
14 Ratings

1 2 3 4 5
14 Ratings

Actions

Bookmark Document

KB:

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)