Upgrading the instance of WMSDE used for Windows SharePoint Services (Dutch, Portuguese (Brazil), and Swedish)

Updated: May 27, 2009

Applies To: Windows SBS 2003

Complete the following steps to upgrade the Microsoft SQL Server 2000 Desktop Engine (Windows) (WMSDE) SHAREPOINT instance to full SQL Server 2000.

Note

The information in this document applies only to Windows Small Business Server 2003 with Service Pack 1, Premium Edition.

Note

Before you begin the upgrade, it is recommended that you back up your server.

Note

Before you begin the upgrade, you should also ensure that https://companyweb is not in use. To do so, click Start, and then click Server Management. In the Server Management console pane, double-click Advanced Management, double-click Internet Information Services, double-click ServerName (local computer), and then double-click Websites. Right-click companyweb, and then click Stop.

Remove the SHAREPOINT WMSDE instance

To remove the SHAREPOINT WMSDE instance

  1. Click Start, point to Administrative Tools, and then click Services. Right-click SharePoint Timer Service, and then click Stop.

  2. While still in Services, right-click SharePoint Timer Service, and then click Properties. On the General tab, choose Manual for the Startup Type. Click OK to close Services.

  3. Click Start, point to Control Panel, and then click Add or Remove Programs. Select Microsoft SQL Server Desktop Engine (Sharepoint), and then click Remove. Click Yes to confirm that you want to delete MSDE (SharePoint). You must restart the computer before continuing with the following procedures.

Create a new SHAREPOINT SQL Server 2000 instance

To create a new SHAREPOINT SQL Server 2000 instance

  1. From the Autorun page of the Premium Technologies disc (D:\Setup.exe, where D is the letter of your CD drive), click Install Microsoft SQL Server 2000.

Note

If Windows Small Business Server 2003 was preinstalled on your server, your original equipment manufacturer (OEM) might have created a shortcut on the desktop for installing the Premium Technologies.

  1. When the Winzip Self-Extractor - SQL2000.exe message appears, click Unzip.

  2. When the message appears that the files were unzipped successfully, click OK to continue installing SQL Server 2000.

  3. When a message about SQL Server 2000 SP2 and below appears, click Continue. The issue the message describes is resolved after you install SQL Server 2000 Service Pack 4 (SP4), which you do later in this document.

  4. On the Welcome page, click Next.

  5. On the Computer Name page, accept the default of Local Computer. Click Next.

Note

If you receive the message "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup," you must restart your computer in order to continue setting up SQL Server 2000.

  1. On the Installation Selection page, click Create a new instance of SQL Server, or install Client Tools. Click Next.

  2. On the User Information page, click Next to accept the default information.

  3. On the Software License Agreement page, review the licensing agreement. To continue, you must accept the agreement.

  4. If this is the first instance of SQL Server that you are installing or upgrading, the CD-Key page appears. Enter your Windows Small Business Server 2003 product key, which is found on the back of the disc case. Click Next.

Note

If Windows Small Business Server 2003 was preinstalled on your server, the product key is located on the Certificate of Authenticity (COA). The COA is a multicolored label located on the side or top of your computer.

  1. On the Installation Definition page, accept the default of Server and Client Tools. Click Next.

  2. On the Instance Name page, clear the Default check box if it is checked. In the Instance name box, type SHAREPOINT.Click Next.

Important

You must type the instance name exactly as shown here, or you cannot upgrade the SHAREPOINT WMSDE instance to full SQL Server 2000.

  1. On the Setup Type page, click Typical. Click Next.

  2. On the Services Accounts page, accept the default of Use the same account for each service. Auto start SQL Server service. Under Service Settings, click Use the Local System account. Click Next.

  3. On the Authentication Mode page, accept the default of Windows Authentication Mode. Click Next.

  4. On the Start Copying Files page, click Next to begin installing SQL Server.

  5. On the Setup Complete page, click Finish.

  6. Continue to the next procedure to attach the WMSDE databases to the SHAREPOINT instance of SQL Server.

