Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AndyThomas
Starting Member
1 Post |
 Posted - 2006-08-18 : 08:04:04
|
| Hey all,Im developing a new package in SQL 2k5 using the visual dev studio, part of the package is to query the Active Directory via a linked server.This query runs fine on the SQL Server itself but not on the management PC (where VisDev is installed). All other queries from this machine run fine.Has anyone come across this before? The error is the generic error you get when there is a connection problem between SQL and AD:Msg 7320, Level 16, State 2, Line 1Cannot execute the query "SELECT displayname, name, objectsid, samaccountname, c, l, info, co, mail, sn, title, physicaldeliveryofficename, givenname, department, telephonenumber FROM 'LDAP://SVRNAME/DC=***,DC=***' WHERE objectCategory = 'Person' AND objectClass = 'user'" against OLE DB provider "ADsDSOObject" for linked server "ADSI". |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 08:16:30
|
| Which user are run running as on the server, and which user are you running as on the management pc?Check the properties on the linked server to adsi, in which security context that is set up.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
|
|
ADSI Query SQL 2005