Linked Server in SQL Server 2000 for Active Directory.

I am trying to create linked servers for Active Directory from SQL
Server 2000.
Can somebody tell me how to actually create it.
I have no idea what are those parameters.
1. Product
2. Provider
3. Provider String
4. Data Source
5. Catalog
6. Location
Also on the security tab what is the security level it requires for
proper authentication.
ThanksHi
Check previous postings:
http://tinyurl.com/6l76n
http://tinyurl.com/5d474
You may also want to check out the newsgroup
microsoft.public.active.direct_ory.interfaces
John
"tension" <kumar877@.gmail.com> wrote in message
news:1113118999.884752.319920@.z14g2000cwz.googlegroups.com...
>I am trying to create linked servers for Active Directory from SQL
> Server 2000.
> Can somebody tell me how to actually create it.
> I have no idea what are those parameters.
> 1. Product
> 2. Provider
> 3. Provider String
> 4. Data Source
> 5. Catalog
> 6. Location
> Also on the security tab what is the security level it requires for
> proper authentication.
> Thanks
>|||tension wrote:
> Dear John,
> I have used the following to add the linked server.
> sp_addlinkedserver 'ADSI', 'Active Directory Service
> Interfaces', 'ADSDSOObject', 'adsdatasource'
>
> And I am querying using the following.
> SELECT * INTO #adtmptbl FROM OpenQuery(ADSI,
> 'SELECT * FROM ''LDAP://OU=users,OU=laptop,DC=192.168.0.8,DC=local''
> where objectClass = ''User''')
> and getting the error
> Server: Msg 7321, Level 16, State 2, Line 1
> An error occurred while preparing a query for execution against OLE
DB
> provider 'ADSDSOObject'.
> OLE DB error trace [OLE/DB Provider 'ADSDSOObject'
> ICommandPrepare::Prepare returned 0x80040e14].
> Any idea's? may be my OU and DC names are wrong.. how to find the
right
> one's.
> I am using windows 2003 server and sql server 2000 SP3.
> Thanks, your reply to this message is greately appreciated.
> Kumar