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:
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
User contributions licensed under CC BY-SA 3.0