blossompark
asked on
Get error when querying Active Directory From SQL Server ADSI Linked Server
Hi,
I have an ADSI Linked Server on a SQL Server 2014 server which seems to be connected ok
However when I run the following query
Any guidance appreciated
Thanks
I have an ADSI Linked Server on a SQL Server 2014 server which seems to be connected ok
However when I run the following query
Select *
FROM OPENQUERY
( ADSI, 'SELECT extensionAttribute3, extensionAttribute2, employeeType, manager, streetAddress,
physicalDeliveryOfficeName, mobile, ipphone, department, company, info, title, employeeID, mail, telephoneNumber,
displayName, sAMAccountName
FROM ''LDAP://ou=cccusers,dc=europe,dc=global'' WHERE objectCategory = ''Person''' )
i get the error messageMsg 7321, Level 16, State 2, Line 19
An error occurred while preparing the query "SELECT extensionAttribute3, extensionAttribute2, employeeType, manager, streetAddress,
physicalDeliveryOfficeName, mobile, ipphone, department, company, info, title, employeeID, mail, telephoneNumber,
displayName, sAMAccountName
FROM 'LDAP://ou=cccusers,dc=europe,dc=glo bal' WHERE objectCategory = 'Person'" for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI".
Any guidance appreciated
Thanks
ASKER
Hi Shreedhar, same error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Shreedhar, have not resolved the issue but closing for now
LDAP://europe.global/ou=cc