Attach the WMSDE databases to the SHAREPOINT instance of SQL Server

Note

For this procedure, you need the computer name and the domain of the computer you are upgrading. To locate the computer name and the domain, click Start, click Run, and then type Cmd. At the command prompt, type Set. The name of the server is listed as COMPUTERNAME. The domain is listed as USERDOMAIN.

To attach the WMSDE databases to the SHAREPOINT instance of SQL Server

  1. Verify that the SHAREPOINT SQL Server 2000 instance that you created in the previous procedure is started. To do so, click Start, point to All Programs, point to Microsoft SQL Server, and then click Enterprise Manager to open SQL Server Enterprise Manager. If the SHAREPOINT SQL Server 2000 instance is stopped, right-click ServerName**\SHAREPOINT (Windows NT)**, and then click Start, where ServerName is the name of your server.

  2. Click Start, click Run and then type Cmd.

  3. Type the following command, and then press ENTER:

    osql -E -S Servername\SHAREPOINT

    You must type the -E, and -S parameters as capital letters, because they are case-sensitive, and you must include the space between the parameters. ServerName is the name of the computer running Windows Small Business Server 2003.

  4. Type the following commands, and then press ENTER after each one:

    exec sp_grantlogin 'NT Authority\Network Service'

    exec sp_grantlogin 'DOMAIN\SBS SP Admins'

    go

    You should receive the messages "Granted login access to 'NT Authority\Network Service'" and "Granted login access to 'DOMAIN\SBS SP Admins,'" where DOMAIN is the domain name of your network.

Note

The Network Service account name is translated into your language. Use the Network Service name that is in your language.

  1. Enable osql Advanced Options. To do so, at the command prompt, type each of the following commands and then press ENTER after each one:

    exec sp_configure 'show advanced options', 1

    go

    reconfigure

    go

    You should receive the message “DBCC execution completed.”

  2. Type the following commands, and then press ENTER after each one:

    exec sp_configure 'default full-text language',LanguageCode

    go

    reconfigure

    go

    quit

    You should receive the message “DBCC execution completed.”

    LanguageCode is the code that corresponds to your language. The language code for Dutch is 1043. For Swedish, it is 1053. For Neutral, it is 0. For Portuguese (Brazil), use Neutral because there is no language code for Portuguese (Brazil).

  3. While you are still in SQL Server Enterprise Manager, double-click ServerName**\SHAREPOINT**, right-click Databases, point to All Tasks, and then click Attach database.

  4. In the Attach Database - Servername**\SHAREPOINT** dialog box, click the button that is labeled with an ellipsis (...), which is next to MDF file of database to attach.

  5. Browse for %SystemDrive%\Program Files\Microsoft SQL Server\MSSQL$SHAREPOINT\data\STS_ServerName_1.mdf.

  6. Click OK to attach the database. You should receive a message "Attaching database has completed successfully."

  7. Repeat Steps 7 through 10 to attach the STS_Config.mdf database.

  8. Restart the Windows SharePoint Timer Service by clicking Start, pointing to Administrative Tools, and then clicking Services. Right-click SharePoint Timer, and then click Properties. On the General tab, select Automatic for the Startup Type. Click Start to start the service, and then click OK to close the Services dialog box.

  9. You must now continue to the next procedure to apply SQL Server 2000 SP4 to the SHAREPOINT instance of SQL Server 2000.

Install SQL Server SP4 to the SHAREPOINT instance of SQL Server

To install SQL Server SP4 to the SHAREPOINT instance of SQL Server

  1. From the Autorun page of the Premium Technologies disc (D:\Setup.exe, where D is the letter of your CD drive), click Install SQL Server 2000 Service Pack 4.

Note

