Problem with transactions from Win2k app server to Win2k3 SQL Server -- dotnet component services

dotnet component services : Problem with transactions from Win2k app server to Win2k3 SQL Server

paul crowder
10/21/2003 10:39:01 AM

Here's my set-up:

- Windows 2000 application server with serviced components registered in
Component Services
- Windows 2003 Server Standard running SQL Server 2000

Here's my problem:

I'm trying to create a transaction in my Windows 2000 .Net application which
executes a SQL statement and commits or aborts based on that statement's
success or failure. I'm getting this error message: Exception Details:
System.ApplicationException: Exception from HRESULT: 0x8004D00E. In the
past when my SQL machine was running Windows 2000, I was able to fix this by
enabling NetBIOS on that machine. This solution no longer works now that
I'm running Windows 2003. Any suggestions? TIA.

Paul

Florin Lazar [MSFT]
10/21/2003 12:15:35 PM

Hi Paul,

The two machines are running in a domain?

Regards,
--
Florin Lazar - Microsoft

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Florin Lazar [MSFT]
10/21/2003 1:38:45 PM

Paul,

Did you enable network transactions on W2K3 server using Component Services
UI? By default they are off.

Regards,

--
Florin Lazar - Microsoft

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Yes, both machines are on the same domain.

Paul

Paul Crowder
10/21/2003 4:01:46 PM

[quoted text, click to view]

Yes, both machines are on the same domain.

Paul

Paul Crowder
10/22/2003 4:44:50 PM

[quoted text, click to view]

Yes, I've turned it on. The odd thing is, there's another person in the
office running Windows 2000 that has the same problem as mine, and another
running Windows 2000 who is having no problem at all. I'm beginning to
think it's a network problem.

Paul

Lars Westholm
10/23/2003 11:08:27 PM

Hi Paul,

We are having exactly the same problem with the same setup. We spent the
whole afternoon trying to figure out what is going on and so far we have
isolated it to "probably" a network problem. Do you have any news?

Lars

[quoted text, click to view]

Pawel Smolarkiewicz
12/10/2003 12:36:43 AM

Seem to be having the same problem as well - I have spent the afternoon and
much of the night looking for a fix. I have tried all the obvious "enable
network transaction" fixes. In my case I am accessing the W2003k Sql server
by its ip, the App server (Win XP) and the Sql server are not on the same
subnet
(thought this may be important) - also they are NOT in a domain - with
transactionOption.Disabled all works fine. The network between the machines
is open, I have tested with the firewall disabled and still experience
the problem. Could it be lookup related, do I need some entries in my
LMHosts files, I havn't tried this yet? Also, when I run the DB on my laptop
(Windows XP) and same subnet as the App Server in this case everything works
fine.

Any ideas?

Thanks,
Pawel

[quoted text, click to view]

Pawel Smolarkiewicz
12/10/2003 1:19:36 PM

POSSIBLE SOLUTION:

I experienced very similar problems (HRESULT: 0x8004D00E when using a remote
SQL Server [on a different subnet, win2k3] and followed similar initial
steps as everyone else (enable Network DTC, check MSDTC security settings,
uninstall/reinstall MSDTC, reboot, ping machines, etc..), ultimately the
solution for me was to add an entry to both server and client's LMHOSTS
files to allow name resolution of each other (MSDTC seems to use the names,
not IP's for routing and my machines were on different subnets, also run
"nbtstat -R" and "nbtstat -c" after updating LMHOSTS to clear and update
name-resolution cache).

FYI, I found the DTCPing.exe utility (available from MS) very helpful to
isolate the problem and configure the firewall between the machines
correctly.

Hope this helps somebody, Cheers,
Pawel

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet component services

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
April 2008
May 2008

home · blog · groups

Questions? Comments? Contact the dn