Error:18456

  • 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

  • Wrong password?

    -- Gianluca Sartori

  • 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

  • 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

  • Hi..

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

  • 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

  • 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

  • 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

  • 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.

  • 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