Lot of Windows Logs within a minute for SQL Server Login and Windows Logon attempts

0

I have been facing issue in my Windows Server 2008 R2 that there are thousands of Audit failure logs and MSSQLSERVER logon failed attempts logs as follows.

1. Audit Failure Log Details :

An account failed to log on.

Subject: Security ID: NULL SID Account Name: - Account Domain: - Logon ID: 0x0

Logon Type: 3

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

Failure Information: Failure Reason: Unknown user name or bad password. Status: 0xc000006d Sub Status: 0xc000006a

Process Information: Caller Process ID: 0x0 Caller Process Name: -

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

Detailed Authentication Information: Logon Process: NtLmSsp Authentication Package: NTLM 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.

2. SQL Server Logon Attempt Log Details:

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 119.10.26.166]

Note: The Server has been hosted by Godaddy

Thanks.

sql-server
windows
asked on Stack Overflow Aug 29, 2018 by Tejas

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0