Post reply

SQL Server 2005: Login error 18456 State: 1

  • August 6, 2009 at 7:55 am

    #209095

    Hi

    I have performed a re-install of my SQL Server 2005 on a Vista desktop.

    During the setup I have selected "Windows Authentication Mode".

    When I wanted to connect to the database, I was getting an error 18452 which was related to a trusted SQL Server connection.

    I have edited the registry and changed the login mode to "2" for mixed.

    Now I get a login error 18456 whenever I use Windows Authentication or SQL Server Authentication.

    This is true for my own windows login and the sa user.

    Please help ...

    Cheers

    Ludo

  • August 6, 2009 at 1:03 pm

    #1035623

    Check the MSDN blog entry "Understanding "login failed" (Error 18456) error messages in SQL Server 2005"

    http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

    You'll need to look in the SQL Server error logs for the full detail of the error message, because "Msg 18456, Level 14, State 1" is always passed to the client, regardless of the reason for rejecting the login. The State value in the error log is the key to tracking down the problem.

    Eddie Wuerch
    MCM: SQL

  • August 7, 2009 at 2:30 am

    #1035832

    Thanks for the info.

    I finaly managed to get my user logged in by adding my user to the SQL Server groups in the Windows User Management.

    Cheers

    Ludo

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

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