3

In one of my vb.net applications I am getting the error Login failed for user 'user'. But the user has full permission (sysadmin). Also this error happens intermittently.

Error log has the following:

Login failed for user 'user'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.1.69]
Error: 18456, Severity: 14, State: 38.
Login failed for user 'user'. Reason: Password validation failed with an infrastructure error. Check for previous errors. [CLIENT: 192.168.1.61]
Error: 18456, Severity: 14, State: 10.
Login failed for user 'user'. Reason: Password validation failed with an infrastructure error. Check for previous errors. [CLIENT: 192.168.1.88]
Error: 18456, Severity: 14, State: 10.

I saw this article.

But in my case all database are set to autoclose OFF.

Also the user exist and has sysadmin permission.

Also KB #925744 is for SQL Server 2005 as mentioned in the article. But I am using SQL Server 2008 R2.

update:

I just saw this article. In that there was query to find ring buffer.In my case i got 0x139F as error code.when i run NET HELPMSG 5023 i got following.

The group or resource is not in the correct state to perform the requested operation.

What does this mean? Whether it will be reason for the error?

Improve this question
1
  • The error log excerpt has a number of different errors at different times from different clients. Are all of these part of the problem you're investigating?
    – James Lupolt
    Jun 28, 2013 at 14:09

1 Answer 1

Reset to default
2

The state 38 error is probably a red herring: focus on the state 10 errors.

While KB Article #925744 says it is for SQL Server 2005, that is simply because of the date it was written. The symptom it causes would affect all versions of SQL Server that have been released since then in similar or identical ways.

Now, if user is a Windows login, perhaps you are somehow trying to authenticate as a Windows login without specifying the domain, or perhaps you are specifying the domain but the domain controller is unreliable or on an unreliable network connection. You should post your actual connection string in the question (fudging our real names/passwords of course).

You should also consider creating a new, separate login with the same permissions, and see if you intermittently get the same error with that other user as well - my guess this is an architectural problem in some way as opposed to a problem with just this user.

Another possibility is if your .net application is using Windows auth and the underlying password has been changed. Seems like a long shot, but check out the article and there is a hotfix available: KB Article #2545850.

Improve this answer
7
  • The user is having sql authentication. Also the error didn't repeat every time for that line of code. The error didn't happen during sql connection,it is during accessing data using recordset open command
    – IT researcher
    Jun 29, 2013 at 5:15
  • I have also updated the question.Please check
    – IT researcher
    Jun 29, 2013 at 6:03
  • The error solved after un-checking password policy check box.
    – IT researcher
    Jul 16, 2013 at 10:43
  • @ITresearcher so was the user somehow created with a not-complex-enough password?
    – Aaron Bertrand
    Jul 16, 2013 at 11:15
  • May be.But sql server allows to create login with password policy checked having simple password.For example if i give password as 'abc' and check the password policy no warning comes while creating user. Also i can't understand the the error 5023 and the error which actually happend in my case.Anyway now the error is solved.
    – IT researcher
    Jul 16, 2013 at 13:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.