Link to home
Start Free TrialLog in
Avatar of assaadrezk
assaadrezk

asked on

New transaction cannot enlist in the specified transaction coordinator

Hello All,

I have a problem using OPENDATASOURCE with (BeginTrans, Commit and Rollback)

It always gives ,me the following error

"New transaction cannot enlist in the specified transaction coordinator"

If it stop the (BeginTrans, Commit and Rollback) it works find

I did all the possible ways to start MSDTC and I still have the same Error

Please Help me.

Regards


Avatar of shtson
shtson
Flag of Israel image

Hai2u,

Is it possible you're not running the component within the MSDTC?

say, have not registered it as COM+ application in the Component Services and accessed it through there?

Cheers,
Shai
Avatar of assaadrezk
assaadrezk

ASKER

In Component Services I changed the Security Configuration for  MSDTC
to Allow Inbound , Allow Outbound and DTC logon account to NT AUTHORITY\NetworkService
I Don't know how to register it as COM + application.
Please explain.
Thanks

ASKER CERTIFIED SOLUTION
Avatar of shtson
shtson
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thank you may Friend,
I'll follow your article and I'll keep you updated ,
thanks again
Glad to be of service :)
Make sure "Distributed Transaction Coordinator" service is running.