Ad-hoc Updates of Active Directory using MS SQL Linked Server
Posted on 2009-02-23
I have a linked server with local DB and remote domain admin credentials setup in MS SQL (2000 or 2005) which I can query AD just fine. I was wondering if MS SQL supports ad-hoc updates of Active Directory using the linked server. I have scoured the net finding hundreds of articles that either go unanswered or fall into unrelated territory. Essentially, when I do very basic update statements against the same table (the linked server connection that works with standard queries), I get the following error:
Server: Msg 7390, Level 16, State 1, Line 1
The requested operation could not be performed because the OLE DB provider 'ADsDSOObject' does not support the required transaction interface.
OLE DB error trace [OLE/DB Provider 'ADsDSOObject' IUnknown::QueryInterface returned 0x80004002].
I can provide code samples, but I have searched the net and have not been able to successfully find a simple answer as to whether or not it is possible. If it is, then we can go from there.
Any feedback is greatly appreciated.