Error Log error log

Published on May 7th, 2015 | by Alejandro Cordero

0

Error: 18456, Severity: 14, State: 11

Error Message:

Error: 18470, Severity: 14, State: 1.
Login failed for user ‘<x>’.
Reason: The account is disabled.

Error: 18456, Severity: 14, State: 2.
Login failed for user ‘<x>’.
Reason: Could not find a login matching the name provided.

Error: 18456, Severity: 14, State: 5.
Login failed for user ‘<x>’.
Reason: Could not find a login matching the name provided.

Error: 18456, Severity: 14, State: 6.
Login failed for user ‘<x\y>’.
Reason: Attempting to use an NT account name with SQL Server Authentication.

Error: 18456, Severity: 14, State: 7.
Login failed for user ‘<x>’.
Reason: An error occurred while evaluating the password.

Error: 18456, Severity: 14, State: 8.
Login failed for user ‘<x>’.
Reason: Password did not match that for the login provided.

Cause:

There is a problem of authentication for a given user. The login or password is not the correct one, the specified default database does not exist or SQL Server is not able to authenticate against the active directory.

Solution:

There could be a typo in your login name or password, the user could be disabled, windows UAC could be blocking your access, or there could be a communication issue against the AD. Some people mistake a SQL login with a Windows login, when connecting to the database if you pick SQL Server authentication, then make sure the user and password correspond to an actual SQL Server login, if you pick windows authentication make sure the user you are specifying is an actual Windows user (this option can include a domain name in the form of “domain\user” and won’t normally ask for a password, e.g when connecting with SSMS)

 

These are quick references by SQLTurbo, intended for quick review of commands
and quick solutions to common sql errors. This section does not elaborate
on topics deeply. However feel free to comment and we will try to make
suggestions as needed.

 


About the Author

SQL Server DBA with over 8 years of experience, developer for .Net , Certified Scrum Master and Entrepreneur.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Back to Top ↑
  • Sign Up For Our Newsletter

    Stay up to date on the latest from SQL Server products and Features.

    Sign Up Now

    Sign up for mailing list and receive new posts directly to your inbox.

    We promise never to share or sell any of your personal information.

  • Recent Posts

  • Categories

  • Archives

  • Tags

  • Topics

  • Subscribe to our RSS Feed


    sqlturbo.com A SQL Server Web Blog
    Canada, Ontario, Ottawa.
    http://sqlturbo.com

    The Authors