VMware
 

Knowledge Base

Search the Knowledge Base:
Products:
Search In:
 

Administrative Credentials Are Required for Oracle and SQL Server Databases When Installing or Upgrading VirtualCenter

Details

When you prepare an Oracle or Microsoft SQL Server database to work with VirtualCenter Server, you need to grant special permissions to the user account that VirtualCenter uses to access the database.

Solution

Oracle Database

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

grant connect to <user>
grant resource to <user>
grant create view to <user>
grant create any sequence to <user> # For VirtualCenter upgrade only
grant create any table to <user> # For VirtualCenter 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 VirtualCenter database login will need the db_owner role for the VirtualCenter and MSDB databases.

The MSDB db_owner role is used during the VirtualCenter 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 VirtualCenter database login account when upgrading from a previous release of VirtualCenter. Changing the sysadmin role on your VirtualCenter 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 VirtualCenter database. Press the Back button and review your database permissions in SQL Manager. Once satisfied, press Next again to continue with the upgrade.

Keywords

dba permission; db_owner

Feedback

Rating: 1 - Lowest 2 3 4 5 - Highest (8 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? (2000 or fewer characters)
Submit
Rating: 1 - Lowest 2 3 4 5 - Highest (8 Ratings)   
Actions
  • KB Article: 1003052
  • Updated: Aug 14, 2009
  • Products:
    VMware VirtualCenter
  • Product Versions:
    VMware VirtualCenter 2.5.x