Error: 18456 Severity: 14 State:11

Hi, We recently deployed an application using SQL 2005. We have encountered
intermitten issues with people access the application. Within the MS SQL logs
we see the error "Error: 18456 Severity: 14 State:11". Which thru my searches
have lead me to beleive that the have been authenticated but state 11 means
they are unable to access the database for some reason.

All the Users are in a Group, let call is Group A. We have created a Login
for Group A and assigned the default database to Application A. We have
granted read and write privledges to Application A.

In the error message under data I see the following:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 05 00 00 00 4c 00 41 00 ....L.A.
0010: 42 00 31 00 00 00 07 00 B.1.....
0018: 00 00 6d 00 61 00 73 00 ..m.a.s.
0020: 74 00 65 00 72 00 00 00 t.e.r...

Any Help would be appreciated.

In the error

I don't know if this is your problem, but here is something to know.

If a User is in more than one Group that has access to a SQL Server and each
Group has its own default database, then it is undefined which default
database a particular User will use. If the User has a directly assigned
default database, that the User's default will always be used.

If your application directly connects to a database without depending on the
default database, then you should not get this error.

The intermittence could be a number of things, including the possibility
that the "other default" database is sometimes off-line and sometimes
on-line. To check a particular User's possible default databases you could
run a query like this one:

EXECUTE AS LOGIN='DOMAIN\USER'

SELECT name AS LoginName, dbname AS DefaultDB FROM master.dbo.syslogins
WHERE IS_MEMBER(name) = 1

REVERT

--
RLF


"mmmatrix" wrote in message

> Hi, We recently deployed an application using SQL 2005. We have
> encountered
> intermitten issues with people access the application. Within the MS SQL
> logs
> we see the error "Error: 18456 Severity: 14 State:11". Which thru my
> searches
> have lead me to beleive that the have been authenticated but state 11
> means
> they are unable to access the database for some reason.
>
> All the Users are in a Group, let call is Group A. We have created a Login
> for Group A and assigned the default database to Application A. We have
> granted read and write privledges to Application A.
>
> In the error message under data I see the following:
> 0000: 18 48 00 00 0e 00 00 00 .H......
> 0008: 05 00 00 00 4c 00 41 00 ....L.A.
> 0010: 42 00 31 00 00 00 07 00 B.1.....
> 0018: 00 00 6d 00 61 00 73 00 ..m.a.s.
> 0020: 74 00 65 00 72 00 00 00 t.e.r...
>
> Any Help would be appreciated.
>
> In the error