LDAP query using domain name co.id

• aerovost89

  SSC Rookie

  Points: 37

  More actions

  January 21, 2016 at 9:12 pm

  #399603

  hi all

  i have a little question about query ldap using SQL 2008 R2, LDAP server using windows server 2012

  domain was created using testing.co.id

  im tried with query below and always show error

  SELECT * FROM OpenQuery (

  ADSI2,

  'SELECT *

  FROM ''LDAP://testing.co.id:389/dc=testing,dc=co,dc=id''

  ') AS tblADSI

  Error Message :

  Msg 7321, Level 16, State 2, Line 25

  An error occurred while preparing the query "SELECT *

  FROM 'LDAP://testing.co.id:389/dc=testing,dc=co,dc=id'

  " for execution against OLE DB provider "ADSDSOObject" for linked server "ADSI2".

  any suggestion?

  thanks for help