Support > Knowledge Base
Knowledge Base
Search the Knowledge Base: |
Search the Knowledge Base: |
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.
See Administrative Credentials are Required for Oracle and SQL Server Databases When Installing or Upgrading VirtualCenter (KB1003052) for the permissions needed to upgrade.
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
Feedback
Actions
- KB Article: 1003346
- Updated: Aug 14, 2009
- Products:
VMware VirtualCenter - Product Versions:
VMware VirtualCenter 2.5.x