I’m trying to use the OLEDB provider to link
AD to SQL server to run some add hoc queries. It’s returning an error:
Server: Msg 7321, Level 16, State 2, Procedure vw_AD_USER_INFO,
Line 4
An error occurred while preparing a query for
execution against OLE DB provider 'ADSDSOObject'.
OLE
hit the OK-button to get best result.
Hope that this tiny information can help you.
Regards,
/MS
By the way: W2k Sp3, SQL 2000 sp3 was used
From: Creamer, MarkSent: Thu 2004-05-27 16:49To: [EMAIL PROTECTED]Subject: [ActiveDir] linked server error in SQL/AD query
I’m trying to use the
: [EMAIL PROTECTED]
Subject: RE: [ActiveDir] linked
server error in SQL/AD query
Mark,
I tried your SQL-statement with a
linked server and it works perfectly.
What account are you running the
linked server as?
Our experience is that if you change
the
m: Creamer, MarkSent: Thu 2004-05-27 18:22To: [EMAIL PROTECTED]Subject: RE: [ActiveDir] linked server error in SQL/AD query
Mikael, I wonder if I can get a little clarification. When you say what account am I running the linked server as – maybe I made an assumption about how it should work. What I did
script in Query Analyzer.
Regards,
/MS
From: Creamer, Mark
Sent: Thu 2004-05-27 18:22
To: [EMAIL PROTECTED]
Subject: RE: [ActiveDir] linked
server error in SQL/AD query
Mikael, I wonder if I can get a little clarification. When you say
what account am I r
Anytime ;-)
Glad that I could help you
/MS
From: Creamer, MarkSent: Thu 2004-05-27 20:28To: [EMAIL PROTECTED]Subject: RE: [ActiveDir] linked server error in SQL/AD query
Mikael, that worked perfectly. What a huge help this is going to be. Thanks for your advice!!
-Original