June 29, 2005 at 7:56 pm
Anyone know if SQL Server 2000 will accept LDAP queries and return the equivalent of a .net SearchResultCollection?
July 4, 2005 at 8:00 am
This was removed by the editor as SPAM
July 26, 2005 at 7:20 pm
Hi Michael,
Are you looking for a way to get LDAP data into an SQL DB? This is what i am trying to achive via direct LDAP query (MS AD in this case) from inside SQL. I currently get my data in by running ActiveX script to dump data to text file then import text file to DB.
Is this the sort of thing you are trying to achieve?
Regards
Nick
July 26, 2005 at 7:39 pm
Hi Nick,
I can pull directory data into a SQL Server without too many problems... what I really want to do, however, is have SQL Server pretend it's a directory by accepting an LDAP query and return a result set of some kind.
I've since found out this isn't possible. My original problem involved the support of an application for a client with their own AD implementation which I can't access.
In lieu of a SQL Server solution and faking the LDAP result set (it's a web services based lookup so reasonably uncoupled from the rest of the app) the network admins here suggested we put together an AD of our own on a primary domain controller... I would have expected this would cause problems with our existing network but apparently we can create the PDC on a separate domain or tree or forest (or something like that!).
The solution we went with was to build up a PDC on a virtual machine... clunky but I'm hoping it will do the trick.
August 2, 2005 at 8:06 pm
Michael,
Out of curiosity what method are you using to get AD data into SQL server?
Nick
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply