I have a Windows Server 2003 ASP.NET Web Application that is using DTC against Sql Server 2008 on a Windows 2008 Server in our Test Environment which is a replica of our Production environment. There is no firewall between the two servers in the Test environment.
I need to have them both servers do DTC over port 50000 in the Test environment before I can implement the same change in Production because there is a Firewall between the Web Server and Database Server in Production.
Ports : REG_MULTI-SZ : 50000 PortsInternetAvailable : REG_SZ : Y UseInternetPorts : REG_SZ : Y
2) Rebooted both Servers. (Confirmed I did both)
3) Tried ASP.NET Web application and Transaction Failed
4) I see on Windows Server 2003 ASP.NET that the Transaction Statistics show 1 Aborted, and I retry several times after that.
5) Sql Server 2008 on Windows server 2008 shows no activity with 0 in all stats.
6) I was successful in doing a ping test from both servers to verify that they could see each other by name.
I removed both machines Registry Settings and reboot both servers.
1) I tried the ASP.NET Web Application with success.
2) I see activity in the Transaction Statistics on both servers.
I thought maybe I fat fingered the keys... I repeated the registry settings. Again, same DTC Fail Results when trying to use Port 50000.
Error Message is:
"The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025) System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +7596735
I went through your post, but I don’t think the problem is related to the ADO.NET data providers.The current question is more related to SQL Server settings.The forum here is mainly focused on developing issues on ADO.NET v1.1 and v2.0.I strongly recommend you post the question at the SQL Server category in TechNet forums, http://social.technet.microsoft.com/Forums/en/category/sqlserver/, for better support.Many SQL Server experts are helping us there.
If you need any further assistance, please feel free to tell me.