Windows Server

Heideman · Guest

I'm moving a Commerce 2002 site from one machine to 2 new servers (Win2000
with SQL server and Win2003 as front-end).

SaveAsOrder fails with:
Microsoft OLE DB Provider for SQL Server error '80004005'
Could not connect to datasource

All other components calls is working correct. All calls is from ASP.

As I understand is SaveAsOrder the only component that uses MSDTC. It's is
running.

Any ideeas what to look for ? How to debug ?

Thanks
-JÃ¸rn

Robert Bogue · Guest

There's a utlity DTCPING (available via searching the Ms site) which can
help verify DTC is working.

--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"Heideman" <Heideman@discussions.microsoft.com> wrote in message
news:54270B6F-8E55-4143-BE64-0EA68728155C@microsoft.com...

JÃ¸rn Heideman · Guest

Thanks - The DTCPING returned ok from the SQLserver but from the front-end
server it responded with:

++++++++++++Validating Remote Computer Name++++++++++++
Please refer to following log file for details:
c:\dtcping\SERV232464.log
Error(0x2AFC) at nameping.cpp @62
-->gethostbyaddr
-->183(Cannot create a file when that file already exists.)
Invoking RPC method on SERV24
Problem:fail to invoke remote RPC method
Error(0x6D9) at dtcping.cpp @289
-->RPC pinging exception
-->1753(There are no more endpoints available from the endpoint mapper.)
RPC test failed

I guess that it's a network security problem - what to do ?

-JÃ¸rn

Robert Bogue · Guest

The article that you got DTC ping from should talk about RPC port shifting,
and the other details that need to be worked out to make DTC work.
Basically, most firewalls need to know what ports to use, RPC uses a random
set of ports. The KB article will tell you how to lock those down so you
can tell the firewall that they're OK.

Rob

--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"Jørn Heideman" <JrnHeideman@discussions.microsoft.com> wrote in message
news:A7A07184-D7A9-4DBC-8C23-DDA6F767B8A2@microsoft.com...

JÃ¸rn Heideman · Guest

I tryed the DTCPING util - after solwing som DNS issues, the test succeced.
So I guess that the WINDTC is working correct.

I don't understand the error - SaveAsOrder is called after both
Basket.Initialize
and Basket.LoadBasket(). If I change to SaveAsBasket it's world fine.

Any more ideas?
-JÃ¸rn

Robert Bogue · Guest

Sorry, I don't undestand. I'd say 90% of the problems with SaveAsOrder are
resolved with fixing DTC. If you're on Windows 2003 you have to make sure
Network DTC is enabled in Add/Remove programs but that's the only other
thing I can think of.

--
Robert Bogue
Microsoft MVP Server-Networking
MCSE(NT4), MCSE (W2K), MCSA:Security (W2K), CNA, A+, Network+, IT Project+,
Server+, Security+, CDIA+, E-Biz+
Crowe Chizek and Co LLC
"Jørn Heideman" <JrnHeideman@discussions.microsoft.com> wrote in message
news:CBA4C3D1-A473-4C28-991A-47CF1E2AAA61@microsoft.com...

JÃ¸rn Heideman · Guest

Hi Robert

You are the best !! It was enabling the Network DTC.

Come to Denmark and I will buy you a beer :-)

Best Regards
-JÃ¸rn

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1