Add And Query Linked Server To ADAM Instance...

I was not sure if this was the best SQL Server newsgroup to post this
question to but I thought I would start here.
I would like to add a linked server to an ADAM instance and then be able to
execute queries against this linked server. It looks like I can add the
linked server but I am not sure if I am doing it right. When I try to
execute a query, I receive the following:
An error occurred while preparing the query ... for execution against OLE DB
provider "ADsDSOObject" for linked server ...
I have not been able to get around this error. From what I have read, I am
getting the impression that this is a security issue. I have tried to add
logons to the linked server but again, I am not sure if I am doing this
right. Most of the articles seem to lead me in the right direction but there
is something I am not doing correctly.
Any help with this will be most appreciated.
By the way, I am using SQL Server 2005.
Thank you,
JasonWhen you created the linked server did you define the security at all? Can
you show the query you were trying to execute?
"Jason Richmeier" wrote:
> I was not sure if this was the best SQL Server newsgroup to post this
> question to but I thought I would start here.
> I would like to add a linked server to an ADAM instance and then be able to
> execute queries against this linked server. It looks like I can add the
> linked server but I am not sure if I am doing it right. When I try to
> execute a query, I receive the following:
> An error occurred while preparing the query ... for execution against OLE DB
> provider "ADsDSOObject" for linked server ...
> I have not been able to get around this error. From what I have read, I am
> getting the impression that this is a security issue. I have tried to add
> logons to the linked server but again, I am not sure if I am doing this
> right. Most of the articles seem to lead me in the right direction but there
> is something I am not doing correctly.
> Any help with this will be most appreciated.
> By the way, I am using SQL Server 2005.
> Thank you,
> Jason