Error not resolved? SQL 2K8R2

Question

Error not resolved? SQL 2K8R2

SQL Galaxy

One Orange Chip

Points: 29472
More actions
December 12, 2013 at 4:24 am

#281193

Hi,
This Error not able resolve and every 2 min error apperaing in error log file.
Database: MSSQL SERVER 2008 R2 64 bit..with SP1.
Error: 18456, Severity: 14, State: 8.
Message
Login failed for user 'PA_ADMIN'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
I have verified as below everything working fine.
1. Checked SSMS connect that user- ok
2. Application get it connected that user and working -ok
3. There is no orphan user reported
4. no password changed recently
Thanks
ananda

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 1

And yet, it's failing. It has to be an issue with the password on the application. The error is terribly clear.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Lowell SSC Guru Points: 323504 More actions · Answer 2

since it's happening on the server itself(local machine), look at the running processes, and see if there's an additional application or scheduled task or something that is running/trying to connect every two minutes.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

SQLAssAS SSCertifiable Points: 7246 More actions · Answer 3

Do you have a report which is trying to use the credentials with the wrong password?

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 4

Grant Fritchey (12/12/2013)
And yet, it's failing. It has to be an issue with the password on the application. The error is terribly clear.

I want to know if an issue with password on the application, application never connected to the database..so application connected and working fine.. But still same error apperaing in error log..

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

ananda.murugesan (12/12/2013)
Grant Fritchey (12/12/2013)
And yet, it's failing. It has to be an issue with the password on the application. The error is terribly clear.
I want to know if an issue with password on the application, application never connected to the database..so application connected and working fine.. But still same error apperaing in error log..

try to type the password on a notepad, and check if the letters which are required being typed properly.

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 6

ananda.murugesan (12/12/2013)
Grant Fritchey (12/12/2013)
And yet, it's failing. It has to be an issue with the password on the application. The error is terribly clear.
I want to know if an issue with password on the application, application never connected to the database..so application connected and working fine.. But still same error apperaing in error log..

If the error is appearing in the log, then some application somewhere on your system is attempting to login with the wrong password. That's what it must be.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning