adsi linked servers
From: Chris Szabo (cszabo@aerotechlabs.com)
Date: 12/02/02
- Next message: Frank: "Want to deny access to a table automaticaly"
- Previous message: SQL Server Development Team [MS]: "Re: SQLServer logs+ip addresses"
- Next in thread: Hal Berenson: "Re: adsi linked servers"
- Reply: Hal Berenson: "Re: adsi linked servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Chris Szabo" <cszabo@aerotechlabs.com> Date: Mon, 2 Dec 2002 11:50:10 -0800
I'm creating an application that pulls data from a variety
of sources. Among these sources is a Windows 2000 Active
Directory. As such, I would like to create a linked
server out of the Active Directory repository.
I'm following the directions for the OLE DB Directory
Service Provider. I add the linked server with this TSQL
command:
EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services
2.5', 'ADSDSOObject', 'adsdatasource'
GO
The server is added successfully, however when I try to
access tables or views through enterprise manager I
receive an error, "Count not obtain a required interface
from OLE DB provider 'ADSDSOObject'".
If I execute an openquery command from query analyzer I
receive an error message, "n error occurred while
preparing a query for execution against OLE DB
provider 'ADSDSOObject'."
Does anyone know where I'm going wrong. Any help is much
appreciated. Thanks.
- Next message: Frank: "Want to deny access to a table automaticaly"
- Previous message: SQL Server Development Team [MS]: "Re: SQLServer logs+ip addresses"
- Next in thread: Hal Berenson: "Re: adsi linked servers"
- Reply: Hal Berenson: "Re: adsi linked servers"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
