Here’s an obscure fact for you if you’re still running Commerce Server 2000. Recently we needed to upgrade our database server which is running on Windows Server 2003 to Windows Server 2003 SP1. Now SP1 introduces some new security aspects for MSDTC which means that requests can be authenticated. Unfortunately for Commerce Server 2000 the default setting is to authenticate everything which renders CS unable to connect to its data store. The symptom of this is varied: I’ve experienced both a direct error from MSDTC and a non responding web site and, the former is easily diagnosed the latter is not.
The solution to this mess is the following:
Through Run in the start menu bring up dcomcnfg.
Expanded the Component Services / Computers nodes.
Right-click My Computer and choose Properties.
Click the MSDTC tab.
Click the Security Configuration Button.
Check the Network DTC Access.
Set No Authentication Required.