Knowledge Base

Search the Knowledge Base:
Products:
Search In:
 

Do not grant or revoke the System Administrator's role to satisfy database permission requirements when upgrading to VirtualCenter 2.5

Details

Depending on the history of your VirtualCenter database and the Microsoft SQL Server (2000 or 2005) it resides on, you may have the sysadmin role assigned to your VirtualCenter login.  
 
If your VirtualCenter login already has the sysadmin role assigned, removing the role may prevent your VirtualCenter service from starting.
 
If your VirtualCenter login does not have the sysadmin role assigned, adding the role may make your data unavailable and the installer may perform a new install.

Caution: Do not attempt to change the assignment before, during, or after your VirtualCenter upgrade.

Solution

During the upgrade, if you receive the warning:
 
The DB user entered does not have the required permissions needed to install and configure VMware VirtualCenter Server with the selected DB.
 

If you have already upgraded to VirtualCenter 2.5 and your existing data is unavailable, see Host and other configuration data missing after upgrading VirtualCenter 2.5 (KB1003610) for steps to restore your data.

Keywords

VirtualCenter; VC; upgrade; database; privileges

Feedback

Rating: 1 - Lowest 2 3 4 5 - Highest (0 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 (0 Ratings)   
Actions
  • KB Article: 1003346
  • Updated: Aug 14, 2009
  • Products:
    VMware VirtualCenter
  • Product Versions:
    VMware VirtualCenter 2.5.x