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
Post a Comment