Error 18054 and Error 777971002 in SQL log after moving System Center Operations Manager 2007 Database

Posted by on Jan 4, 2013 in SC Operations Manager, SQL Server | 3 comments

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.

3 Comments

  1. Hi Norman,

    This article relates my issue. Thanks for posting 🙂

    However, one question.

    Will there be data loss?? suppose if the DB is already functional n we happen to you the above method.

    Will it not reset the tables too?

  2. Even if I did not experience any problems or data loss I would always recommend taking a backup and being prepared for such events. What I think happens is that the wizard will only recreate any missing parts.

  3. Hi Norman,

    I am getting the same error in SCOM 2012 R2 server. As we don’t have DBCreateWizard support tool, what will be the option here?

    Regards,
    Raghul

Leave a Reply

Your email address will not be published. Required fields are marked *

Captcha: * Time limit is exhausted. Please reload CAPTCHA.