|
Home > Archive > Commerce Server General > March 2005 > CS2000 with SQL Server on Windows 2003
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
CS2000 with SQL Server on Windows 2003
|
|
| Jose Motta 2005-03-21, 7:47 am |
| Hi,
I moved a Commerce Server 2000 retail site that was installed on two boxes
(Web and SQL Servers) based on Windows 2000 to a new environment with Windows
2000 Web Server and SQL on a Windows 2003 Server. Everything works fine
concerning store and bizdesk for basic store navigation, catalog editing,
pack and unpacking sites. The only problem is that checkout pipeline was
supposed to run after sale confirmation in summary.asp.
DTS Transaction Statistics in the Web Server (Component Services MMC)
increases the aborted transaction counter everytime a sale is confirmed.
Component Checker 2.0 shows MDAC 2.8 RTM (2.80.1022.0) at both servers. Three
mismatched files are reported:
BCP for ODBC (ODBCBCP.DLL) and SQL ODBC Driver (SQLSRV32.DLL): expected
2000.85.1022.0, version 2000.085.1025.00;
MSXML 3.0 SP5 (MSXML3.DLL): expected 8.40.9419.0, version 8.50.2162.0.
I noticed then the incompatibility issues for CS2000 and Windows Server
2003. Is this true also for Windows 2000 Web Server with SQL Server box using
WIndows Server 2003? Is there any fix? Please comment.
Regards,
Jose
| |
| WenJun Zhang[msft] 2005-03-22, 7:47 am |
| Hi Jose,
CS2K doesn't support to be installed on Win2K3 but there is no
document states it cannot utilize the SQL db on Win2K3. So I believe
your deployment should be workable.
For the problem, I believe what you meant is DTC Transaction
Statistics instead of SQL DTS, right? A general thought of mine is
that network DTC is disabled by default on Windows 2003. Please check
if enabling it will resolve the problem:
On the Win2003 box, open component service->expand to My Computer and
open its property. In MSDTC, click Transaction
configuration->Security configuration, enable Network DTC Access,
Network Administration ,Network Transactions.
If this above doesn't help, another suggestion is you can enable
Commerce pipeline logging to trace if there is any detailed error
message.
296245 How To Enable Pipeline Logging in Commerce Server
http://support.microsoft.com/?id=296245
Thanks.
Best regards,
WenJun Zhang
Microsoft Online Partner Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
| |
| J Motta 2005-03-23, 2:47 am |
| Thanks for your email. Everything is fine now. DTC Transaction Statistics now
shows committed transactions! I almost give up and was so near. Thanks again.
Best regards,
Jose
PS: At SQL Server box there are only two modules (Analysis&DataWarehouse and
DirectMail) installed at CS2000 setup. They work fine with Windows 2003.
| |
| WenJun Zhang[msft] 2005-03-23, 2:47 am |
| Jose,
My pleasure to have been some help. If you meet any Commerce issue in
future, please don't hesitate to post here. Thanks.
Best regards,
WenJun Zhang
Microsoft Online Partner Support
This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
|