Home Forums SQL Server 2005 SQL Server 2005 General Discussion Query LDAP server from SQL Server RE: Query LDAP server from SQL Server

  • May 24, 2011 at 7:02 am

    #1329016

    Peter Pirker (5/12/2011)

    I got your example to work when I'm physically on the server, but when I try it from my workstation, I get:

    An error occurred while preparing the query "SELECT * FROM 'LDAP://NOVMDC02.SD.INT' where objectClass = 'User' " for execution against OLE DB provider "ADsDSOObject" for linked server "(null)".

    I assume it's some sort of security issue.

    Same exact behavior here, works fine if I remote onto the server where Linked Server is set up. I was thinking it was like a double hop issue.