Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-24 : 07:56:04
|
| Dan writes "SQL Server 2000 Enterprise Edition, (8.00.760) SP3 on Windows 2000 Advanced Server SP4.I would like to know if you have published detailed HOWTO information about using SQL to query, and update the Active Directory, including possible custom class attributes.We need a central repository of employee information, and are toying with the idea of extending the AD schema to include custom User data, but need a method of retrieving (via Linked server ?), and updating the information (via Stored Procedures ?). This would include being able to reset the user's password.I am currently getting query results from AD using the documentation in Books Online, but cannot figure out how to update AD attributes (single, or multiple).Your suggestions are appreciated.Dan" |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-24 : 09:48:17
|
| Not just a number standing in left field...what is Dan talking about?Sign meAncient NT 4.0 UserBrett8-) |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-07-25 : 03:18:30
|
Hmm... Well you can add a linked server via ADSI. That's about what I know about it. I would try to help you out by testing, but I'm afraid I'm not trusted on our domain controllers  |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-07-25 : 19:32:46
|
| At the moment it's a readonly provider so no, you can't update AD using a linked server. HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-07-25 : 19:38:09
|
| Sorry to hijack the thread temporarily, but is it possible to configure a linked server to an Exchange server, and query the folders? I'm trying to find it on MSDN and haven't quite found it yet.I know you can link to Exchage directly with MS Access, so I imagine the driver is available somewhere. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
|
|
|
|
|
Querying the Directory Service 