Re: Howto troubleshoot login failure - State 11?

Jonny,

This outlines many of the states:
http://technet.microsoft.com/en-us/library/ms366351.aspx

Notice that State 11 means "Login is valid, but server access failed."

It could be that the default database the login uses is no longer defined or
the connection string is specifying an non-existant db, etc. Probably a few
other things could be the case.

RLF

"Jonny Bergdahl" <jonny.bergdahl@xxxxxxxxxxxxxxxx> wrote in message
news:F63550A0-CA30-4BBA-8355-9B9E27A79D6E@xxxxxxxxxxxxxxxx
select StartTime, TextData, NTUserName, HostName from ::

This is what the trace says.
2008-05-27 22:16:21.253 Login failed for user 'DOMAIN\BTS01$'. [CLIENT:
10.10.1.236] BTS01$ BTS01

Login failed for user 'Domain\User' [Client: xx.xx.xx.xx]
Error: 18456, Severity: 14, State: 11

Seems the info in the log is more detailed? What does State 11 indicate? I
have not found anything relevant via Google.

The strange thing is that this login actually worked for a period of 20-30
minutes, and then suddenly stopped working again.

The setup is this:
The SQL server is installed on a domain controller.
The service accessing the SQL server is installed on a separate machine
that is a member of the domain.
The service runs under the local Network service, which is why it uses the
computer account to logon.
The computer account is member of a Windows group that is granted access
to the server.

Please advice.

Regards;
/jb



.

Relevant Pages

  • gdm hangs
    ... gdm will hang 9 of 10 times when logging out. ... with or without the client having been connected to the Server. ... # Timed login, useful for kiosks. ... Must output the chosen host on stdout, ...
    (Debian-User)
  • RE: OWA 2003 with ISA 2004
    ... OWA externally. ... i can login by any user. ... 825763 How to configure Internet access in Windows Small Business Server ... g. Reproduce this issue and send the logs to me. ...
    (microsoft.public.windows.server.sbs)
  • Re: Compromised Server? Anyone recognize the suspect Services?
    ... there are a bunch of logins for Website Accounts created by the ... The login accounts are for web sites that are on the ... Server management is ... right under Network Connections there were 3 ...
    (microsoft.public.windows.server.networking)
  • Re: IIS 6.0 FTP
    ... Server port: 21. ... I doubt IIS FTP has such feature. ... next, general 530 error indicating login failed, that could due to ... clients are using an order entry program created in Microsoft access. ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: Terminal Services Setup/Flaw
    ... This still allows everyone to hit the TS Server but denies the login to ... Terminal Server with this user and then .rdp into another server on the ... I found the Remote ...
    (microsoft.public.windows.terminal_services)