Thursday, March 8, 2012

ADSI - SQL Server - Link to ADAM Help

Help!
I've seen a few others with this problem, but have not found a
solution anywhere:
I'm trying to link AD/AM to SQL Server through ADSI for querying in
SQL.
Environment:
Windows Server 2003 **Not in an AD domain
SQL Server 2000 (running under 'administrator' user account)
ADAM (Added "servername\administrator" and several adam users to the
"Readers" role)
Steps taken:
1. Add Linked Server-
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces',
'ADSDSOObject', 'adsdatasource'
2. Multiple Attempts at Linked Server Login-
exec sp_addlinkedsrvlogin 'ADSI', false, 'MACHINENAME\administrator',
'MACHINENAME\administrator', 'password'
exec sp_addlinkedsrvlogin 'ADSI', false, 'MACHINENAME\administrator',
'cn=username,cn=users,cn=app,dc=company,
dc=com', 'password'
3. Multiple Attempts to Query through SQL Query Analyzer-
SELECT * FROM OpenQuery(ADSI,
'<LDAP://localhost:389/cn=app,DC=company,DC=com>;subtree')
SELECT * FROM OpenQuery(ADSI,
'<LDAP://localhost:389/cn=app,DC=company,DC=com/cn=users>;subtree')
-- All of the above result in the following error message: 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::Prepare returned 0x80040e09: The provider indicates
that the user did not have the permission to perform the operation.].
Now, this query did result in a different error message:
SELECT * FROM OpenQuery(ADAMConn, 'SELECT * FROM
''LDAP://localhost:389/ cn=app,DC=company,DC=com'' WHERE
objectCategory = ''Person''')
--Message: OLE/DB Provider 'ADSDSOObject' ICommandPrepare::Prepare
returned 0x80040e09: The provider indicates that the user did not
have the permission to perform the operation.
Can someone help'!!Having same issue...LOTS of people with problem...but no solution posted.

No comments:

Post a Comment