I just needed to move the System Center Operations Manager 2007 Database from one SQL server to another.

I followed Kevin Holman’s instructions step by step and ran into the same problem he was noticing after the move.

The error I got was:

Error 777971002, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.

So I followed the steps he took which did not solve my problem. I still got these errors in the log. But there is another way to fix this – here is my solution to the problem:

  1. Login to your SQL Machine
  2. Insert SCOM 2007 disc
  3. Navigate to D:\SupportTools\AMD64 (or whatever your cd drive and your platform is)
  4. Run DBCreateWizard.exe
  5. On the Database Information page choose your existing OperationsManager database and clear the “Create New Database” checkbox
  6. Fill in all other information according to your environment
  7. Finish the wizard

SCOM2007 - dbcreatewizard.exe

This will take a few minutes. After that the problem should be fixed.