none
Login failed for user 'DOMAIN\MACHINENAME$'. Reason: Could not find a login matching the name provided. RRS feed

  • Question

  • I am following this 2016 article to setup my DPM 2019 protection with SharePoint 2019. After I setup the first protection group (it only contain one SharePoint Web Front End server) and start the first consistency check. It failed immediately.

    Please note that our DPM server and SharePoint sever are installed under 2 domains. But 2 domains have established two-way trust.

    After some troubleshooting in SQL server log here is the error message.

    Login failed for user 'DOMAIN\MACHINENAME$'. Reason: Could not find a login matching the name provided. 


    By following the instruction "Remember that for DPM runs as Local System and to backup SQL Server databases it needs sysadmin privileges on that account for the SQL server. On the SQL Server you want to back up set NT AUTHORITY\SYSTEM to sysadmin." , we have add "NT AUTHORITY\SYSTEM" to SQL server's sysadmin group.

    According to some SQL forum, I also need to grant "DOMAIN\MACHINE$" sysadmin permission. Is it true?

    Please advise. Thanks.


    • Edited by Mark Lui Monday, October 19, 2020 7:29 AM
    Monday, October 19, 2020 7:26 AM

All replies