Mark Forums Read

MSDTC Issue?

Go Back

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

Reply

Page 1 of 3

1

#1

Old

jeevanjyoti

Posts: n/a

MSDTC Issue? - 03-14-2008 , 07:40 AM

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?

Reply With Quote

#2

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#3

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#4

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#5

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#6

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#7

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#8

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#9

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

#10

Old

Geoff N. Hiten

Posts: n/a

Re: MSDTC Issue? - 03-14-2008 , 07:52 AM

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

Quote:

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?

Reply With Quote

Reply

Page 1 of 3

1

« Previous Thread | Next Thread »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.