MSDTC error on windows 2008 R2

Posted on 2011-05-05
Last Modified: 2012-05-11
Hi Guys, here is my problem :

I've got an application installed on Windows 2003R2, it works well.
The Application is a client software who is asking another Windows 2003R2 with SQL2005 databases.

On Windows 2008 R2, this client software is installed as well, it seems working properly but for somes opérations, it crash with this error message :

The MSDTC transaction manager was unable to pull the transaction from the source transaction manager due to communication problems. Possible causes are: a firewall is present and it doesn't have an exception for the MSDTC process, the two machines cannot find each other by their NetBIOS names, or the support for network transactions is not enabled for one of the two transaction managers.

Of course, no firewall are blocking the traffic.

So I checked MSDTC configuration and both (2003 & 2008) servers, it's the same :

I asked the developer of the app, he told my that he saw somethings like that with SQL Server 2008 about multiple connexions with MSDTC.

He tried to change the connexion string in his app, adding :  


But no chance...

Did someone already had problem with MSDTC in Windows 2008 R2 ?
Question by:Carlito985
    LVL 18

    Expert Comment

    check the "aucune authentification requise"
    LVL 18

    Assisted Solution

    If you where dealing ONLY with 2008 R2, the setting would be ok.

    Windows 2003 does not seem to like the "authentication" options
    more info:
    LVL 1

    Author Comment

    I tried "no authentication required " but doesn't work.

    I read theses articles, but no chance :-/
    LVL 18

    Assisted Solution

    no authentication required on BOTH servers?
    LVL 1

    Accepted Solution

    Sorry Guys, I found the pb:

    I opened network port to access the databases, so my application was able to access them.
    But I forgot to open port for DTC communication... :-/

    Anyway, thanks !
    LVL 1

    Author Closing Comment

    Found the pb.

    Featured Post

    Too many email signature changes to deal with?

    Are you constantly being asked to update your organization's email signatures? Do they take up too much of your time? Wouldn't you love to be able to manage all signatures from one central location, easily design them and deploy them quickly to users. Well, you can!

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now