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

LDAP using SQL 2012 Expand / Collapse
Author
Message
Posted Wednesday, June 12, 2013 4:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:10 PM
Points: 10, Visits: 227
In our current system, we query the LDAP using SQL 2008R2 but are moving to SQL 2012 where we have hit a snag. According to http://msdn.microsoft.com/en-us/library/cc707782.aspx one of the discontinued features of SQL 2012 is the AD helper service.

Does anyone know of a way to query the AD from SQL 2012?
Post #1462851
Posted Thursday, June 13, 2013 11:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 1,157, Visits: 3,264
Have you tried querying AD using a linked server via the OLE DB Provider for Microsoft Directory Services?

Check out -

http://msdn.microsoft.com/en-us/library/ms190803(v=sql.105).aspx



Tommy

Post #1463239
Posted Thursday, June 13, 2013 1:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 12, 2014 12:10 PM
Points: 10, Visits: 227
I don't have a problem setting up the linked server but can not query the LDAP which uses the Active Directory Helper Service
Post #1463277
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse