How to troubleshoot "Login failed for user 'NT AUTHORITY\SYSTEM'" for SMS_MP_FILE_DISPATCH_MANAGER?

CharlieLor 551 Reputation points
2021-02-05T15:20:48.813+00:00

I keep getting the following login failed for the Application Name: SMS_MP_FILE_DISPATCH_MANAGER

Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'dbName'. [CLIENT: <local machine>]

First, where does the mpfdm.log located on the SQL Server reporting server services? Second, what else could have caused this login error?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,705 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
Microsoft Configuration Manager
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Youssef Saad 3,401 Reputation points
    2021-02-05T19:07:51.26+00:00

    Hi @CharlieLor ,

    You can locate the mpfdm.log on the site server under "ConfigMgr Install Path\Microsoft Configuration Manager\Logs", you can start the troubleshoot from this log.

    Maybe you will need to check also SQL Server logs for more details.

    Regards,

    Youssef Saad | New blog: https://youssef-saad.blogspot.com
    Please remember to ** “Accept answer” ** or upvote for useful answers, thank you!

    0 comments
  2. CharlieLor 551 Reputation points
    2021-02-05T19:09:46.923+00:00

    I found the mpfdm.log file but nothing in this file shows any error or login failure. So I'm not sure what else to look for in this file.

  3. AllenLiu-MSFT 40,316 Reputation points Microsoft Vendor
    2021-02-10T08:27:57.02+00:00

    @CharlieLor
    Thank you for posting in Microsoft Q&A forum.
    Seems this is a duplicate post to:
    https://learn.microsoft.com/en-us/answers/questions/265603/does-anyone-know-what-application-name-sms-mp-file.html
    This is the Database role_membership of NT AUTHORITY\SYSTEM in my CM database:
    66258-26.jpg

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  4. CharlieLor 551 Reputation points
    2021-02-10T12:25:52.637+00:00

    I'm sorry for double posting. I'm not sure exactly how the Microsoft Q&A forums work. I posted in the other location under the SCCM forum hoping that group would give me information from the SCCM side of things. I posted in this SQL Server group in case there's something in the SQL Server permissions/settings that I've missed; thus two posts. I just recently learned from the other post that I could just tag this group or vice versa instead of posting in two groups...definitely will do that next time.

    Thank you for your response. I will double check my NT AUTHORITY\SYSTEM Database role_membership and see if it still shows the same error tomorrow. This error show up in every day around 2AM.

  5. CharlieLor 551 Reputation points
    2021-02-11T12:51:23.733+00:00

    Here's something I'm still confused. I'm still receiving this error on the default SQL Server instance and not on the SCCM instance. Could it be that the SMS_MP_FILE_DISPATCH_MANAGER component is pointing to the wrong instance? However, there is no error on the SCCM monitor.

    0 comments