sql server - Login failure with error 18456 using Windows Groups -


i have application using ef connecting sql server 2008 express database , using windows authentication.

if add login specific user, connects successfully. if add user new security group in active directory , create login group, connection database fails. error log says:

2015-05-29 15:45:53.59 logon       error: 18456, severity: 14, state: 38. 2015-05-29 15:45:53.59 logon       login failed user 'domain\test'. reason: failed open explicitly specified database. [client: 192.168.x.y] 

i've tried setting default database login , giving permissions on master database, can't work.

i don't know how debug further.


Comments

Popular posts from this blog

Java 3D LWJGL collision -

spring - SubProtocolWebSocketHandler - No handlers -

methods - python can't use function in submodule -