ukerandi
asked on
SQl server warning Message
Hi Experts,
When i'm looking at everytime in the SQL server 2008R2 Logs file view i'm getting following Warning message every second.
Date 3/23/2021 11:02:22 PM
Log SQL Server (Current - 3/23/2021 9:04:00 PM)
Source Logon
Message
Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
Date 3/23/2021 11:05:23 PM
Log SQL Server (Current - 3/23/2021 11:02:00 PM)
Source Logon
Message
Error: 18456, Severity: 14, State: 8.
How to monitor which application or any advice much appreciated
According to the Google find says :
But i can login using sa password with management studio
When i'm looking at everytime in the SQL server 2008R2 Logs file view i'm getting following Warning message every second.
Date 3/23/2021 11:02:22 PM
Log SQL Server (Current - 3/23/2021 9:04:00 PM)
Source Logon
Message
Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
Date 3/23/2021 11:05:23 PM
Log SQL Server (Current - 3/23/2021 11:02:00 PM)
Source Logon
Message
Error: 18456, Severity: 14, State: 8.
How to monitor which application or any advice much appreciated
According to the Google find says :
- Error: 18456, Severity: 14, State: 8
But i can login using sa password with management studio
ASKER
@Raja Thank you very much for reply
I have checked all the jobs and schedule all are successfully completed.
How to find "Some application running on that Server " any idea how to find?
I have checked all the jobs and schedule all are successfully completed.
How to find "Some application running on that Server " any idea how to find?
ASKER
@Raja
Also I have run SQL profiler (audit )
it's mentioned Login failed in master table and Event Sub Class - "1 -Nonpooled" and Type is "1 - Non-DAC"
Also I have run SQL profiler (audit )
it's mentioned Login failed in master table and Event Sub Class - "1 -Nonpooled" and Type is "1 - Non-DAC"
Kindly check the applications running in Services.msc and any other Windows applications running from Task Manager.
One of them might be causing the error.
One of them might be causing the error.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
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.
As the error message clearly indicates that the client is Local machine, kindly check for all Jobs or applications running from that machine and update with the latest password to get it work.
It can be any one of the below
1. Task Scheduler Job
2. Some application running on that Server
3. Scheduled job running on Server