Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 23900
  • 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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 Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

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