Active directory service on SQL server

• Ritesh-123787

  SSC Veteran

  Points: 256

  More actions

  March 21, 2006 at 8:34 am

  #112399

  Hi

  I am facing following problem

  after creating linked server to active directory

  I assigned login with below command sucessfully

  EXEC sp_addlinkedsrvlogin 'ADSI', false, 'builtin\administrators',

  'LDAP://hb-devsrv/OU=Atlas,DC=HomeBanc,DC=capgemini,DC=com', 'ch1k3n'

  SELECT  [Name], sn [Last Name], street [Street], l [City], st [State]

  FROM OPENQUERY( ADSI,

       'SELECT name, sn, street, l, st

        FROM ''LDAP://hb-devsrv/OU=Atlas,DC=HomeBanc,DC=capgemini,DC=com''

        WHERE objectCategory=''Person'' AND

        objectClass = ''contact''')

  the above select query gives a following error

  Server: Msg 7399, Level 16, State 1, Line 1

  OLE DB provider 'ADSDSOObject' reported an error. The provider indicates that the user did not have the permission to perform the operation.

  OLE DB error trace [OLE/DB Provider 'ADSDSOObject' ICommandPrepare:repare returned 0x80040e09:  The provider indicates that the user did not have the permission to perform the operation.].

  Has any one use Active direcotry service in SQL server.. please help

  Thanks

• Karl Klingler

  SSCertifiable

  Points: 5869

  More actions

  March 22, 2006 at 7:07 am

  #628080

  Hi,

  usage of sp_addlinkedsrvlogin:

  sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'

  [ , [ @useself = ] 'useself' ]

  [ , [ @locallogin = ] 'locallogin' ]

  [ , [ @rmtuser = ] 'rmtuser' ]

  [ , [ @rmtpassword = ] 'rmtpassword' ]

  you might perhaps use something like:

  EXEC sp_addlinkedsrvlogin 'ADSI', false, 'sa', 'Administrator', 'ch1k3n'

  regards

  karl

  Best regards
  karl