Group User

[simian336]

I tried to great a new user based on a Active Directory User Group. Everything looks correct based on the examples I have seen but when I try to test connecting with a new ODBC connection it fails with

Login failed for user 'mydomain\myuser'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.1.10]

I verified that sql server can see the AD user with

master.dbo.xp_logininfo'mydomain\groupusers', 'members'
exec master.dbo.xp_logininfo 'mydomain\myuser'

and they both return the correct groups and users.

Any ideas?

Simi

 

[fredericofonseca]

AD groups are used with windows authentication - did you use that on your odbc connection?

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886