How to move SharePoint Portal Server 2003 from MSDE to SQL Server

Article translations Article translations
Article ID: 837848 - View products that this article applies to.
Expand all | Collapse all

On This Page

SUMMARY

This step-by-step article describes how to move an installation of Microsoft Office SharePoint Portal Server 2003 that uses Microsoft SQL Server Desktop Engine 2000 (MSDE) to Microsoft SQL Server. Use the procedure that is described in this article if you originally installed SharePoint Portal Server with MSDE and you now want to use a remote SQL server for database storage.

Before you can move SharePoint Portal Server from MSDE to SQL Server, you have to back up SharePoint Portal Server data, remove SharePoint Portal Server and related components, clean up settings in Microsoft Internet Information Services (IIS), and then verify the permissions of the Windows domain account. After you do so, you can reinstall SharePoint Portal Server and then use the SharePoint Portal Server Data Backup and Restore tool to restore the backup of SharePoint data to the server.

INTRODUCTION

This step-by-step article describes how to move a deployment of Microsoft Office SharePoint Portal Server 2003 that uses Microsoft SQL Server Desktop Engine 2000 (MSDE) for database storage to Microsoft SQL Server.

Use the procedure that is discussed in this article if you originally installed SharePoint Portal Server 2003 with MSDE and you now have to use SharePoint Portal Server 2003 with a remote SQL server instead of MSDE. This article describes how to use the SharePoint Portal Server Data Backup and Restore tool to move databases to a remote SQL server.

Back up SharePoint Portal Server

Use the SharePoint Portal Server Data Backup and Restore tool to back up SharePoint Portal Server. To do so:
  1. Start the SharePoint Portal Server Data Backup and Restore tool.
  2. Click the Backup tab.
  3. In the Backup location and name box, specify the location where you want to store the backup files and the file name to use as a prefix for the backup files.
  4. Expand Available components, click All server farm components, and then click Backup
  5. After the backup operation is complete, on the File menu, click Exit to quit the SharePoint Portal Server Data Backup and Restore tool.

Remove SharePoint Portal Server

Use the Add or Remove Programs tool to remove the component for backward-compatible document libraries (if it is installed on the server), remove SharePoint Portal Server, and remove Windows SharePoint Services. To do so:

Important Do not click Microsoft SQL Server Desktop Engine (SHAREPOINTPORTAL) to remove MSDE from the server. To use the SharePoint Portal Server Data Backup and Restore tool later in this article, MSDE must be installed on the server.
  1. Click Start, point to Control Panel, and then click Add or Remove Programs.
  2. Remove the component for backward-compatible document libraries. To do so:
    1. In the list of currently installed programs, click Microsoft Office SharePoint Portal Server 2003 DM Components, and then click Change/Remove.
    2. On the Microsoft Office SharePoint Portal Server 2003 Maintenance page, click Remove, and then click Next.
    3. Follow the instructions that appear in the remaining pages of the wizard to remove the component for backward-compatible document libraries.
  3. Remove SharePoint Portal Server. To do so:
    1. In the list of currently installed programs, click Microsoft Office SharePoint Portal Server 2003, and then click Change.
    2. Click Next.
    3. Click Remove the server components of Microsoft Office SharePoint Portal Server 2003, and then click Next.
    4. When you are prompted to confirm that you want to remove SharePoint Portal Server 2003, click Yes, and then click OK when you receive the message that SharePoint Portal Server is removed.
  4. Remove Windows SharePoint Services. To do so:
    1. In the list of currently installed programs, click Microsoft Windows SharePoint Services 2.0, and then click Remove.
    2. When you are prompted to confirm that you want to remove Windows SharePoint Services, click Yes.
  5. Restart the server.
  6. Clean up SharePoint Portal Server components that may remain on the server. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
    830326 How to manually remove SharePoint Portal Server 2003

Clean up settings in Microsoft Internet Information Services (IIS)

Configure the application pool that is used for the Default Web site and remove application pools that were used by SharePoint Portal Server. To do so:
  1. Start Internet Information Services (IIS) Manager.
  2. Expand ServerName, expand Web Sites, right-click Default Web Site, and then click Properties.
  3. Click the Home Directory tab.
  4. In the Application Settings area, in the Application pool box, click DefaultAppPool, and then click OK.
  5. Delete the CentralAdminAppPool and MSSharePointPortalAppPool application pools that were used by SharePoint Portal Server. To do so, expand Application Pools, right-click the application pool that you want to delete, and then click Delete. Click Yes when you are prompted to confirm the deletion.

Verify the permissions of your Windows domain account

Verify that your account has the correct permissions in SQL Server. The account must be a domain account and must be a member of the Power Users group on the server. The domain account must also have the Database Creators and Security Administrators server roles on the instance of SQL Server. For additional information, see the Microsoft Office SharePoint Portal Server 2003 Administration Guide.

