Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

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

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

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

  • 2 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)
  • 2 Ratings
Actions
KB: