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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-03 : 11:18:30
|
Bruce writes "I have done a lot of programming with active directory using ado but I would love to get this working. I can't seem to get the linked server working in sql server 2000 for active directory.
No matter what I try, it will not work. I cannot see any tables
in the linked server in Active directory.
Could explain me a working sample that works!
The following is an example. I use adsviewer a lot. So I know what I am querying.
Also I would like to program in a username and password, so I don't have to worry about authentication. I can do the same in Ado.
So could you give me the exact syntax.
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'
go
select * from openquery(ADSI, 'select * from ''LDAP://<>''')
go
Thanks,
" |
|
|
|
|
|
linked server