Hi, We are hosting an ASP.NET web application in a Windows 2003 server (with SP 2) that talks to an SQL Server 2000 database in another machine - there is no firewall between these two. I have ports 135, 1433 open in the web server. But I am getting an error while trying to save data: .NET Exception -- > "System.Transactions.TransactionAbortedException" COM Exception HRESULT --> 0x8004D019 (It says "The transaction has already been aborted") I have another web server talking to the same database with same configuration, and that is working as expected. Can anybody please help me resolving this? What configurations I need to look at?
HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003 http://support.microsoft.com/kb/555017/en-us -- Geoff N. Hiten Senior SQL Infrastructure Consultant Microsoft SQL Server MVP "jeevanjyoti" wrote in message news:b3f6b7fa-cd87-4cc1-a717-5f02e1fde8b3@i7g2000prf.googlegroups.com... > Hi, > > We are hosting an ASP.NET web application in a Windows 2003 server > (with SP 2) that talks to an SQL Server 2000 database in another > machine - there is no firewall between these two. I have ports 135, > 1433 open in the web server. But I am getting an error while trying to > save data: > > .NET Exception -- > "System.Transactions.TransactionAbortedException" > > COM Exception HRESULT --> 0x8004D019 (It says "The transaction has > already been aborted") > > > I have another web server talking to the same database with same > configuration, and that is working as expected. > > Can anybody please help me resolving this? What configurations I need > to look at?
On Mar 14, 6:52 pm, "Geoff N. Hiten" wrote: > HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server > 2003http://support.microsoft.com/kb/555017/en-us > > -- > Geoff N. Hiten > Senior SQL Infrastructure Consultant > Microsoft SQL Server MVP > > "jeevanjyoti" wrote in message > > news:b3f6b7fa-cd87-4cc1-a717-5f02e1fde8b3@i7g2000prf.googlegroups.com... > > > > > Hi, > > > We are hosting an ASP.NET web application in a Windows 2003 server > > (with SP 2) that talks to an SQL Server 2000 database in another > > machine - there is no firewall between these two. I have ports 135, > > 1433 open in the web server. But I am getting an error while trying to > > save data: > > > .NET Exception -- > "System.Transactions.TransactionAbortedException" > > > COM Exception HRESULT --> 0x8004D019 (It says "The transaction has > > already been aborted") > > > I have another web server talking to the same database with same > > configuration, and that is working as expected. > > > Can anybody please help me resolving this? What configurations I need > > to look at?- Hide quoted text - > > - Show quoted text - MSDTC has been enabled and running. Could anyone help me out with the configuration settings?
