Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Active Directory Expand / Collapse
Author
Message
Posted Thursday, December 6, 2012 1:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 9:39 AM
Points: 120, Visits: 422
Hi

I am trying to link to our active directory but without much success. I have found some useful articles on it but can't get them working. http://www.sqlservercentral.com/Forums/Topic890278-149-1.aspx

The main theme seems to be that 1st you create a linked server using:
sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces', 'ADSDSOObject', 'adsdatasource'

...then you create a view using something like...

SELECT * FROM OpenQuery
(
ADSI,
'SELECT title, displayName, sAMAccountName, givenName, telephoneNumber, facsimileTelephoneNumber, sn
FROM ''LDAP://DC=DDDLTD''
where objectClass = ''User''')

I keep getting this error...

"The provider indicates that the user did not have the permission to perform the operation."

So i changed security on the linked server to ...

"Be made using this security context" using Remote Login : DOMAIN\administartor With Password : XXXX.

Now i keep getting this error...

"An error occurred while preparing the query"

Can anyone shed any light on this for me.

Thanks


Post #1393369
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse