Discussion:
Accessing Active Directory via SQL Server
(too old to reply)
David Samson
2005-10-30 22:25:02 UTC
Permalink
How do I access Active Directory via SQL Server?
Steven Cheng[MSFT]
2005-10-31 06:01:57 UTC
Permalink
Hi CaptainSlock,

Welcome to MSDN newsgroup.
Regarding on the accessing Active Directory from SQLServer question, do you
means perform AD query in sqlserver's SQL code or store procedure or any
certain services? Generally the SQLServer 2000 has limited programming
interface support, we can not perform ADSI programming like we do in other
programming languages (vb, .net .....).
In SQLServer 2005(Yukon) we can perform ADSI programming easlily through
the managed .NET extension. Here is some info about AD sqlserver
integration:

Using Active Directory with Analysis Services
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/ag
miscadmntools_8q43.asp

SQL Server 2000 Active Directory Integration
http://www.databasejournal.com/features/mssql/article.php/2176561

Active Directory Integration
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_cs_1gku.asp

Also, if you have any further SQLserver specific question, I'll recommend
you try posting in the

microsoft.public.sqlserver newsgroup.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)



--------------------
| Thread-Topic: Accessing Active Directory via SQL Server
| thread-index: AcXdoMUFnmapuXhWSRKHJVMSm+zDuA==
| X-WBNR-Posting-Host: 144.226.173.68
| From: =?Utf-8?B?RGF2aWQgU2Ftc29u?= <***@nospam.nospam>
| Subject: Accessing Active Directory via SQL Server
| Date: Sun, 30 Oct 2005 14:25:02 -0800
| Lines: 1
| Message-ID: <20446A79-7C50-4BFA-836B-***@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.data.oledb.olap
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.data.oledb.olap:554
| X-Tomcat-NG: microsoft.public.data.oledb.olap
|
| How do I access Active Directory via SQL Server?
|

Loading...