Removing WSS 3.0 Companyweb Upgrade - Restoring WSS 2.0 on SBS 2003

These steps are to be followed if the Companyweb site has been upgraded to WSS 3.0. It is ok to install WSS 3.0 on SBS 2003, but must be installed using a "side by side" installation. For more information please refer to the SBS whitepaper https://www.microsoft.com/downloads/details.aspx?FamilyID=0daafc81-efff-4f5b-a28a-8265f1e99f5b&displaylang=en

How to determine if WSS 3.0 has been installed?

1. Under Add/Remove Programs you may see an object called Windows Sharepoint Services 3.0

2. The WSS 3.0 installation creates a folder under Program Files\Common Files\Microsoft Shared\Web Server Extensions\12

How to determine if Companyweb has been upgraded?

1. Open IIS, select the Websites folder, Browse SharePoint Central Administration, select configure virtual server settings, Companyweb will return version 12.0.0.4518 or greater - Not Administrable.

2. Open IIS, select the Websites folder, if Sharepoint has been upgraded you will may see a second instance of SharePoint Central Administration called SharePoint Central Administration v3.

3. Browse SharePoint Central Administration v3, select application management tab, select web application list, companyweb will show in the list.

Prerequesites:

Must have copies of the SharePoint databases BEFORE the upgrade to WSS 3.0 took place.

WSS 2.0 Database Files needed for the restore:

STS_<servername>_1.mdf

STS_<servername>_Log_1.ldf

STS_Config.mdf

STS_Config_Log.ldf

Default Path for the SharePoint databases on SBS 2003:

C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\Data

=============================================================================

Uninstall the Windows Small Business Server 2003 Intranet component

1. Click Start, click Control Panel, and then click Add or Remove Programs.

2. Select Windows Small Business Server 2003, and then click Change/Remove. The Setup Wizard appears.

3. Click Next to start the wizard.

4. On the Windows Configuration page, click Next.

5. On the Component Selection page, in the Action column, change Server Tools to Maintenance, change Intranet component to Remove, and then click Next.

6. On the Component Summary page, click Next.

7. Click Finish.

back to the top

Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) and Windows SharePoint Services 3.0

1. In Add or Remove Programs, select Microsoft SQL Server Desktop Engine (SHAREPOINT), and then click Remove.

2. Click Yes when you are prompted to confirm.

3. If Microsoft Windows SharePoint Services 2.0 appears in the list of currently installed programs, select this program, and then click Remove.

4. Click Yes when you are prompted to confirm.

back to the top

Uninstall Windows SharePoint Services 3.0

1. In Add or Remove Programs, select SharePoint Services 3.0 , and then click Remove.

2. Click Yes when you are prompted to confirm.

Delete the companyweb and SharePoint Central Administration Web sites

1. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

2. In IIS Manager, expand servername , and then expand Web Sites.

3. Under Web Sites, right-click SharePoint Central Administration, and then click Delete.

Note Do not delete the Microsoft SharePoint Administration Web site because this site is part of the FrontPage Server Extensions component.

4. Click Yes when you are prompted to confirm.

5. Under Web Sites, right-click companyweb, and then click Delete.

Note: The Companyweb site may not appear in IIS. If the website is missing it was removed during the SharePoint Services 3.0 uninstall.

Move on to the next step

6. Click Yes when you are prompted to confirm.

Delete the Application Pool

1. In IIS Manager, expand servername , and then expand Application Pools.

2. Right-click StsAdminAppPool, and then click Delete.

3. Click Yes when you are prompted to confirm.

4. If any other StsAdmin application pools exist, delete these too. For example, if there is an application pool named StsAdminAppPool1, delete it.

Note Do not delete MSSharePointAppPool because this application pool is part of the FrontPage Server Extensions component.

back to the top

Rename the Sharepoint and companyweb folders

1. Start Windows Explorer, and then find the MSSQL$SHAREPOINT folder. By default, this folder is in the following location:

C:\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT

2. Right-click the MSSQL$SHAREPOINT folder, and then click Rename.

3. Rename the folder to MSSQL$SHAREPOINT.old, and then press ENTER.

4. Find the companyweb folder. By default, this folder is in the following location:

C:\Inetpub\companyweb

5. Right-click the companyweb folder, and then click Rename.

6. Rename the folder to companyweb.old, and then press ENTER.

back to the top

Delete the registry keys for the Intranet component

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

1. Determine the Web site identifiers for all the Web sites that are configured in IIS. To do this, follow these steps:

a. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

b. In IIS Manager, expand servername , and then click Web Sites.

c. In the right pane, examine the Identifier column for all the Web sites that are configured, and write these values down.

2. Start Registry Editor.

