[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MSDTC error on windows 2008 R2

Posted on 2011-05-05
6
Medium Priority
?
1,512 Views
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 :

 pic1
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 :  

connectionString="MultipleActiveResultSets=True;...

But no chance...

Did someone already had problem with MSDTC in Windows 2008 R2 ?
0
Comment
Question by:Carlito985
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:x-men
ID: 35696720
check the "aucune authentification requise"
0
 
LVL 18

Assisted Solution

by:x-men
x-men earned 2000 total points
ID: 35696732
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:
http://support.microsoft.com/kb/969594
http://support.microsoft.com/kb/817064
0
 
LVL 1

Author Comment

by:Carlito985
ID: 35696777
I tried "no authentication required " but doesn't work.

I read theses articles, but no chance :-/
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
LVL 18

Assisted Solution

by:x-men
x-men earned 2000 total points
ID: 35696863
no authentication required on BOTH servers?
0
 
LVL 1

Accepted Solution

by:
Carlito985 earned 0 total points
ID: 35697253
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 !
0
 
LVL 1

Author Closing Comment

by:Carlito985
ID: 35726821
Found the pb.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
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 SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

864 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