Two computer setup: a database/backend server && iis/frontend server.

SQL Authentication.

SQL Server is not part of a cluster.

CS2002 is installed, SP2 and FP1.

SQL SP3 has been applied, along with a number of Windows 2003 patches.

When I attempt to access the last page of Retail2002 (checkout.aspx),
the pipeline SaveOrderAs() does not save correctly, failing with the
error below.

The checkout pipeline was modified to accomodate an email
confirmation, but the modifications have been removed to fix this
error.

We have been having trouble with the OLAP server, in the department of
name resolution (disk or network error, intermittent) despite the fact
that SQL server resolution is perfect (SP3 OLAP patch has been
applied).

SQL && OLAP have been published in AD.

This is a transaction failure (from all appearances), and we noticed
it just the other day. Any ideas how to track down what exactly the
problem is, or how to fix it?

This:

[COMException (0x8004d00a): New transaction cannot enlist in the
specified transaction coordinator. ]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
String Password, Int32 Options) +0

concerns me, as all the strings have checked out, as well as
permissions (as far as I can tell).

Many thanks,
Ryan


On Fri, 30 Apr 2004 17:48:18 GMT, huanchixonline@microsoft.com (Jason
Xu) wrote:

>Not very clear about your scenario.
>
>If the SQL server is a cluster, the DTC needs to be clustered.
>
>If you are using Windows 2003 server, the DTC "allow network access" is
>disabled by default, so you need enable it on both servers from "add/remove
>windows components".
>
>Regards
>
>huanchixOnline@microsoft.com
>Microsoft Commerce Server Support
>
>This posting is provided "AS IS" with no warranties, and confers no rights.
>You assume all risk for your use. © 2001 Microsoft Corporation. All rights
>reserved.
>
>--------------------
>NNTP-Posting-Date: Fri, 30 Apr 2004 04:19:13 -0500
>From: ryanr@nni.com
>Newsgroups: microsoft.public.commerceserver.general
>Subject: [COMException (0x8004d00a): New transaction cannot enlist in t
he
>specified transaction coordinator. ]
>Date: Fri, 30 Apr 2004 05:20:50 -0400
>Message-ID: <7g64905digos8dgp2fukavj5iquksoms9k@4ax.com>
>X-Newsreader: Forte Free Agent 2.0/32.652
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>Lines: 107
>NNTP-Posting-Host: 66.216.145.22
>X-Trace:
>sv3-WyZ+Y6/ Jf2b+Ihf8LTO4lcFIJnbadzGkr94zZe3aNqjbTXN
fmz6N/B3V8etSxV1+EYVLSXE
k
> v0nJuY4!BlsEm5rjMeIHnvQWJWvwK0+xKllGFnt9
6ajl5i8wFnLRsvlh7wF+fS6kZSxNbq1LdSP
0
>B05fgEpw!YNdS+Y8B5zTJDQ==
>X-Complaints-To: abuse@nni.com
>X-DMCA-Complaints-To: abuse@nni.com
>X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
>X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
>complaint properly
>X-Postfilter: 1.1
>Path:
>cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.
s
>ul.t-online.de!t-online.de!border2.nntp.ash.giganews.com!border1.nntp.ash.g
i
>ganews.com!nntp.giganews.com!local1.nntp.ash.giganews.com!nntp.nni.com!news
.
>nni.com.POSTED!not-for-mail
>Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13702
>X-Tomcat-NG: microsoft.public.commerceserver.general
>
>DTS is enabled on both machines (though I have not created a cluster
>out of them...). Both part of the same domain.
>
>Any ideas?
>Ryan
>
>
>
>Server Error in '/retail2002' Application.
>---------------------------------------------------------------------------
-
>----
>
>New transaction cannot enlist in the specified transaction
>coordinator.
>Description: An unhandled exception occurred during the execution of
>the current web request. Please review the stack trace for more
>information about the error and where it originated in the code.
>
>Exception Details: System.Runtime.InteropServices.COMException: New
>transaction cannot enlist in the specified transaction coordinator.
>
>Source Error:
>
>
>Line 685:
>Line 686:        '
>Line 687:        myPurchaseOrder = txContext.Cart.SaveAsOrder()
>Line 688:
>Line 689:        ' Log the event
>
>
>Source File: C:\Inetpub\wwwroot\retail2002\Checkout.aspx.vb    Line:
>687
>
>Stack Trace:
>
>
>[COMException (0x8004d00a): New transaction cannot enlist in the
>specified transaction coordinator. ]
>   ADODB.ConnectionClass.Open(String ConnectionString, String UserID,
>String Password, Int32 Options) +0
>   Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
>connection_string) +167
>
>[CommerceException: Could not connect to datasource]
>
>Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
>message, Exception inner, String source) +52
>   Microsoft.CommerceServer.Internal.Common.DBUtil.init(String&
>connection_string) +207
>
>Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThr
e
>aded.MtsSetup(String
>in_User, String in_dsn, IGenID in_GenID, Object&
>in_out_OrderGroupData, Int16& in_out_exists_in_databse) +124
>
>Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThr
e
>aded.SaveAsOrderHelper(Object
>in_User, Object in_dsn, Object in_GenID, Object&
>in_out_OrderGroupData, Object& loaded_from, Object&
>in_out_exists_in_databse, Object SavePrefix, Object&
>out_vtOutTrackingNumber) +106
>
>[CommerceException: SaveAsOrderHelper Failed.]
>
>System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage
>reqMsg, IMessage retMsg) +264
>
>System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData&
>msgData, Int32 type) +877
>
>Microsoft.CommerceServer.Interop.Orders.PrivateOrderGroupMtsTxHelperFreeThr
e
>aded.SaveAsOrderHelper(Object
>in_User, Object in_dsn, Object in_GenID, Object&
>in_out_OrderGroupData, Object& loaded_from, Object&
>in_out_exists_in_databse, Object SavePrefix, Object&
>out_vtOutTrackingNumber) +0
>
>Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(
O
>bject&
>vtOutTrackingNumber) +176
>
>[CommerceException: SaveAsOrder Failed.]
>
>Microsoft.CommerceServer.Internal.Common.Util.ThrowCommerceException(String
>message, Exception inner, String source) +52
>
>Microsoft.CommerceServer.Interop.Orders.OrderGroupFreeThreaded.SaveAsOrder(
O
>bject&
>vtOutTrackingNumber) +288
>   Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +241
>
>[CommerceOrderSystemException: Failed to save basket as an order.]
>   Microsoft.CommerceServer.Runtime.Orders.Basket.SaveAsOrder() +530
>   Microsoft.CommerceServer.Site.Checkout.PurchaseBtn_Clicked(Object
>sender, EventArgs e) in
>C:\Inetpub\wwwroot\retail2002\Checkout.aspx.vb:687
>   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
>
>System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaiseP
o
>stBackEvent(String
>eventArgument) +57
>   System.Web.UI.Page. RaisePostBackEvent(IPostBackEventHandler

>sourceControl, String eventArgument) +18
>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
>+33
>   System.Web.UI.Page.ProcessRequestMain() +1247
>
>
>
>
>---------------------------------------------------------------------------
-
>----
>Version Information: Microsoft .NET Framework Version:1.1.4322.573;
>ASP.NET Version:1.1.4322.573

[ Post a follow-up to this message ]