locked
why show message when Login sql server 2005 Login failed for user 'ssc-PC\Administrator'. (Microsoft SQL Server, Error: 18456) RRS feed

  • Question

  • why show message when Login sql server 2005 :

    Login failed for user 'ssc-PC\Administrator'. (Microsoft SQL Server, Error: 18456)

    help solution the problem >>>>

    Wednesday, April 11, 2012 3:10 PM

Answers

All replies

  • does that user have a valid login in SQL Server?  What's the rest of the error code? -  this will tell us the cause of the login failure


    Thanks,

    Andrew Bainbridge
    SQL Server DBA

    Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

    Wednesday, April 11, 2012 3:12 PM
  • Hi srajmuneer,

    Error 18456 is a known error, it could be caused by an application unable to access SQL Server, credentials changing over time, or a user who can't type a password correctly. Please troubleshoot this problem follow this blog:

    http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx


    Best Regards,
    Iric
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Iric Wen Monday, April 23, 2012 9:11 AM
    Friday, April 13, 2012 7:23 AM