• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 23960
  • Last Modified:

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

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
bcmeyer1983
Asked:
bcmeyer1983
  • 11
  • 8
1 Solution
 
Netman66Commented:
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
 
bcmeyer1983Author Commented:
The first thing i did was look for that service. It does not exist on the server.....?
0
 
Netman66Commented:
You have no MSSQL$ service at all on that server?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
bcmeyer1983Author Commented:
i have:
mssql$bkupexec
mssql$sbsmonitoring
mssql$sharepoint
0
 
bcmeyer1983Author Commented:
they all three are on local system account
0
 
Netman66Commented:
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
 
bcmeyer1983Author Commented:
partner of mine is telling me that this is related to sharepoint services. what can i do to check that?
0
 
bcmeyer1983Author Commented:
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
 
Netman66Commented:
It's the Sharepoint DB.

0
 
bcmeyer1983Author Commented:
what can i check to get the error to stop?
0
 
Netman66Commented:
What account does that service use to logon?
0
 
bcmeyer1983Author Commented:
now local, with errors still occuring...
0
 
Netman66Commented:
Ok, now try rebooting the server so everything comes up in sequence.

0
 
bcmeyer1983Author Commented:
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
 
bcmeyer1983Author Commented:
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
 
Netman66Commented:
Find this service: MSSQL$MICROSOFT##SSEE (or one corresponding to it)
Change the logon username to Local System.

0
 
bcmeyer1983Author Commented:
using the services.msc command i have changed: mssql$sharepoint to use local system
i will update you shortly


0
 
bcmeyer1983Author Commented:
no luck, same error...help
0
 
Netman66Commented:
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
 
PMajonCommented:
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

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 11
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now