Login failed with INFRASTRUCTURE error.

Question

Login failed with INFRASTRUCTURE error.

Siva Ramasamy

SSCarpal Tunnel

Points: 4026
More actions
June 12, 2012 at 1:28 pm

#271110

Hi,
Thanks for looking into my question.
I am getting this error in the SQL Server logs.
06/12/2012 10:00:37,Logon,Unknown,Login failed for user 'sa'. Reason: Password validation failed with an infrastructure error. Check for previous errors.
06/12/2012 10:00:37,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 10.
When I google it, It says about "Service Principal Names".
Have any of you face this kind of error before..? Please help.
Thanks!
Siva.

Viewing 4 posts - 1 through 3 (of 3 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Siva Ramasamy (6/12/2012)
Hi,
Thanks for looking into my question.
I am getting this error in the SQL Server logs.
06/12/2012 10:00:37,Logon,Unknown,Login failed for user 'sa'. Reason: Password validation failed with an infrastructure error. Check for previous errors.
06/12/2012 10:00:37,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 10.
When I google it, It says about "Service Principal Names".
Have any of you face this kind of error before..? Please help.
Thanks!
Siva.

The error message says to look for previous errors, are there any in the error logs prior to this error?

Siva Ramasamy SSCarpal Tunnel Points: 4026 More actions · Answer 2

Hi,

Thanks for your reply.

There was no other error message in the log file.

Thanks!

Siva.

Lowell SSC Guru Points: 323518 More actions · Answer 3

the first link i got whens earching for the error took me here:

http://social.msdn.microsoft.com/Forums/eu/sqldatabaseengine/thread/214b0b8f-ab78-4ab1-bd73-3eeee0c8999a

it seems to imply there is something wrong with "corruption of Server Principal Name(SPN)."

can you look at that and see if it applies?

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!