3. Backup and then delete the following subkeys: • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\SHAREPOINT

• HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Intranet

To back up a registry key, right-click the key, and then click Export. To delete a registry key, right-click the key, click Delete, and then click Yes to confirm.

4. Expand the following subkey:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\Ports

Under Ports, you will see one or more subkeys named Port /LM/W3SVC/ n :. In the subkey name, n is an identifier for a SharePoint or FrontPage Server Extensions-enabled Web site.

For example, if the Default Web Site is extended with the FrontPage Server Extensions, and the Default Web Site identifier is 1, you will see a subkey named Port /LM/W3SVC/1:.

5. Delete any subkey under Ports that does not correspond to one of the Web site identifiers that you wrote down in step 1c.

For example, if a subkey named Port /LM/W3SVC/3: exists, but no Web site is configured with this identifier in IIS, delete the Port /LM/W3SVC/3: subkey.

Note In a typical Windows Small Business Server 2003 installation, the companyweb site uses 4 as its identifier in IIS. If the Windows Small Business Server 2003 Intranet component could not be installed, there may be a Port /LM/W3SVC/4: subkey left over from the failed installation, even if the companyweb site was not created.

Change the TCP port for the Symantec Mail Security for Microsoft Exchange Web site

If the server is running Symantec Mail Security for Microsoft Exchange 4.5, you must change the TCP port for the Mail Security Web site before you reinstall the Windows Small Business Server Intranet component. This is because the Mail Security Web site uses TCP port 8081 by default. This TCP port is the same port that the SharePoint Central Administration Web site uses.

Important Do not use the IIS Manager snap-in to change the TCP port for the Mail Security Web site. Doing this may cause the Mail Security program to stop working. Instead, install the Symantec Mail Security for Microsoft Exchange console, and then use this console to change the TCP port for the Web site.

For information about installing the Symantec Mail Security for Microsoft Exchange console, see the how-to topic titled "To install the Symantec Mail Security for Microsoft Exchange console" in the Symantec Mail Security for Microsoft Exchange Help.

For information about changing the TCP port, see the how-to topic titled "To change the TCP port and use SSL" in the Symantec Mail Security for Microsoft Exchange Help.

Install the Windows SharePoint Services companyweb

Determine whether your copy of Windows Small Business Server 2003 Disk 3 is an original copy or an updated copy

Original copies of Windows Small Business Server 2003 Disk 3 contain a DLL with an expired digital certificate. Therefore, when you install Windows Small Business Server 2003 with an original Disk 3, the Intranet component does not install successfully. To determine whether your copy of Windows Small Business Server 2003 Disk 3 is an original copy or an updated copy, follow these steps:

1. Load Windows Small Business Server 2003 Disk 3 in the CD drive.

2. Open Drive :\SBS\CLIENTAPPS\SHAREPT. In this path name, Drive is the drive letter for the CD drive.

3. In the SHAREPT folder, open the Sts.cab file, and then extract the Sqmcfg.dll file to the hard disk drive. The Sts.cab file is a hidden file, and you will have to enable the Show hidden files and folders setting in Folder Options, if this setting is not enabled already.

4. Open the folder where you extracted the Sqmcfg.dll file, right-click Sqmcfg.dll, and then click Properties.

5. Click the Digital Signatures tab.

6. Click to select the digital signature, click Details, and then click View Certificate.

7. On the General tab, find the valid to date.

If the valid to date is 11/24/2003, you have an original copy of Disk 3. If the valid to date is 11/24/2009 or a later date, you have an updated copy of Disk 3.

If you have an original copy of Disk 3, you can still use this disk for the installation. However, after the Windows Small Business Server 2003 Setup program has finished running, you will have to install the 832880 update.

For more information about the 832880 update, click the following article number to view the article in the Microsoft Knowledge Base:

832880 You cannot successfully install the intranet component or connect to https://companyweb in Windows Small Business Server 2003

back to the top

Install the Intranet component

1. Click Start, point to Control Panel, and then click Add or Remove Programs.

2. In the Currently installed programs list, click Microsoft Windows Small Business Server 2003, and then click Change/Remove.

3. In the Microsoft Windows Small Business Server Setup Wizard, click Next repeatedly until the Component Selection page is displayed.

4. In the Server Tools list, click Maintenance.

5. In the Intranet list, click Install.

6. At the Logon Information screen, click Log on automatically, and then type your password for the user account that you currently are logged on with. Your password is temporarily stored until the Setup process is completed or canceled.

7. Click Next, and then follow the instructions that appear on the screen to complete the installation of the Intranet component. Realize that if you are using an original copy of Windows Small Business Server 2003 Disk 3, you will receive the following error message on the Component Summary page:

