Login issue -Password did not match
-
Hi All,
Need help...and logs does not help
Error : ‘Login failed for user ‘sa’. Reason: Password did not match that for the login provided. [CLIENT: ]’
I see the issue is being going on for few months(2m) now when I checked the logs and trying to fix it ..please help. SQL server log or EventViewer does not help or provide more information Please let me know what is the best way to resolve or troubleshooting steps or where should I be looking?Thanks,
Al -
So it seems that login comes from the server itself. I would check the Agent jobs. Maybe there is a job that runs once a minute and runs SQLCMD or BCP, either directly through a CmdExec job or indirectly through xp_cmdshell.
You could also change back to the old password, set up a trace where you trace logins from 'sa' and include HostName and ApplicatioName in the trace
-
Thank you! 2 questions.
1. I just checked again and the login is different ( b****sa) will that change the way we should be looking into it?
2. Shall I ask them to provide or check the password itself..or change to old password. 🙂 -
Looks like a hard-coded password some where that was missed when the password was updated. You may want to look at extended events that you may be able to capture that will help provide the information you need.
-
This was removed by the editor as SPAM
-
When I use extended session and watch the live data I see - client_name_application file shows "SSMS". but why and what is actually causing the problem.
Logs only tell me ‘Login failed for user ‘**’. Reason: Password did not match that for the login provided. [CLIENT: ]’. I have updated the Job owner for all the jobs to ensure if that is causing the issue. The SSMS is set to login using sa now - but why I have no clue. Any suggestion will be helpful..SAMPLE error screenshot.
- sizal0234 - Monday, September 24, 2018 4:01 PMWhen I use extended session and watch the live data I see - client_name_application file shows "SSMS". but why and what is actually causing the problem.
Logs only tell me ‘Login failed for user ‘**’. Reason: Password did not match that for the login provided. [CLIENT: ]’. I have updated the Job owner for all the jobs to ensure if that is causing the issue. The SSMS is set to login using sa now - but why I have no clue. Any suggestion will be helpful..SAMPLE error screenshot.Sorry I didn't see this earlier, but if the error log is saying the password doesn't match what is stored for that user, the password entered was entered wrong. I have had that occur for myself at times. Either I accidentally hit the shift or caps lock key while typing, or I didn't strike the key(s) hard enough, or I hit two keys at a time. There is also the possibility that the password was changed and the user doesn't remember the new password.
Update the password for the user(s) involved with a known temporary password, give them that and have them log in. Make sure that they need to change the password while logging in. - allindiatransportservice605 - Wednesday, October 3, 2018 11:34 PM
As I just posted above.
-
No Problem and thank you all for your suggestions. I really appreciate it. This platform is good for learners like me. Please keep advising.
-
Look your SQL error logs then start up your cmd prompt window and Ping -aIPADDRESSGOESHERE. You will get a result saying "pinging machine name with 32 bytes of data", find out whose machine it is and you should be able to trace failed login attempts.
This may help you out:
https://www.sqlserverlogexplorer.com/fix-microsoft-sql-server-login-failed-error-18456/
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply