Post reply

severity 14 state 11

  • September 6, 2012 at 2:42 pm

    #393123

    Hello All,

    I periodically receive complaints in which a previously working login fails generating the following error in the SQL Logs:

    Error: 18456, Severity: 14, State: 11

    Login failed for user "<USER>"

    The default database for the login is master and the login has access to the user database in question. I've found I can solve this issue by changing the default database to a user database in which the login has access, save and then change it back.

    Can anyone explain this behavior? I would Google the issue but I don't even know what to look for! This is happening on SQL Server 2005 SP3.

    Thanks in advance,

    Jerry

  • September 6, 2012 at 2:47 pm

    #1534756

    Here is a good place to start: http://msdn.microsoft.com/en-us/library/ms366351(v=sql.90).aspx

  • September 6, 2012 at 2:51 pm

    #1534759

    Lynn Pettis (9/6/2012)

    Here is a good place to start: http://msdn.microsoft.com/en-us/library/ms366351(v=sql.90).aspx

    Thanks Lynn. I have indeed found resources like this but much like this one they are too general to really identify a root cause.

    In my other perusing I've seen hints that point to "disable simple file sharing otherwise it will connect as Guest login". Does anyone think this is related?

  • September 6, 2012 at 2:56 pm

    #1534761

    Unfortunately you didn't give very much with which to work. We can't see from here what you see there. What is in the SQL error logs, were there other errors listed before and/or after this error. Actually, what is the complete error message.

    Were there any error messages at the same time in the Windows logs (application, server, security)?

  • September 6, 2012 at 3:29 pm

    #1534775

    http://blogs.msdn.com/b/sqlserverfaq/archive/2010/10/27/troubleshooting-specific-login-failed-error-messages.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 6, 2012 at 3:42 pm

    #1534780

    jerrycutshaw (9/6/2012)

    Lynn Pettis (9/6/2012)

    Here is a good place to start: http://msdn.microsoft.com/en-us/library/ms366351(v=sql.90).aspx

    Thanks Lynn. I have indeed found resources like this but much like this one they are too general to really identify a root cause.

    In my other perusing I've seen hints that point to "disable simple file sharing otherwise it will connect as Guest login". Does anyone think this is related?

    Sorry Lynn I didn't mean to sound dismissive. These are the errors I received:

    SQL Log:

    09/06/2012 12:08:55,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 11.

    09/06/2012 12:08:55,Logon,Unknown,Login failed for user 'DATACORE_KC\SQLSvcD06'. [CLIENT: 192.168.41.21]

    App Log:

    Login failed for user 'DATACORE_KC\SQLSvcD06'. [CLIENT: 192.168.41.21]

    Sys Log: NOTHING

Viewing 6 posts - 1 through 5 (of 5 total)

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