Re: Login failed for user NT AUTHORITY\NETWORK SERVICE

Well, it seems that some process working in Network Service user context is
trying to connect your instance and Network Service has no permission to
connect the target database in SQL Server. Run SQL Server Profiler and catch
failed login attempts (catch Audit Login Failed event with ApplicationName
and DatabaseName columns selected to trace).

--
Regards
Pawel Potasinski
[http://www.potasinski.pl]


U¿ytkownik "Matt" <Matt@xxxxxxxxxxxxxxxxxxxxxxxxx> napisa³ w wiadomo¶ci
news:AB02D9C1-DF84-4A43-BCA5-4A84B8323525@xxxxxxxxxxxxxxxx
Hi All,

I've done some searching around but can't find an answer to this problem.
I've recently noticed an error in the event logs relating to the Network
Service account trying to connect to my SQL 2005 server. The logs give me
the following information :-

12/06/2007 23:30:01,Logon,Unknown,Login failed for user 'NT
AUTHORITY\NETWORK SERVICE'. [CLIENT: 10.0.0.4]
12/06/2007 23:30:01,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State:
16.

This is all the info I have to go on. Can anyone provide me with some
assistance with trying to troubleshoot?


.

Relevant Pages

  • Re: NT Authority etworkservice failed to connect
    ... It should be Network Service by default. ... from the web config. ... your SQL Server on same server as IIS, If SQL Server is on seperate server ... SQL-server, but nothing happens.. ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint / Companyweb / MSDE Sharepoint Instance / KB829358
    ... Local Service and Network Service account: ... > running for both SQL Server and Distributed Transaction Coordinator. ...
    (microsoft.public.windows.server.sbs)
  • Re: network connection problems after Windows updates
    ... My MSDE instance is running Local service not network service? ... The account that is used by application pool does not have the required permissions to the SQL Server database. ... Network connectivity has been lost between the Windows SharePoint Services server and the Microsoft SQL Server server. ...
    (microsoft.public.windows.server.sbs)
  • Re: Network Service Account
    ... SQL Server process as Network Service, but rather as a Domain User ... you do follow using user or domain accounts as the ...
    (microsoft.public.sqlserver.security)
  • RE: Authentication of SharePoint Services 2003 with SQL Server 2000
    ... You need to give NETWORK SERVICE 'Database Creation' rights. ... The problem is to find NETWORK SERVICE to enable you to do this. ... What account should be used to access the SQL server in production ...
    (microsoft.public.sharepoint.windowsservices)