using TransactionOption in April CTP
Hello.
I am using April CTP.
In the main package, i am setting the TransactionOption to Required whereas in the child packages to Supported. But i'm getting the following error:
The DTS Runtime has failed to start the distributed transaction due to error 0x8004D01C "A connection with the transaction manager was lost.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running.However the MSDTC service is running.
What could be the cause?
Thanks
Christina
You're right. There is this error in the event log:
DCOM got error "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. " attempting to start the service MsDtsServer with arguments "" in order to run the server:
{ABF05265-635E-44B0-A28F-AEA45247ACA0}
This is telling you that DCOM attempted to start the DTS server. The GUID
{ABF05265-635E-44B0-A28F-AEA45247ACA0} is the AppID for the DTS Service. I don't believe that this is the source of your problem. You should look for errors from the MSDTC server which controls the distributed transactions on the machine.
However, you should attempt to start the DTS Service in the services control panel or in SQL Server Configuration Manager. It should always be running.
K
Hi.
I have both services MSDTC and DTS started, in addition to SQL Server and SQL Server Agent services. They're configured to start automatically under the local system account. The operating system is Windows Server 2003 (Enterprise Ed).
In my events log i can see some errors when the server starts:
DHCP service failed to start
The DHCP service failed to initialize the database
The Cryptographic Services service failed to initialize the VSS backup "System Writer" object. Details: System Writer object failed to initialize VSS.
I am still getting the same error when i run the package in Required mode.
Thanks
Christina
