Rodney Buike - Founder and original lazy admin. MVP: System Center Cloud and Datacenter Management

Daniel Nerenberg - Lazy admin 2.0. MVP: Windows Expert - IT Pro

Disclaimer

These postings are provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use.

SCVMM 2008 Console Error

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’"

Comments are closed.