Event ID: 18456 Source: MSSQL

Event ID/Source search

Keyword search

Example: Windows cannot unload your registry file

Event ID: 18456 Source: MSSQL

Source: MSSQL

Description:
Login failed for user "NT AUTHORITY\NETWORK SERVICE". [CLIENT: <named pipe>]

English: Request a translation of the event description in plain English.

Comments:
Anonymous
You can resolve this issue (identify what's causing it) from the log file. Go to your SQL Server C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_175.trc

When you open the log_175.trc it will open SQL Server Profiler. Once opened look under the Event Class column for "Audit Login Failed". NT UserName should be Network Service. Then look under the Application Name column. This name in this column is the source of the Audit Login Failed for Error: 18456 Severity 14 State 16. This is the source identified as the issue.
Click if the comment is good!

^{x
24}

Grant Wise
Mysteriously appeared along with event 17204 (access denied). The WSUS service database would not start because the Network Service account did not have file permission to the WSUS directory. This in turn kept WSUS from running. I did not change any file persmissions and WSUS had successfully been deployed and running for 4 months prior to this error.

Fix: add Network Service account with full access rights to the WSUS directory and restart the Windows Internal Database service.
Click if the comment is good!

^{x
13}

Private comment: Subscribers only. See example of private comment

Search: Google - Bing - Microsoft - Yahoo - EventID.Net Queue - More links...

Feedback: Send comments or solutions - Notify me when updated

Printer friendly