March 11, 2005 at 7:26 am
Good Morning,
I am looking for some assistance.
I have created a linked server as follows: EXEC sp_addlinkedserver 'ADSI',
'Active Directory Services 2.5', 'ADsDSOObject', 'adsdatasource'
I now go to EM and open the linked server, ADSI properties. I have no local
logins defined, I click the "Be made without using a security context". I
then try to click on tables. I have also tried to use a security context.
I get the following error: error 7301: Could not obtain a required interface
from OLE DB provider 'ADsDSOObject'
Properties
General Tab:
Linked Server: ADSI
Provider Name: ADsDSOObject
Datasource: adsdatasource
Provider String:
Location:
Catalog:
On the server options tab, I have Data Access checked off.
Sql Server Version: 7.0 Server O/S: NT SP 4
Exchange Ver. 5.5 Server O/S: NT
Can you please help? Any information may be useful.
Thx,
Jeff
March 14, 2005 at 8:00 am
This was removed by the editor as SPAM
July 15, 2005 at 9:35 am
Hi Jeff
I am new to using linked server to access AD. However after some poking around and Googling, I was able to do so.
Here is what I have working for me:
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource' --I am not sure if it's case sensitive or not, I have seen some discussion on this issue. You can copy & paste to try it.
EXEC sp_addlinkedsrvlogin 'ADSI', 'false', 'sa', 'YourDomain\AnyDomainAccount', 'AccountPassword' --it seems any domain account would work, I think default AD is open for query.
--I use the following OpenQuery to get users' info in a particular OU.
SELECT TOP 100 PERCENT * FROM OpenQuery(ADSI,
'SELECT telephoneNumber, givenName, sn, mail, title, department, physicalDeliveryOfficeName, sAMAccountName, displayName
FROM ''LDAP://DCServerName.YourDomainName/OU_To_Be_Searched'' where objectClass = ''User'' AND objectCategory= ''person'' AND sAMAccountName=''*''')
ORDER BY displayName
I am currently having problem using OLE DB via linked server to Exchange 2003. If you know or have been successfully appcomplished this, please let me know.
Hopefully this can help you as well.
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply