SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Saturday, December 31, 2005

MSDTC - What a pain

Yes I admit that I am not an expert in MSDTC, but still so difficult to figure this damn thing. If Windows Firewall is ON it wont work. I didnt have that turned on, but I have had Norton on my machine, which would stop MSDTC working as well. If you get this kind of message please try to disable your firewall and try before anythign else. You will get the message below even though you have configured MSDTC correctly and started successfully.

------------------------------
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.
------------------------------

Useful posts when you try to resolve MSDTC issue :
http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2339.aspx
http://blogs.conchango.com/paulmcmillan/archive/2005/10/17/2277.aspx
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q293799
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306843

It is advisable to run MSDTC with DTC Logon Account such as "NT AUTHORITY\NETWORK SERVICE". Also select "Allow Inbound" and "Allow Outbound" under Transaction Manager Communication.

Thanks
Sutha

0 Comments:

Post a Comment

<< Home