Need Help. Why does the SSIS Runtime fail to start the distributed transaction?

0

Some days ago I decided to reinstall Windows 10 and all my development tool like latest version of SQL Server 2017 and Visual Studio 2017 Professional. I also installed SQL Server Data Tool to get Business intelligence project templates like Integration services and Analysis services.

Everything seems alright until I ran my Visual studio integration services project which contains packages with sequence containers with several execute sql tasks. The sequence containers are set up as Required transaction while the tasks as Supported. That have always worked until now :-(

Suddenly these packages now failed with the message:

Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running.

I have checked almost every article that describes this error but nothing seems to solve this issue for me. Here what I have done:

  1. I installed a SQL developer version instance on my computer and I turned off the firewall before running the install script and the installation was ok.
  2. Then I install Visual studio and at last Sql server data tool.
  3. I created a test integration services project just to see if the installation has worked, but I got the error above.
  4. First I checked that the Distributed Transaction Coordinator ran, and it did
  5. Then I checked the settings in Component Services-> Computers-> My Computer->Distributed Transaction Coordinator->Local DTC, right clicked on Properties and checked that Network DTC Access and all necessary check boxes were set and I was.
  6. I must mention that my windows installation is set up as Organizational installation joined to our Azure AD.
  7. this is what was written into the Event viewer. Hope that may help:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {E0628A3F-D40D-4C78-87B9-98733CDF11F2} and APPID {347F1A3E-7950-45F6-8681-43C056BDE1BD} to the user AzureAD\GeirForsmo SID (S-1-12-1-372923485-1223005809-3398675072-2521564256) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

I really hope any of you can help me out here.

Regards Geir

Component Services settings

sql-server
visual-studio
ssis
msdtc
asked on Stack Overflow Dec 4, 2018 by Geir Forsmo • edited Dec 4, 2018 by Geir Forsmo

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0