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

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.

MORE INFORMATION

Steps to Reproduce Behavior

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