Upgrading VMware vCenter Microsoft SQL Server 2008 R2 Express


I know, it is highly NOT recommended to run vCenter on a Microsoft SQL Server Express edition, even in test or development environments! So it is not difficult to understand that in my homelab vCenter ran on a Microsoft SQL Server 2008 R2 Express Edition

And everything went well, until I noticed this message (probably after upgrading to vCenter 4.1)

I also discovered that vCenter had no performance Data older then one day. Searching VMware’s knowledge base, I found KB1004382. The KB states that: “This article does not apply to installations using Microsoft SQL Server 2005 Express. SQL Server Agent is not available in Microsoft SQL Server 2005 Express. Historic data is managed by the VirtualCenter Server service in this case.

Read the rest of this entry »