Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

8 Responses to “Help : How to find cause of “Login failed for user” error”

  1. I am getting an error with login failed for user ” .There is no user name displays here.Happening with Windows authentication

  2. Sir, Got a series of State 10 error this afternoon. Changing the Check_policy to off for the SQL account seems fix the issue, Any feedback on State 10?

    • blakhani said

      Error: 18456, Severity: 14, State: 10.
      Login failed for user ‘SQL_Login’. Reason: Password validation failed with an infrastructure error. Check for previous errors. [CLIENT: XXX.XXX.XXX.XXX].

      Means it’s failing while validating password policy.

  3. Jim Ziegmann said

    How does one determine root cause and fix for this error in state of 8? This is happening once every minute.

    Error: 18456, Severity: 14, State: 8.
    Login failed for user ‘sa’. Reason: Password did not match that for the login provided. [CLIENT: ]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: