You must Sign In to post a response.
  • Category: MS SQL Server

    Troubleshooting - 'Sev. 14 Errors' - Login failed for user 'NT AUTHORITY\SYSTEM'




    Sometimes your SQL Error log might fill up with the error "Sev. 14 Errors – Login failed for user 'NT AUTHORITY\SYSTEM'. [CLIENT : Local System ]"
    This happens when user 'NT AUTHORITY\SYSTEM' local group does not have access to SQL Server and some service is trying to access SQL Server using this account.

    To Trace out which services is causing this issue, first you will have to run the profiler. We do not require all the events, so we can apply the filter for profiler to capture only "Audit Login Failed" event class.

    Continue to Read here for more information.
    http://sanssql.blogspot.com/2010/06/sev-14-errors-login-failed-for-user-nt.html

    Regards,
    Sandesh Segu
    http://www.SansSQL.com
    http://SansSQL.blogspot.com
  • #2926
    Hi,

    When you access the SQL Server in the installed machine then Windows authentication will work. If you access the same SQL Server from a remote machine through SQL Client then if you try use the Windows authentication then it will show the error.

    Please post this information in Resources section

    D.Jeya Kumar(JK)
    MVP
    http://tamilpadamcomedy.blogspot.com


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.