Admin Tips
- Virtualization Tips & Tricks
  - Server Virtualization
    - VMware ESX Server Tips
      - Installation & Deployment
        Database issues when upgrading to VirtualCenter 2.5 U2

Section(s): General, Installation & Deployment
Published on Sep 24, 2008.
Last Modified on Aug 19, 2008.
Last Modified by Vincent Vlieghe.
Rated 5 out of 5 based on 1 votes.

This article describes an undocumented error during a SQL upgrade

Upgrading the VirtualCenter from 2.0.x to 2.5 can be a daunting task. Make sure you have a decent backup of your VC database as an upgrade failure can be hard to recover. We have noticed an undocumented problem while upgrading VirtualCenter database on a SQL Server 2005 SP2. We found the following error when browsing the VCDatabaseUpgrade.log file:

“Error: Failed to execute SQL procedure. Got exception: ERROR [42000] [Microsoft][SQL Native Client][SQL Server]The EXECUTE permission was denied on the object 'xp_sqlagent_is_starting', database 'mssqlsystemresource', schema 'sys'.”

Next to having the necessary dbo rights on your virtualcenter DB itself and the MSDB (the upgrade creates some maintenance jobs), you also need execute permissions on all XP_SQLAGENT_* extended stored procedures on the master database. This can be done by allowing all SQL agent related permissions to your virtualcenter user. These can be found under Master => programmability => Extended Stored Procedures => sys.Xp_SQLAgent_*

About Vincent Vlieghe

Vincent Vlieghe is a Technology Consultant for a company called Xylos. He has a number of certifications including MCSE, CCA, HP AIS, VCP and Softgrid CP. His main focus is on virtualization, Server Based Computing, Operating Systems and hardware/storage. In addition to his consultancy job, Vincent is also a trainer. You can find his blog at http://virtrix.blogspot.com/.