Hi
I am facing following problem
after creating linked server to active directory
I assigned login with below command sucessfully
EXEC sp_addlinkedsrvlogin 'ADSI', false, 'builtin\administrators',
'LDAP://hb-devsrv/OU=Atlas,DC=HomeBanc,DC=capgemini,DC=com', 'ch1k3n'
SELECT [Name], sn [Last Name], street [Street], l [City], st [State]
FROM OPENQUERY( ADSI,
'SELECT name, sn, street, l, st
FROM ''LDAP://hb-devsrv/OU=Atlas,DC=HomeBanc,DC=capgemini,DC=com''
WHERE objectCategory=''Person'' AND
objectClass = ''contact''')
the above select query gives a following error
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'ADSDSOObject' reported an error. The provider indicates that the user did not have the permission to perform the operation.
OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare:repare returned 0x80040e09: The provider indicates that the user did not have the permission to perform the operation.].
Has any one use Active direcotry service in SQL server.. please help
Thanks