Avatar of JamesonJendreas
 asked on

SQL Server - Audit failures

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
An account failed to log on.

      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.
Windows Server 2008Microsoft SQL Server 2008

Avatar of undefined
Last Comment

8/22/2022 - Mon

Are these from different workstation names or the same events with the same event details every time?  Without knowing much about your environment. Two possibilities come to mind, it could be a brute force attempt if you have the connection ports open to the public and someone is trying to guess the password to it, or you have a workstation that is configured to connect to it but doesn't have the correct credentials, every time it tries to restart the connection it will cause a failure.  

if that doesn't help maybe attach a larger portion of the log files, you can use word to find and replace the ip addresses if they are external.

All the exact same - and seem to be coming from the database server itself - the username is that of the DB server and these errors show on the DB servers event viewer.  Looks like it actually happens every 30 minutes or so.  There is NO source IP, and  if there was I'd expect to see it as the local IP, as this is a local (to the server) logon failure (or so it looks)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck