System.Transactions and SQL 2000

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hi,

For this to work, does the SQL server 2000 also needs Framework 2.0 runtime
installed? I'm getting the "Network DTC is disabled" exception even the
setting is enabled on the SQL Server.

Thanks

Michael
 
Micheal,
Hi,

For this to work, does the SQL server 2000 also needs Framework 2.0
runtime installed? I'm getting the "Network DTC is disabled" exception
even the setting is enabled on the SQL Server.
Click to expand...
No,

Cor
 
Hi Michael,

Welcome to MSDN newsgroup!

The System.Transaction is a new namespace included .NET Framework v 2.0. If
you want to use it, the .Net Framework Runtime v2.0 must be installed for
your application running correctly. But this is nothing with SQL Server.

For current stage, I'm not very clear about your scenario. Could you please
give me more description about your application? Like the application was
written by .NET Framework v 1.1 or v 2.0, and the detail error message.
It'll help me to understand the current issue well. Thanks your
understanding, I'm looking forward your reply!

Regards,

Yuan Ren [MSFT]
Microsoft Online Support
 
The application is .NET 2.0 application using System.Transaction for its SQL
2000 db operations. The SQL 2000 server is running on a separate server
running Windows 2003 Server. The "Network DTC" is definitely enabled on the
Windows 2003 server, but the application has an exception thrown complaining
that the "Network DTC" is disabled.

I have this exact interactions set up in two different environments, one is
working and one doesn't. Comparing the two SQL 2000 servers, the
differences are that the one which works has Windows 2003 Server SP1 and
..NET 2.0 runtime installed. And the one which doesn't work only has Windows
2003 server installed with .NET 1.0 runtime. Due to the fact that the
environments are managed, I haven't been able to test further to work out
what exactly the cause for the problem is.

Michael
 
Yes. The DTC is enabled and this is verifiable through both the
"Application Server" option and the "Component Services" option.
 
Hi Michael,

Thanks for your reply!

As far as I know, there are many issue can cause "network DTC is disabled".
So that, I suggest you performed some steps as follow description:

If you installed security update 902400, the below KB article shows how to
perform configuration:
http://support.microsoft.com/kb/908620/en-us

If the problem still occurred, I suggest you use the DTC ping tool to get
some more detail information. The below article shows how to use DTC ping
to trouble shooting:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q306843

In additional, Windows 2003 server has default firewall. Please make sure
the firewall is turned off. Otherwise, please attach return message when
you use the DTC ping. It'll help us to narrow down the current issue.
Thanks for your understanding! I'm looking forward your reply.

Regards,

Yuan Ren [MSFT]
Microsoft Online Support
 
Back
Top