An error occurred while installing Windows SharePoint Services and creating your Intranet site.

This message is expected when you are using an original Disk 3.

8. On the Component Summary page, click Next, and then click Finish.

9. Restart the server when you are prompted.

10. If you are using an original Disk 3, install the 832880 update after the restart. For additional information about this update, visit the following Web site:

https://go.microsoft.com/fwlink/?LinkId=21951

11. Visit the companyweb Web site (https://companyweb) to verify that you can access the site.

12. If you have to restore the companyweb databases, these database files are located in the MSSQL$SHAREPOINT.old folder.

For more information about restoring the companyweb databases after reinstalling the Windows Small Business Server 2003 Intranet component, click the following article number to view the article in the Microsoft Knowledge Base:

Finish the Intranet installation

After the Intranet component has been successfully installed,

Verify that the CompanyWeb intranet site (https://companyweb) is accessible.

1. If you must restore any additions that were made to the default Windows SharePoint Services services, you must use Microsoft Internet Information Server (IIS) to re-create any additional top-level Web sites that were not included in the top-level Windows SharePoint Services site of the CompanyWeb virtual server that existed on the previous server.

2. Stop the MSSQL$SharePoint and the SharePoint Timer services: a. Click Start, and then click Run.

b. In the Open box, type cmd, and then click OK.

c. At the command prompt, type net stop mssql$sharepoint , and then press ENTER.

d. Type net stop sptimer , and then press ENTER.

e. To close the command prompt, type exit, and then press ENTER.

3. Stop the companyweb Web site:

a. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

b. In IIS Manager, expand server_name (local computer) , and then expand Web Sites.

c. Under Web Sites, right-click companyweb, and then click Stop.

4. Make a backup copy of the Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder. This is the default installation folder for the Windows SharePoint Services databases.

5. Restore only the following configuration database files and content database files to the Program Files\Microsoft SQL Server\MSSQL$SharePoint\Data folder:

- STS_Config.mdf

- STS_Config_log.ldf

- STS_ ServerName _1.mdf

- STS_ ServerName _1_log.ldf

Note Do not restore any other default files such as the Master.mdf file or the Model.mdf file.

6. If you must restore any additions that were made to the default Windows SharePoint Services services, you must restore the additional content databases that you created to the original data folder where you created them.

For more information about how to back up and how to restore a Windows SharePoint Services CompanyWeb database, click the following article number to view the article in the Microsoft Knowledge Base:

829112 How to back up and restore https://companyweb data in Windows Small Business Server 2003

7. Start the MSSQL$SharePoint and the SharePoint Timer services: a. Click Start, and then click Run.

b. In the Open box, type cmd, and then click OK.

c. At the command prompt, type net start mssql$sharepoint , and then press ENTER.

d. Type net start sptimer , and then press ENTER.

e. To close the Command Prompt window, type exit, and then press ENTER.

Note If you try to access the CompanyWeb intranet site (https://companyweb), any subsites, or any other top-level Windows SharePoint Services site now, you will receive the following error message:

The Web site that is referenced here is not in the configuration database

To resolve this issue, go to step 8.

8. Start the companyweb Web site: a. Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

b. In IIS Manager, expand server_name (local computer) , and then expand Web Sites.

c. Under Web Sites, right-click companyweb, and then click Start.

9. Remove Windows SharePoint Services from CompanyWeb intranet site: a. Click Start, point to Administrative Tools, and then click SharePoint Central Administration (https://localhost:8081).

b. Under Virtual Server Configuration, click Configure virtual server settings.

c. On the Virtual Server List page, click the virtual server that you want to configure. In this example, click the companyweb virtual server.

d. Under Virtual Server Management on the Virtual Server Settings page, click Remove Windows SharePoint Services from Virtual Server.

e. On the Remove Windows SharePoint Services from Virtual Server page, click Remove without deleting content databases.

f. Click OK. You will receive the following error message:

The virtual server that is referenced here is not in the configuration database

10. Extend the CompanyWeb intranet site by using Windows SharePoint Services: a. Click Start, point to Administrative Tools, and then click SharePoint Central Administration (https://localhost:8081).

b. On the Central Administration page under Virtual Server Configuration, click Extend or upgrade virtual server.

c. On the Virtual Server List page, click the name of the virtual server to extend. In this case, click companyweb.

d. On the Extend Virtual Server page under Provisioning Options, select Extend and map to another virtual server.

e. Under Server Mapping, click companyweb.

f. Under Application Pool, click Use an existing application pool, and then click DefaultAppPool (NT AUTHORITY\NETWORK SERVICE).

g. Click OK.

Thanks,

Edwalt