Re: Howto troubleshoot login failure - State 11?

Jonny,

We have a script that will help. In the folder where the SQL error logs go
you will find a number of trace files (.trc). You will need to get the name
of the latest one then try this:-

select StartTime, TextData, NTUserName, HostName from ::
fn_trace_gettable('D:\DBMS\MSSQL.1\MSSQL\LOG\log_xxx.trc', default)
join sys.trace_events on eventclass = trace_event_id
where eventclass = 20;

where xxx.trc is the name of the trace file. This is the default trace that
should be running unless you set it off using sp_configure.

HTH

Chris

"Jonny Bergdahl" <jonny.bergdahl@xxxxxxxxxxxxxxxx> wrote in message
news:FEF97424-2FAC-47F0-BF6D-CA1D370EB499@xxxxxxxxxxxxxxxx
I have a problem where a logon account is denied access to SQL Server 2005.

The server log:

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

How do I troubleshoot this? The account is a member of a Windows group,
and it is the group that is granted access to the SQL server.

Regards;
/jb




.