question

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 asked saldana-msft edited

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

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-generalmem-cm-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YoussefSaad avatar image
0 Votes"
YoussefSaad answered

Hi @CharlieLor-4693,

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!



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered YoussefSaad edited

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Is the "NT AUTHORITY\SYSTEM" account has necessary permissions in the CMDB?

Regards,


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

0 Votes 0 ·
AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered

@CharlieLor-4693
Thank you for posting in Microsoft Q&A forum.
Seems this is a duplicate post to:
https://docs.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.



26.jpg (76.1 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered ErlandSommarskog commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

But wasn't the problem that the process was producing this error on an instance which does not have the database in question, but the database exists on a second instance?

Or am I confusing you with someone else? (I peek into 10-15 threads a day, so I may mix them up.)

0 Votes 0 ·
CharlieLor-4693 avatar image
0 Votes"
CharlieLor-4693 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.