troubleshooting Question

SQL Server - Audit failures

Avatar of JamesonJendreas
JamesonJendreas asked on
Microsoft SQL Server 2008Windows Server 2008
3 Comments1 Solution3445 ViewsLast Modified:
hello,
I've been monitoring the security log on my Server 2008\SQL Enterprise 2008 server.  I tend to get eh following error every few minutes or so - NOTE: Servername$ is the local DB server name plus a $

Log Name:      Security
Source:        Microsoft-Windows-Security-Auditing
Date:          8/8/2011 12:15:01 PM
Event ID:      4625
Task Category: Logon
Level:         Information
Keywords:      Audit Failure
User:          N/A
Computer:      servername.foxshox.com
Description:
An account failed to log on.

Subject:
      Security ID:            SYSTEM
      Account Name:            SERVERNAME$
      Account Domain:            DOMAIN
      Logon ID:            0x3e7

Logon Type:                  3

Account For Which Logon Failed:
      Security ID:            NULL SID
      Account Name:            
      Account Domain:            

Failure Information:
      Failure Reason:            An Error occured during Logon.
      Status:                  0xc000018b
      Sub Status:            0x0

Process Information:
      Caller Process ID:      0x8b0
      Caller Process Name:      C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\sqlservr.exe

Network Information:
      Workstation Name:      BLUEWHALE
      Source Network Address:      -
      Source Port:            -

Detailed Authentication Information:
      Logon Process:            Authz  
      Authentication Package:      Kerberos
      Transited Services:      -
      Package Name (NTLM only):      -
      Key Length:            0

This event is generated when a logon request fails. It is generated on the computer where access was attempted.

The Subject fields indicate the account on the local system which requested the logon. This is most commonly a service such as the Server service, or a local process such as Winlogon.exe or Services.exe.

The Logon Type field indicates the kind of logon that was requested. The most common types are 2 (interactive) and 3 (network).

The Process Information fields indicate which account and process on the system requested the logon.

The Network Information fields indicate where a remote logon request originated. Workstation name is not always available and may be left blank in some cases.

The authentication information fields provide detailed information about this specific logon request.
      - Transited services indicate which intermediate services have participated in this logon request.
      - Package name indicates which sub-protocol was used among the NTLM protocols.
      - Key length indicates the length of the generated session key. This will be 0 if no session key was requested.
ASKER CERTIFIED SOLUTION
DigitalTechy

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros