Groups | Blog | Home
all groups > sql server programming > september 2003 >

sql server programming : ADSI?


Mongo
9/17/2003 9:53:01 PM
HTH:

-- EXEC sp_addlinkedserver 'ADSI25', 'Active Directory Services 2.5',
'ADSDSOObject', 'adsdatasource'

-- sp_AddLinkedSrvLogin @RmtSrvName = 'ADSI', @RmtUser =
'yourdomainName\AuthDomainUser', @RmtPassword = 'AuthDomainUserPassword'

/*
SELECT
samaccountname, cn, distinguishedName
FROM OPENQUERY( ADSI25
, ' SELECT
samaccountname, cn, distinguishedName
FROM ''LDAP://yourdomainName'' WHERE objectClass = ''user''') order
by cn
*/

Mongo

Frank Dulk
9/17/2003 10:12:38 PM




How to Access is base for SQL, I tried to rotate the sp_addlinkedserver, but
when I try to open the table it accuses mistake of Provider OLEDB and Of the
Objeto ADDSOObject.

Mongo
9/17/2003 10:13:58 PM
Errata:

-- sp_AddLinkedSrvLogin @RmtSrvName = 'ADSI', @RmtUser =
'yourdomainName\AuthDomainUser', @RmtPassword = 'AuthDomainUserPassword'

Should read:

-- sp_AddLinkedSrvLogin @RmtSrvName = 'ADSI25', @RmtUser =
'yourdomainName\AuthDomainUser', @RmtPassword = 'AuthDomainUserPassword'

AddThis Social Bookmark Button