Distributed Transactions...SQLOLEDB error

[Guest_imported]

Hi,
We have established a link server between two SQL servers for executing distributed transactions. But it is returning the following error:

The operation could not be performed because the OLE DB provider 'SQLOLEDB' does not support distributed transactions.
[OLE/DB provider returned message: Distributed transaction error]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

We have to make this work when the SQL servers are setup in two static IP NT servers....Surprisingly the procedure worked with two static IP Win 2000 servers. It also worked when the NT servers were in the same network. We tried installing service pack 2 for SQL... but with no luck

Any idea why we are getting this error. Any help will be really appreciated.

thanx in advance,
Jim.

 

[foxdev]

I assume both are SQLS 7. It sounds like maybe its a security issue? I'm wondering if, when the machines are no longer in the same NT domain, your SQLS security login settings may be interfering...?

Robert Bradley

http://www.foxdev.com/