Connecting to Active Directory

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Connecting to Active Directory

Author

Topic

leedoolan
Starting Member

12 Posts

Posted - 2002-11-28 : 05:27:15

Using the following code:

exec sp_DropServer 'ADSI','droplogins'
go
exec sp_addlinkedserver 'ADSI','Active Directory Services 2.5','ADSDSOObject','adsdatasource'
go

exec sp_AddLinkedSrvLogin @RmtSrvName = 'ADSI', @UseSelf = 'false', @LocalLogin = 'sa', @RmtUser = 'GROUP\INT001', @RmtPassword = 'boo'
go

select sn from openquery(ADSI, 'select sn from ''LDAP://GROUP/DC=GROUP,DC=NET'' WHERE sn=''Doolan'' ')
go

I keep getting the following error:

An error occurred while preparing a query for execution against OLE DB provider 'ADSDSOObject'.

DOes anybody have any ideas or suggestions?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources