While I am familiar with SQL, I am having trouble retrieving data from Active Directories. I have followed all the instructions to create a linked server, I have set the security per the documentation. I have coded the openquery statement per
the examples but I keep receiving the same error message.
, 'SELECT displayName, userPrincipalName
WHERE objectClass = ''Person''')
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT displayName, userPrincipalName
WHERE objectClass = 'Person'" for execution against OLE DB provider "ADsDSOObject" for linked server "ADSI".
I cannot seem to find any information on why I am receiving this message. Any assistance would be greatly appreciated.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.