How to move SharePoint Portal Server 2003 from MSDE to SQL Server (837848)

SUMMARY

INTRODUCTION

Back up SharePoint Portal Server

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

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)

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

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

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

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.