none
Clustered SCCM Instance unable to bring online

    Question

  • Hi all,

    After the patch tuesday, all of my SQL clustered instances are working fine except for one, my SCCM instance. I have several event logs as below;

    Log Name: Application

    Event ID: 517

    sql serv (6040) database recovery failed with error -551 because it encountered references to a database, 'C:\Windows\systems32\LogFiles\Sum\SystemIdentity.mdb', which does not match with the current set of logs. The database engine will not permit recovery to complete for this instance until the mismatching database is re-instated. If the database is truly no longer available or no longer required, procedures for recovering from this error are available in the Microsoft Knowledge base or by following the "more information" link at the bottom of this message.

    and few others error event ID 465, 477, 454

    Any help will be appreciated!

    Thanks. 


    • Moved by Garth JonesMVP Thursday, March 23, 2017 1:37 PM Not a CM12 Issue, it a SQL issue.
    Thursday, March 23, 2017 10:02 AM

Answers

  • I got it resolved. It got to do with a setting that instance should not be set to 'hide' for cluster instance. It was set to 'hide' due to some security hardening.
    • Marked as answer by BensonL Monday, March 27, 2017 2:02 AM
    Monday, March 27, 2017 2:02 AM

All replies