Solved

Event Log - Type: Failure Aud - Event ID: 18456 - Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <named pipe>]

Posted on 2007-12-04
20
23,684 Views
Last Modified: 2012-06-27
Event Type:      Failure Audit
Event Source:      MSSQL$MICROSOFT##SSEE
Event Category:      (4)
Event ID:      18456
Date:            12/3/2007
Time:            11:45:00 PM
User:            NT AUTHORITY\NETWORK SERVICE
Computer:      SIMON
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <named pipe>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00   .H......
0008: 16 00 00 00 53 00 49 00   ....S.I.
0010: 4d 00 4f 00 4e 00 5c 00   M.O.N.\.
0018: 4d 00 49 00 43 00 52 00   M.I.C.R.
0020: 4f 00 53 00 4f 00 46 00   O.S.O.F.
0028: 54 00 23 00 23 00 53 00   T.#.#.S.
0030: 53 00 45 00 45 00 00 00   S.E.E...
0038: 07 00 00 00 6d 00 61 00   ....m.a.
0040: 73 00 74 00 65 00 72 00   s.t.e.r.
0048: 00 00                     ..      
0
Comment
Question by:bcmeyer1983
  • 11
  • 8
20 Comments
 
LVL 51

Expert Comment

by:Netman66
Comment Utility
Change the logon account for this service MSSQL$MICROSOFT##SSEE to the local SYSTEM account.

After restarting the service with the new account, try changing it back to Network Service with no password and see if it sticks.

If not, continue using the SYSTEM account.

0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
The first thing i did was look for that service. It does not exist on the server.....?
0
 
LVL 51

Expert Comment

by:Netman66
Comment Utility
You have no MSSQL$ service at all on that server?
0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
i have:
mssql$bkupexec
mssql$sbsmonitoring
mssql$sharepoint
0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
they all three are on local system account
0
 
LVL 51

Expert Comment

by:Netman66
Comment Utility
Interesting...the error would suggest one of the SQL accounts is using Network Service as a logon point but is failing.

If you open SQL Manager, is the Network Service account set on any of the DBs?
0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
partner of mine is telling me that this is related to sharepoint services. what can i do to check that?
0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
ok so i have it narrowed down to the following service:
Windows Internal Database (MICROSOFT##SSEE)
here is the path: C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Binn\sqlservr.exe -sMICROSOFT##SSEE

what is this?
0
 
LVL 51

Expert Comment

by:Netman66
Comment Utility
It's the Sharepoint DB.

0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
what can i check to get the error to stop?
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 51

Expert Comment

by:Netman66
Comment Utility
What account does that service use to logon?
0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
now local, with errors still occuring...
0
 
LVL 51

Expert Comment

by:Netman66
Comment Utility
Ok, now try rebooting the server so everything comes up in sequence.

0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
sorry for the delay and putting this on the back burner. but i still have this flooding my event log every couple of minutes. I have rebooted the server and changed the logon type to local, and also tried specifying the admin account with no luck....
0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
Event Type:      Failure Audit
Event Source:      MSSQL$MICROSOFT##SSEE
Event Category:      (4)
Event ID:      18456
Date:            3/14/2008
Time:            9:39:59 AM
User:            NT AUTHORITY\NETWORK SERVICE
Computer:      SIMON
Description:
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [CLIENT: <named pipe>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 00004818 0000000e 00000016 00490053
0010: 004f004d 005c004e 0049004d 00520043
0020: 0053004f 0046004f 00230054 00530023
0030: 00450053 00000045 00000007 0061006d
0040: 00740073 00720065 0000
0
 
LVL 51

Expert Comment

by:Netman66
Comment Utility
Find this service: MSSQL$MICROSOFT##SSEE (or one corresponding to it)
Change the logon username to Local System.

0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
using the services.msc command i have changed: mssql$sharepoint to use local system
i will update you shortly


0
 
LVL 2

Author Comment

by:bcmeyer1983
Comment Utility
no luck, same error...help
0
 
LVL 51

Accepted Solution

by:
Netman66 earned 500 total points
Comment Utility
Interesting.  The error you posted showed the Network account had no permission, the SYSTEM should have.

This isn't "exactly" the error you are seeing - but I believe it should help you solve the issue.

http://support.microsoft.com/default.aspx?scid=kb;en-us;947378

I think it's related to Read permissions on the DB for Sharepoint.  

0
 

Expert Comment

by:PMajon
Comment Utility
This solved the issue for me as well. My WSUS install corrupted after a migration from a VMware server to a Virtual Iron VM.

Find this service: MSSQL$MICROSOFT##SSEE (or one corresponding to it)
Change the logon username to Local System.

I then proceeded to uninstall WSUS 3 w/SP1 and reinstalled it.

My MSSQL$MICROSOFT##SSEE service is still using the local system account. What is the harm in leaving it this way? What is the procedure to revert it to the previous account permissions?
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

I have never ceased to be amazed how many problems you can encounter on a fresh install of a Windows operating system.  This is certainly case in point& Unable to complete ANY MSI installation.  This means Windows Updates are failing and I can't …
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This video discusses moving either the default database or any database to a new volume.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now