Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2008-07-18 : 13:12:53
|
| I'm trying to query AD to get information about some users, stored on a table and present on a report format on SSRS. I created a linked server to AD and I'm trying to query using OPENQUERY, can anyone see what am I doing wrong?Adding Linked Server and Login:EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5','ADSDSOObject', 'adsdatasource'EXEC sp_addlinkedsrvlogin 'ADSI', False, 'sa','domain\usr', 'DomainPa$$w0rd'GOQuerying AD:SELECT samAccountName, givenName [First Name], sn [Last Name], legacyExchangeDNFROM OPENQUERY(ADSI,'SELECT samAccountName, givenName, sn, legacyExchangeDN FROM ''LDAP://DC=DOMAIN,DC=NET'' WHERE objectClass=''Person''AND objectClass = ''User''')WHERE givenName IS NOT NULLError Message:OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare:Stick out tonguerepare returned 0x80040e14].Msg 7321, Level 16, State 2, Line 1An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'.---http://www.ssisdude.blogspot.com/ |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-07-18 : 13:56:28
|
| Got it, I wasn't using the sa connection while querying AD. Everything is working fine now...---http://www.ssisdude.blogspot.com/ |
 |
|
|
|
|
|
|
|
Querying AD