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
>|||Dear John,
I have actually created linked server using following
sp_addlinkedserver
sp_addlinkedserver 'ADSI', 'Active Directory Service
Interfaces', 'ADSDSOObject', 'adsdatasource'
SELECT * INTO #adtmptbl FROM OpenQuery(ADSI,
'SELECT * FROM ''LDAP://OU=users,OU=laptop,DC=192.168.0.8,DC=local''
where objectClass = ''User''')
I have used the above to query.. but it is giving the following 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?
Thanks|||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|||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