During MECM 2002 Service Update Getting Prerequisites failed with DB Error

Question

SQL Account - HTMD Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - During MECM 2002 Service Update Getting Prerequisites failed with DB ErrorDear All,

I have recently installed MECM 2002 but during Service Update when I clicked on the hotfix I am getting a prerequisite failed, and when I diagnosed the log found some DB permission error.

And then I verified the Db permission and all seems perfectly fine.

Does anyone have any idea how to fix this.Log Error - HTMD Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - During MECM 2002 Service Update Getting Prerequisites failed with DB Error Su Window - HTMD Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - During MECM 2002 Service Update Getting Prerequisites failed with DB Errorlog3 1 - HTMD Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - During MECM 2002 Service Update Getting Prerequisites failed with DB ErrorLOG2 1 - HTMD Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - During MECM 2002 Service Update Getting Prerequisites failed with DB ErrorLOG1 1 - HTMD Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - During MECM 2002 Service Update Getting Prerequisites failed with DB Errorlog3 - HTMD Forum - Welcome to the world of Device Management! This is community build by Device Management Admins for Device Management Admins❤️ Ask your questions!! We are here to help you! - During MECM 2002 Service Update Getting Prerequisites failed with DB Error

 

 

 

Answers ( 13 )

    0
    2020-12-17T15:53:41+05:30

    It is very difficult to read from the screenshot you have pasted, can you share the screenshot on snipboard, also paste informatioon related to log file here, when you run the prereq checker at what point it shows the error in console?

    0
    2020-12-17T13:28:32+05:30

    Its a project task Anoop we cannot raise a ticket even today also I have verified all the prerequisites but don’t know it failed, any support or remote support is possible?

    0
    2020-12-17T08:30:35+05:30

    Anoop I have already verified the Failure mode from auto to manual its there but don’t know why every time it says NT Authority/System does not have sysadmin I have verified its not there now I have given in both the DB but still its giving the same error.

    0
    2020-12-17T04:42:52+05:30

    And the SQL is located on same subnet yes not the same sccm but in the same subnet with Always on available group cluster sql 2019.

    0
    2020-12-17T04:41:46+05:30

    Anoop the log which I am referring to is “ConfigMgrPrereq”

    0
    2020-12-16T13:14:46+05:30

    Yes, anoop the account I am using in SCCM has sysadmin permission for the DB.
    I have reverified.

    • Then this should something to with name resolution/Firewall?

      DO you have a remote SQL server?

      Can you please share the exact error from the log file?

      And which is that log file?

  1. You mentioned that it seems the permissions are fine.

    Can you share what is the permission that you have in DB?

    Do you have SysAdmin permissions?

Leave an answer

Sorry, you do not have permission to answer to this question .