Search
InstantDoc ID
GO

Browse By: Author | Issue

August 12, 2009 08:12 PM

Querying Active Directory Records

A look at three methods and their results
Rating: (0)
Jameel Ahmed
SQL Server Magazine
InstantDoc ID #102200
Executive Summary:
There are several ways to query Microsoft Active Directory (AD) from Microsoft SQL Server. One common method involves using the sp_add_linked_server stored procedure to create a linked server, then using T-SQL's OPENQUERY clause to directly query Active Directory. Another common method is to use an ADO.NET connection manager in a SQL Server Integration Services (SSIS) package so that you can...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Please change ADsDSObject
to ADsDSOObject, and give it a try.

Jameel9/18/2009 12:55:42 PM

I liked your article and I am trying using linked server. I ran this command

Exec sp_addlinkedserver 'ADSI','Active Directory Services 2.5',
'ADsDSObject','adsdatasource'
and then ran the Select command, I am getting following error message

Msg 7403, Level 16, State 1, Line 4
The OLE DB provider "ADsDSObject" has not been registered.

Please Help.
Thanks
Shafiq

shafiqm@gmail.com9/18/2009 8:16:00 AM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.