Install SharePoint Portal Server

To install SharePoint Portal Server:
  1. Run the Setup program to Install SharePoint Portal Server.
  2. Follow the instructions that appear on the pages of wizard until you reach the Installation Type and File Location page. When you are prompted, click Install without database engine, and then click Next.
  3. On the Microsoft Office SharePoint Portal Server 2003 page that requests account information to use for the configuration database, specify a Windows domain account, and then click Next.

    Note Do not specify a local user account. You must specify a domain account that is a member of the local Power Users group on the Web server. The Setup program is not completed successfully if you use a local account.
  4. Click Next, and then click Finish.
  5. On Configure Server Farm Account Settings page, do the following:
    1. In the Default Content Access Account area, specify a user account to use as the default content access account if the user account that you want to use is different from the user account that is currently specified.
    2. In the Portal Site Application Pool Identity area, specify the domain account that you want. The portal site application pool identity is the account that the SharePoint content virtual server uses to run as.
    3. Click OK.
  6. On the Specify Configuration Database Settings for ServerName page, do the following:
    1. In the Database Connections area, click Create configuration database.
    2. In the Configuration Database Server area, in the Database server box, type the name of remote SQL server.
    3. In the Configuration Database Name box, specify whether you want to use a custom database name or use the default database name, and then click OK.
  7. On Configure Server Farm Account Settings page, type your e-mail address, and then click OK.
  8. On the Configure Server Topology page, click Change Components.
  9. On the Change Component Assignments page, do the following:
    1. In the Component Assignment area, click to select the Web check box, the Search check box, and the Index check box.
    2. In the Job Server Component area, in the Job server box, click the name of the server.
    3. Click OK.

Install the component for backward-compatible document libraries

If the component for backward-compatible document libraries was previously installed on the server, reinstall the component for backward-compatible document libraries. To do so:
  1. Click Start, point to Control Panel, and then click Add or Remove Programs
  2. Insert the SharePoint Portal Server 2003 CD into the server's CD-ROM drive, or locate the folder that contains the SharePoint Portal Server 2003 installation files, and then double-click Autorun.exe.
  3. Click Install optional components, and then click Install server and client components for backward-compatible document libraries.
  4. Follow the instructions on the remaining pages of the wizard to install the component for backward-compatible document libraries.
  5. After the installation is completed, Start SharePoint Central Administration.
  6. Under Server Configuration, click Configure server topology.
  7. On the Configure Server Topology page, click Change Components.
  8. On the Change Component Assignments page, in the Document Library Server Component (Optional) area, in the Document library server box, specify the URL of the SharePoint Portal Server computer that where you install the component to.
  9. Click OK.

Restore SharePoint data to the server

Restore the SharePoint Portal Server data that you backed up to the server. To do so:
  1. Start the SharePoint Portal Server Data Backup and Restore tool.
  2. Click the Restore tab.
  3. In the Manifest file box, specify the location of the manifest backup file in UNC format. For example, type \\ServerName\ShareName\NameOfBackUpFile.xml
  4. Expand Available components, and then click All server farm components.
  5. Click the first item in the Restore Item column (but do not click to select the check box), and then click Edit.
  6. Click the Web site that you want, verify that the database information is correct, and then click OK.
  7. Click to select the check boxes that are listed next to both items in the Restore Item column, and then click Restore.
  8. When you receive the message that the restore operation may overwrite existing data, click OK.
  9. After the restore operation is complete, on the File menu, click Exit to quit the SharePoint Portal Server Data Backup and Restore tool.
After the restore operation is completed, SharePoint Portal Server uses SQL Server for database storage and no longer uses MSDE for database storage. Now, you can remove MSDE if you want. If you do remove MSDE, you have to install Microsoft SQL Server 2000 tools before you can use the SharePoint Portal Server Data Backup and Restore tool to back up and restore SharePoint Portal Server data.

REFERENCES

For more information about how to back up and restore SharePoint Portal Server 2003, see the "Backup and Restore" section of the Microsoft Office SharePoint Portal Server 2003 Administration Guide.

For more information about how to remove SharePoint Portal Server 2003 and how to remove the component for backward-compatible document libraries, see the "Uninstalling the Installation" topic in the "Installation" section of the Microsoft Office SharePoint Portal Server 2003 Administration Guide.

The Microsoft Office SharePoint Portal Server 2003 Administration Guide (Administrator's Help.chm) is located in the Docs folder in the root of the SharePoint Portal Server 2003 CD.

For more information about SharePoint Portal Server, visit the following Microsoft Web site:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=2f7ba03d-1762-4ae9-b059-23aa198c08fb

Properties

Article ID: 837848 - Last Review: September 2, 2004 - Revision: 2.4
APPLIES TO
  • Microsoft Office SharePoint Portal Server 2003
Keywords: 
kbmigration kbdatabase kbhowtomaster KB837848

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com