ERROR 18456
EVENTID: 18456 —- Login failed for user ‘sa’. Reason: Password did not match that for the login provided.
This message is being sent hundreds of times daily to my server tracing back to my computer’s IP address. I’m not sure why it’s trying to log in under “sa” because I’m using windows auth to gain access to the server under a different user. Everything seems to work fine with the exception of very recently my account seems to be creating deadlock sometimes even when not actively running any queries.
Any help would be great.
EVENTID: 18456 —- Login failed for user ‘sa’. Reason: Password did not match that for the login provided. This message is being sent hundreds of times daily to my server tracing back to my computer’s IP address. I’m not sure why it’s trying to log in under “sa” because I’m using windows auth to gain access to the server under a different user. Everything seems to work fine with the exception of very recently my account seems to be creating deadlock sometimes even when not actively running any queries. Any help would be great. Read More