Query Active Directory from SQL Server 2005

In: Active Directory| SQL Server


15 Aug 2008

Some time ago, I needed to sync down a list of AD users to use as a lookup (as opposed to querying LDAP on demand). I found this little gem: How to avoid 1000 rows limitation when querying active directory (AD) from SQL 2005 with using custom code. It works great, especially since I submitted a bug fix.

In any case, the process is very simple:

  1. Download and open the MSADHelper2.rar project files
  2. Point Visual Studio at the target server and deploy
  3. Run the installation script provided in the post – Pay attention though, there’s some configuration, installation, and test statements in there

I highly recommend you download and tuck this project away on disk somewhere, even if you don’t need it yet. It’s worked flawlessly for me and been a huge help.

  • Share/Bookmark

1 Response to Query Active Directory from SQL Server 2005

Avatar

Query Active Directory from SQL Server (again) | Idea Excursion

November 4th, 2008 at 3:02 pm

[...] my last post on the issue, instead of simply copping out and pointing to another blog for instructions on how to query Active [...]

Comment Form

  • ERNST: HOW TO SYNC MULTIPLE GOOGLE CALENDARS IN IPHONE: To show Multiple Google calendars in iPhone, ope [...]
  • linuxfueled: WINDOWS 7 users read..... If your main OS is Windows 7 (the host machine) and you just cannot get [...]
  • Kurt Hitchen: A friend has let me "see" there calendar in Google Calendar, but because their calendar is set to pr [...]
  • bugoy8: https://www.google.com/calendar/dav/nba_13_%4cos+%41ngeles+%4cakers#sports@group.v.calendar.google.c [...]
  • Speaker: Wasn't able to understand how to access the shared folder in the quest OS from this tutorial. Hmmm [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.