MSDTC Issue?

#21

On Mar 14, 6:52*pm, "Geoff N. Hiten" <SQLCrafts... (AT) gmail (DOT) com> wrote:

Quote:

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" <jeevanjyoti.bordo... (AT) gmail (DOT) com> wrote in message

news:b3f6b7fa-cd87-4cc1-a717-5f02e1fde8b3 (AT) i7g2000prf (DOT) 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.TransactionAbortedExcepti on"

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MSDTC Issue?

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: MSDTC Issue? - 03-14-2008 , 10:41 AM