Post reply

Error:18456

  • December 1, 2011 at 4:58 am

    #248758

    Hi All,

    Sql server 2008 r2

    Got below error when i have tried to login to server using sql login..

    Login failed for user 'mysrvlist'. (Microsoft SQL Server, Error: 18456)

    Error Number: 18456

    Severity: 14

    State: 1

  • December 1, 2011 at 5:51 am

    #1415189

    Wrong password?

    -- Gianluca Sartori

  • December 1, 2011 at 5:52 am

    #1415190

    Hi,

    Did you see error in sql server logs/error logs...

    You might get more info from there.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • December 1, 2011 at 5:54 am

    #1415194

    Also,

    maybe the server is configured only for Windows authentication. IF it is, Turning on Windows+SQL server authentication can solve the problem.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • December 1, 2011 at 6:01 am

    #1415199

    Hi..

    I am sure i have entered correct pwd and also my server using mixed mode..

  • December 1, 2011 at 6:14 am

    #1415213

    Did you check sql server logs/error logs and event log (Windows) to see if you can

    get more detail of the error.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • December 1, 2011 at 7:16 am

    #1415242

    Troubleshooting: Login Failed for User 'x'

    http://msdn.microsoft.com/en-us/library/ms366351.aspx

    FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: "Logon error: 18456"

    http://support.microsoft.com/kb/925744

  • December 1, 2011 at 7:27 am

    #1415252

    SKYBVI (12/1/2011)

    Did you check sql server logs/error logs and event log (Windows) to see if you can

    get more detail of the error.

    Regards,

    Sushant

    Hi sushant

    I have checked in sql server error log as well as windows event viewer its clearly says server is configured for windows authentication mode..

    Actually am using client machine where i have configured for windows and sql server authentication mode ..

    Thanks

  • December 1, 2011 at 7:30 am

    #1415253

    Actually am using client machine where i have configured for windows and sql server authentication mode ..

    We define authentication mode at Server Level. Client utility just passes the credentials.

  • December 1, 2011 at 7:31 am

    #1415254

    its clearly says server is configured for windows authentication mode..

    Try your windows logins to connect to server.

Viewing 10 posts - 1 through 9 (of 9 total)

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