When you run SQL Server SP4 Setup, if you receive a message that the Scm.exe file is in use, restart your server, and then begin installing SQL Server SP4.

  1. When the Winzip Self-Extractor - SQL2000_SP4.exe message appears, click Unzip.

  2. When the message appears that the files were unzipped successfully, click OK to continue installing SQL Server SP4.

  3. On the Welcome page, click Next.

  4. On the Software License Agreement page, review the licensing agreement. To continue, you must accept the agreement.

  5. On the Instance Name page, clear the Default check box if it is selected. In the Instance name box, select SHAREPOINT. Click Next.

Note

If you receive one of the following error messages after you select the SHAREPOINT instance on the Instance name page and click Next, you must upgrade the SHAREPOINT WMSDE instance to full SQL Server 2000, and then you must run SQL Server 2000 Service Pack 4 Setup again:

"SHAREPOINT is not a SQL Server 2000 instance. Setup will now exit."

"SQL Server 2000 is not installed on this machine. Setup will now exit."
  1. On the Connect to Server page, accept the default of The Windows account information I use to log on to my computer with (Windows authentication), unless you specified a different authentication mode in the previous procedure. Click Next.

  2. When the message appears telling you that the SA password is blank, it is recommended that you provide a strong password for this account. A strong password is between 6 and 127 characters long, and it uses uppercase and lowercase letters, numbers, and other characters, such as *, ?, and $.

Note

The System Administrator (SA) is a special SQL Server account that is provided for backward compatibility. By default, it is assigned to the Sysadmin Fixed Server role and cannot be changed.

  1. If you receive the Backward Compatibility Checklist message, and you must modify the SQL Server SP4 security enhancements, select the appropriate options. For details about each option, click Help. Click Continue after you have reviewed the security enhancements.

  2. When the Error Reporting message appears, you can select Automatically send fatal error reports to Microsoft, and then click OK.

  3. On the Start Copy Files page, click Next.

  4. When a message appears prompting you to back up your databases, click OK. It is highly recommended that you complete a backup after installing Premium Technologies.

  5. On the Setup Complete page, click Finish. Restart your computer if you are prompted to do so.

  6. Ensure the MSSQL$SHAREPOINT service is started. To do so, click Start, click Run, and then type Services.msc. If the MSSQL$SHAREPOINT service is not started, right-click the service, and then click Start.

Note

If you encounter an error while trying to upgrade the SHAREPOINT instance, ensure that the MSSQL$SHAREPOINT service is stopped. To do so, click Start, click Run, and then type Services.msc. If the service is not stopped, right-click the service name, and then click Stop. After the upgrade is complete, you must ensure that the service restarts.

Note

By default, MSDE 2000 SP4 is automatically applied to the instances of SQL Server 2000 Desktop Engine (MSDE) that were installed during Windows Small Business Server 2003 Setup, including the Monitoring (SBSMONITORING) MSDE instance, and the SharePoint Services (SHAREPOINT) WMSDE instance.
Additionally, if you have the Premium Edition of Windows SBS 2003, and you have installed ISA 2004, MSDE SP4 is automatically applied to the ISA Server 2004 Firewall (MSFW) MSDE instance. In addition, if you are running instances of SQL Server 2000, SQL Server SP4 is made available for you to install.

  1. Restart https://companyweb by clicking Start and then clicking Server Management. In the Server Management console, double-click Advanced Management, double-click Internet Information Services, double-click ServerName (local computer), and then double-click Websites. Right-click companyweb, and then click Start.

Turn on full-text search in Windows SharePoint Services

To turn on full-text search in Windows SharePoint Services

  1. Click Start, point to Administrative Tools, and then click SharePoint Central Administration.

  2. In Component Configuration, click Configure full-text search.

Note

If you encounter the error message, “Configuration database can’t be found,” ensure that the MSSQL$SHAREPOINT service is started. To do so, click Start, click Run, and then type Services.msc. If the service is not started, right-click the service name, and then click Start. Click OK to exit Services.

  1. Select the Enable full-text search and index component check box, and then click OK.