|
Home > Archive > Commerce Server General > May 2004 > CS2K2 on WIN2K3
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]
|
|
|
| hi!
we would like to upgrade our current configuration (WEB and SQL Server are running on 2 Windows 2000 Advanced Server, CS2002, .NET Framework 1.0)
to
Windows 2003 EE CS2002 SP2 (only webserver, sql server will stay on win2000)
using .NET Framework 1.0
i cloned the sql server and webserver from production to local servers
so i have 1 win2000 server latest patches with sql server 2000 sp3
and 1 win2000 server latest patches with commerce server 2002 (no sp)
upgrade of webserver to win2003 was quite smooth, after that i installed sp2 of commerce server 2002
first thing which does not work:
i cannot access the commerce site with commerce server manager
("could not connect to the commerce server administration database. verify that the administration database connection string is correct.....) when i try to do this, i see the modify button, clicking on it doesnt do anything
and why should it be incorrect now ?
i'm not quite clear about what sql scripts have to be run and against which databases
i ran the EnableCS2002Settings.vbs but that didnt help
i read in commerceserver install documentation for win2003 that i should add IIS_WPG to sql server - that user does not exist, where should it come from ??
thanks for any help in advance
dietmar
| |
| Andy Xu[MSFT] 2004-05-06, 3:35 am |
| Hi, there,
Thanks for using commerce server newsgroup. You said: "i read in commerceserver install documentation for win2003 that i should add IIS_WPG to sql server - that user does not
exist, where should it come from ??"
I think that's exactly the problem. Windows 2003 (in your deployment, the web server) uses IIS6, which introduces the idea of application pool. Your commerce site will connect to
commerce databases using application pool identity (unless you use SQL auth instead of Windows auth. based on your description, it is not the case). So basically what you need to
do is to grant web server's application pool identity permission to connect to commerce databases in your sql server.
IIS_WPG is a group defined in windows 2003 for worker process group.
HTH,
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
Thread-Topic: CS2K2 on WIN2K3
thread-index: AcQxwM5RCJBr+QbYTJSDcN79SHGzyw==
X-WN-Post: microsoft.public.commerceserver.general
From: "=?Utf-8?B?ZGlnaQ==?=" <anonymous@discussions.microsoft.com>
Subject: CS2K2 on WIN2K3
Date: Tue, 4 May 2004 03:16:03 -0700
Lines: 33
Message-ID: <80FC5F3B-7953-4ECC-9382-F4005AB1C083@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13727
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.commerceserver.general
hi!
we would like to upgrade our current configuration (WEB and SQL Server are running on 2 Windows 2000 Advanced Server, CS2002, .NET Framework 1.0)
to
Windows 2003 EE CS2002 SP2 (only webserver, sql server will stay on win2000)
using .NET Framework 1.0
i cloned the sql server and webserver from production to local servers
so i have 1 win2000 server latest patches with sql server 2000 sp3
and 1 win2000 server latest patches with commerce server 2002 (no sp)
upgrade of webserver to win2003 was quite smooth, after that i installed sp2 of commerce server 2002
first thing which does not work:
i cannot access the commerce site with commerce server manager
("could not connect to the commerce server administration database. verify that the administration database connection string is correct.....) when i try to do this, i see the
modify button, clicking on it doesnt do anything
and why should it be incorrect now ?
i'm not quite clear about what sql scripts have to be run and against which databases
i ran the EnableCS2002Settings.vbs but that didnt help
i read in commerceserver install documentation for win2003 that i should add IIS_WPG to sql server - that user does not exist, where should it come from ??
thanks for any help in advance
dietmar
| |
|
| seems like that was not the problem, i installed the hotfix for kb838405 and those errors were gone
however, still having problems, or more of a dilemma
right now i have this configuration:
sql on win2000 latest sp (we are using sql auth)
web on win2003 latest hotfixes and kb838405 hotfix with commerce server 2002 sp2
the shop application is developed with vs2002 .net 1.0
on the win2003 testserver the application * starts * in both iis modes (iis5 isolation mode and iis6 native mode)
here's my dilemma - i want to use iis6 native mode (for assigning different application pools to different cpu's)
iis6 native mode does not support .net 1.0 - iis5 isolation mode has no application pool
running the app in iis6 native mode works fine till i get to add a item to the basket
Basket.Save does not work anymore, it throws that exception:
System.ArgumentException: XML variant datatype not supported
at Microsoft.CommerceServer.Interop.Orders.DBStorageClass.CommitData(Object
vtReserved, Object pdispData)
the app runs under 1.1 on the win2003 machine - do i have to compile it with vs2003 and 1.1 framework to get it working ?
or where is that error coming from?
also, when first starting the app, i have 100% cpu load, over a long period any ideas ?
thanks
digi
| |
| Andy Xu[MSFT] 2004-05-11, 8:20 pm |
| Digi,
CS2002 is not fully-tested, thus garanteed to run probelm-free on Windows 2003. Looks like in your case, you probably want to download Commerce Server 2002, SP2 to run it on
Windows 2003 (my bad that i didn't point it out in last post). Here is the url: http://www.microsoft.com/downloads/...cc3e-4846-8ef7-
264e6eeb4c1e&DisplayLang=en
As of the perfermonce issues during start up, did you happen to run performance monitor during the start up on the web server? any extra stuff (eg. cache, pipeline, etc) you specified
in your web.config?
HTH,
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
Thread-Topic: CS2K2 on WIN2K3
thread-index: AcQ0JhUcEN3hjgthQDuD09rCxzQyJA==
X-WN-Post: microsoft.public.commerceserver.general
From: "=?Utf-8?B?ZGlnaQ==?=" <digi@newsgroups.nospam>
References: <80FC5F3B-7953-4ECC-9382-F4005AB1C083@microsoft.com> <f7AsyozMEHA.3316@cpmsftngxa10.phx.gbl>
Subject: RE: CS2K2 on WIN2K3
Date: Fri, 7 May 2004 04:26:04 -0700
Lines: 34
Message-ID: <D5A49A25-3C44-4C4B-BDC7-FEA87CE8C999@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13749
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.commerceserver.general
seems like that was not the problem, i installed the hotfix for kb838405 and those errors were gone
however, still having problems, or more of a dilemma
right now i have this configuration:
sql on win2000 latest sp (we are using sql auth)
web on win2003 latest hotfixes and kb838405 hotfix with commerce server 2002 sp2
the shop application is developed with vs2002 .net 1.0
on the win2003 testserver the application * starts * in both iis modes (iis5 isolation mode and iis6 native mode)
here's my dilemma - i want to use iis6 native mode (for assigning different application pools to different cpu's)
iis6 native mode does not support .net 1.0 - iis5 isolation mode has no application pool
running the app in iis6 native mode works fine till i get to add a item to the basket
Basket.Save does not work anymore, it throws that exception:
System.ArgumentException: XML variant datatype not supported
at Microsoft.CommerceServer.Interop.Orders.DBStorageClass.CommitData(Object
vtReserved, Object pdispData)
the app runs under 1.1 on the win2003 machine - do i have to compile it with vs2003 and 1.1 framework to get it working ?
or where is that error coming from?
also, when first starting the app, i have 100% cpu load, over a long period any ideas ?
thanks
digi
| |
|
| andy,
as i wrote in both posts, SP2 for commerceserver 2002 were installed (successfully)
the performance issue is not that urgent right now - after hitting refresh 3 times the shop starts fine. had the same thing on win2000, since its only a test/upgrade machine, i leave that beside right now.
so, any ideas on what to do to get that thing running on win2003 ?
thanks
digi
----- Andy Xu[MSFT] wrote: -----
Digi,
CS2002 is not fully-tested, thus garanteed to run probelm-free on Windows 2003. Looks like in your case, you probably want to download Commerce Server 2002, SP2 to run it on
Windows 2003 (my bad that i didn't point it out in last post). Here is the url: http://www.microsoft.com/downloads/...cc3e-4846-8ef7-
264e6eeb4c1e&DisplayLang=en
As of the perfermonce issues during start up, did you happen to run performance monitor during the start up on the web server? any extra stuff (eg. cache, pipeline, etc) you specified
in your web.config?
HTH,
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
Thread-Topic: CS2K2 on WIN2K3
thread-index: AcQ0JhUcEN3hjgthQDuD09rCxzQyJA==
X-WN-Post: microsoft.public.commerceserver.general
From: "=?Utf-8?B?ZGlnaQ==?=" <digi@newsgroups.nospam>
References: <80FC5F3B-7953-4ECC-9382-F4005AB1C083@microsoft.com><f7AsyozMEHA.3316@cpmsftngxa10.phx.gbl>
Subject: RE: CS2K2 on WIN2K3
Date: Fri, 7 May 2004 04:26:04 -0700
Lines: 34
Message-ID: <D5A49A25-3C44-4C4B-BDC7-FEA87CE8C999@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13749
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.commerceserver.general
seems like that was not the problem, i installed the hotfix for kb838405 and those errors were gone
however, still having problems, or more of a dilemma
right now i have this configuration:
sql on win2000 latest sp (we are using sql auth)
web on win2003 latest hotfixes and kb838405 hotfix with commerce server 2002 sp2
the shop application is developed with vs2002 .net 1.0
on the win2003 testserver the application * starts * in both iis modes (iis5 isolation mode and iis6 native mode)
here's my dilemma - i want to use iis6 native mode (for assigning different application pools to different cpu's)
iis6 native mode does not support .net 1.0 - iis5 isolation mode has no application pool
running the app in iis6 native mode works fine till i get to add a item to the basket
Basket.Save does not work anymore, it throws that exception:
System.ArgumentException: XML variant datatype not supported
at Microsoft.CommerceServer.Interop.Orders.DBStorageClass.CommitData(Object
vtReserved, Object pdispData)
the app runs under 1.1 on the win2003 machine - do i have to compile it with vs2003 and 1.1 framework to get it working ?
or where is that error coming from?
also, when first starting the app, i have 100% cpu load, over a long period any ideas ?
thanks
digi
| |
| Andy Xu[MSFT] 2004-05-18, 5:47 pm |
| Digi,
Sorry for the delay -- I was on vacation the whole last week......
My bad that i didn't notice you mention sp2 already installed. Now after i went through all posts in this thread, let me recap:
you have web server with Win2003, .net 1.0, running under IIS 5 isoluation mode. app codes are developed and built with .net framework 1.1.
and you have sql server with Windows 2000. correct?
The first thing I would do is either install .net framework 1.1 on your web server (or rebuild your app with .net fx 1.0. but definitely former is better choice). The error itself looks like
happening in interop call so my guess would be either some marshalling issue or in COM world, the type passed in is not supported. But either way, the different version of .net
framework seems to be the reason.
If it is convenient for you, i suggest that you do the above thing and we will investigate further if same issue remains.
HTH,
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
Thread-Topic: CS2K2 on WIN2K3
thread-index: AcQ2XI9it/gcSqUBQTi+MZeIThfifw==
X-WN-Post: microsoft.public.commerceserver.general
From: "=?Utf-8?B?ZGlnaQ==?=" <digi@newsgroups.nospam>
References: <80FC5F3B-7953-4ECC-9382-F4005AB1C083@microsoft.com> <f7AsyozMEHA.3316@cpmsftngxa10.phx.gbl> <D5A49A25-3C44-4C4B-BDC7-FEA87CE8C999
@microsoft.com> <RXV7bgHNEHA.1456@cpmsftngxa10.phx.gbl>
Subject: RE: CS2K2 on WIN2K3
Date: Mon, 10 May 2004 00:01:04 -0700
Lines: 91
Message-ID: <B1C3542D-5EDC-4B0A-9406-8F3F9FCDFF45@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13763
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.commerceserver.general
andy,
as i wrote in both posts, SP2 for commerceserver 2002 were installed (successfully)
the performance issue is not that urgent right now - after hitting refresh 3 times the shop starts fine. had the same thing on win2000, since its only a test/upgrade machine, i
leave that beside right now.
so, any ideas on what to do to get that thing running on win2003 ?
thanks
digi
----- Andy Xu[MSFT] wrote: -----
Digi,
CS2002 is not fully-tested, thus garanteed to run probelm-free on Windows 2003. Looks like in your case, you probably want to download Commerce Server 2002, SP2 to
run it on
Windows 2003 (my bad that i didn't point it out in last post). Here is the url: http://www.microsoft.com/downloads/...cc3e-4846-8ef7-
264e6eeb4c1e&DisplayLang=en
As of the perfermonce issues during start up, did you happen to run performance monitor during the start up on the web server? any extra stuff (eg. cache, pipeline, etc) you
specified
in your web.config?
HTH,
Andy Xu [MSFT]
Commerce Server Team
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
--------------------
Thread-Topic: CS2K2 on WIN2K3
thread-index: AcQ0JhUcEN3hjgthQDuD09rCxzQyJA==
X-WN-Post: microsoft.public.commerceserver.general
From: "=?Utf-8?B?ZGlnaQ==?=" <digi@newsgroups.nospam>
References: <80FC5F3B-7953-4ECC-9382-F4005AB1C083@microsoft.com><f7AsyozMEHA.3316@cpmsftngxa10.phx.gbl>
Subject: RE: CS2K2 on WIN2K3
Date: Fri, 7 May 2004 04:26:04 -0700
Lines: 34
Message-ID: <D5A49A25-3C44-4C4B-BDC7-FEA87CE8C999@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.general
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.commerceserver.general:13749
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.commerceserver.general
seems like that was not the problem, i installed the hotfix for kb838405 and those errors were gone
however, still having problems, or more of a dilemma
right now i have this configuration:
sql on win2000 latest sp (we are using sql auth)
web on win2003 latest hotfixes and kb838405 hotfix with commerce server 2002 sp2
the shop application is developed with vs2002 .net 1.0
on the win2003 testserver the application * starts * in both iis modes (iis5 isolation mode and iis6 native mode)
here's my dilemma - i want to use iis6 native mode (for assigning different application pools to different cpu's)
iis6 native mode does not support .net 1.0 - iis5 isolation mode has no application pool
running the app in iis6 native mode works fine till i get to add a item to the basket
Basket.Save does not work anymore, it throws that exception:
System.ArgumentException: XML variant datatype not supported
at Microsoft.CommerceServer.Interop.Orders.DBStorageClass.CommitData(Object
vtReserved, Object pdispData)
the app runs under 1.1 on the win2003 machine - do i have to compile it with vs2003 and 1.1 framework to get it working ?
or where is that error coming from?
also, when first starting the app, i have 100% cpu load, over a long period any ideas ?
thanks
digi
|
|
|
|
|