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 |
|
rickster
Starting Member
5 Posts |
 Posted - 2008-02-20 : 10:42:35
|
| Hello,I've just started checking into this, but so far I haven't found much to help with what we are attempting...so I figure I'll ask if it's possible at all :)We have a need to have sql server (via an ssis package or straight t-sql) communicate with our Active Directory server. Unlike most of the examples I've found so far however, we need to *update* a given AD account. (gory details: phone extensions are stored in AD to be used by our phone system application; unfortunately, the department that manages phone extensions uses an app that writes to SQL Server, and is pretty much a black box, so we can't make it write directly to AD.)We've got Coldfusion apps that are able to update AD records, so coding in CF and scheduling there is a fallback option. I'd much prefer to "eliminate the middleman" and have a SQL Server job do this.Is this feasible to do in SQL Server? If so, I'd greatly appreciate a starting point for info. Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 15:08:54
|
| Can try it via linked server, ensure sql service account has permission to update ads. |
 |
|
|
|
|
|
sql server-active directory question