Distributed transactions on linked servers

I am trying to run a transaction in an SP residing on MSDE. The SP makes an insert statement on the remote linked SQL Server.
I get the following error message :

The operation could not be performed because the OLE DB
provider 'SQLOLEDB' was unable to begin a distributed
transaction.
[OLE/DB provider returned message: New transaction cannot
enlist in the specified transaction coordinator. ]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x8004d00a].

please advice me.

Isn't this the part of conversation that you started athttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1558 ? If it is, please delete this post and continue there.

Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Topic locked to continue discussion at http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1558.

Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard