Recently we had an issue with our production SCVMM 2008 R2 SP1 server. One day, out of the blue, when you tried to launch the console and connect you would get the following error:
This is actually a SQL error. To remediate you need to add sa to the dbo role for the VMM database called VirtualManagerDB. If you followed the default install process SCVMM R2 installs SQL 2005 and has no management tools installed. You can download and install the SQL Server Management Studio and add the sa account to the dbo role or you can do it with an osql command. My co-worker Andrew did it via OSQL using the following command…
osql -E -S SCVMMR2\MICROSOFT$VMM$ -Q "USE VirtualManagerDB; EXEC sp_changedbowner ‘sa’"
