Microsoft KB Archive/314281

= PRB: Error When You Add Server to Application That You Unpupped Before You Installed Commerce Server 2000 SP2 =

Article ID: 314281

Article Last Modified on 10/17/2002

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-



This article was previously published under Q314281



SYMPTOMS
When you try to add a second server to an application that you unpupped before you installed Commerce Server 2000 Service Pack 2 (SP2), you receive the following error message:

The IIS configuration on this computer does not match the settings on the Commerce Server application, BlankSite, to which you are adding a web server.

The Commerce Server application uses Web site instance number 0[1-9], which does not exist on this computer. You must create an IIS Web site with this instance number to add this computer as a web server in this Commerce Server application.

NOTE: This error only occurs on the second site, not on the first site, the third site, or other sites.



CAUSE
If you write a 0-9 Web site instance number into the Admin database, Commerce Server 2000 SP1 or earlier writes a zero (0) in front of the value.

Commerce Server 2000 SP2 fixes this problem by removing the code that cleans this up while Commerce Server reads the data. However, to fix a problem with different locals, Commerce Server 2000 SP2 does not fix the values that already exist in the database.



RESOLUTION
To work around this problem, clean up the values in the Admin database as follows:  From the Windows Start menu, point to Programs, point to Microsoft SQL Server, and then click Query Analyzer. In the Connect to SQL Server dialog box, in the drop-down list, select the SQL Server with which you want to connect. In the Connect using section, type the required authentication information, and then click OK.  Add the following code to the query window: UPDATE   ResourceProps SET             s_Value = SUBSTRING(s_Value, 2, 3) WHERE    (s_Value LIKE '0[0-9]#^') AND (s_PropertyName IN ('s_WebServerInstance', 's_LogType', 's_LogFilePeriod'))  On the SQL Query Analyzer toolbar, in the Database drop-down list, select the Admin database for the site. On the Query menu, click Execute.

<div class="status_section">

STATUS
This behavior is by design.

<div class="moreinformation_section">

Steps to Reproduce Behavior

 * 1) Install Commerce Server 2000 or Commerce Server 2000 SP1.
 * 2) Unpup a site.
 * 3) Install Commerce Server 2000 SP2.
 * 4) Add a Web server to the site that you unpupped in step 2.

Additional query words: unpup'ed

Keywords: kbprb KB314281

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.