If you are transferring data from one server to another server in transaction mode, you need to activate MSDTC (Microsoft distributed transaction cordinates).
 In my scenario, I used MS SQL server A and MS SQL server B.  SQL SERVER B is linked server of SERVER A.
 I have same credentisals for both Windows 2003 and same credentisal for SQL server. To avoid network plot blocking I disabled firewalls from both machines.
 Then from command prompt I started MSDTC
Net start MSDTC

 If you changed the password of your sql server, you need to restart your MSDTC service.


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 Interview Questions for 2 years or 3 years experianceMS SQL server Transaction commit rollbacktransaction


My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.

I'm Satalaj.