I am going crazy!
I have a .Net serviced component that connects to a sql server. When I
run the component on my development PC (with local SQL-server),
everything works fine. DTC enlists the transaction and results are
returned.
When I connect to another database on the network I get the error
(0x8004D00E): The transaction has already been implicitly or
explicitly committed or aborted
I have tried everything suggested on the Web but nothing so far. When
I try this on another PC (local component, network sql server) it also
works fine.
This is what I Have already tried:
- Checked if DTC is running on both servers
- Checked if component and sql are running under correct user
- Checked if network transactions are enabled in DTC
- Stopped SQL Server and DTC on both machines and then restarted
(first DTC)
- Uninstall SQl Server on my PC (you never know)
- Check the settings in the registry
- Compared my settings to the settings on the working PC
- Viewed the TCP connection with TCPView.exe
(result : msdtc.exe:1372 TCP MYPC:1026 MYPC:0 LISTENING)
I am running Windows XP SP 2, Remote SQL Server is running Windows
2003 and I am out of ideas.
Searching on the internet it seems that there are a lot of people out
there who have faced this problem so there's got to be somebody with
the answer....
Please help
Evelyn
Marc Nemegeer - 29 Oct 2004 13:47 GMT
Hi,
W2003 with application roles ?? And which ones ??
Marc
> I am going crazy!
> I have a .Net serviced component that connects to a sql server. When I
[quoted text clipped - 31 lines]
>
> Evelyn
grundig - 01 Nov 2004 15:52 GMT
Already got it.....
Something was wrong with the distribution of our ip-adresses. Server
could not resolve client name......
Thanks anyway!