all groups > sql server (alternate) > december 2003 >
You're in the

sql server (alternate)

group:

Accessing Active Directory using SQL Server 2000


Accessing Active Directory using SQL Server 2000 btugg NO[at]SPAM yahoo.com
12/30/2003 2:44:00 PM
sql server (alternate):
Hello All,

I have a linked ADSI Server to our company Active Directory and
everything is fine. I'm running queries and such using LDAP. BUT how
can I aquire a list of attributes for the classes and categories. Such
as if i wanted to see a user's telephone number and email address for
use in a corporate database? Is this possible?

Re: Accessing Active Directory using SQL Server 2000 btugg NO[at]SPAM yahoo.com
12/31/2003 7:00:25 AM
Thanks John but I'm looking a little deeper than that.

While searching yesterday I ran across another attribute that is
usually shown
in sample LDAP queries and it was "sAMAccountNAme" which is the
account a user may log on with. I'm for a list of attributes for
Computers, People, etc in Active Directory. Is there such a list or
definition table?

[quoted text, click to view]
Re: Accessing Active Directory using SQL Server 2000 John Bell
12/31/2003 11:13:18 AM
Hi

I have never tried this.. but...:

The example of ADSI in books online returns the SN and ST attributes of the
contact class. See Books Online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\acd
ata.chm::/ac_8_qd_12_94fn.htm

You should then be able to use the same OPENQUERY as the destination of the
update statement. See Books Online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsq
lref.chm::/ts_oa-oz_5xix.htm

John

[quoted text, click to view]

Re: Accessing Active Directory using SQL Server 2000 John Bell
1/1/2004 12:01:47 PM
As in ?:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ad/ad/user_object_user_interface_mapping.asp

John

[quoted text, click to view]

Re: Accessing Active Directory using SQL Server 2000 btugg NO[at]SPAM yahoo.com
1/9/2004 8:45:13 AM
Yes! Thanks John!
[quoted text, click to view]
AddThis Social Bookmark Button