There’s a load of waffle about having to reinstall VMM once you move the VMM DB to a new server.
Quite simply these are the steps you need to take:
Take a http://kbsurf.com/mybeafter.php full backup of VMM DB “VirtualManagerDB” from old SQL Server.
Restore the VMM DB “VirtualManagerDB” to new SQL Server.
Assign security permissions to VMM Server and VMM Service accounts on destination SQL Server, DB and verify firewall is not blocking SQL connections. Just look at the User Mapping on the old server and ensure it matches the restored DB on the new SQL Server/Cluster
Open Registry Editor (regedit.exe) and navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft System Center Virtual Machine Manager Server\Settings\SQL
Change the following registry keys to point to your new SQL Server/Cluster:
Now start “ System Center Virtual Machine Manager” & “System Center Virtual Machine Manager Agent” services.
Now open the VMM Console and navigate to Settings > General > Database Connection. You will see the new settings were successful.