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

INTRODUCTION

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: a. In the list of currently installed programs, click Microsoft Office SharePoint Portal Server 2003 DM Components, and then click Change/Remove.
b. On the Microsoft Office SharePoint Portal Server 2003 Maintenance page, click Remove, and then click Next.
c. 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:
a. In the list of currently installed programs, click Microsoft Office SharePoint Portal Server 2003, and then click Change.
b. Click Next.

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:
a. Start Internet Information Services (IIS) Manager.
b. Expand ServerName, expand Web Sites, right-click Default Web Site, and then click Properties.
c. Click the Home Directory tab.
d. In the Application Settings area, in the Application pool box, click DefaultAppPool, and then click OK.
e. 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:
a. 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.
b. 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.
c. Click OK.
6. On the Specify Configuration Database Settings for ServerName page, do the following:
a. In the Database Connections area, click Create configuration database.
b. In the Configuration Database Server area, in the Database server box, type the name of remote SQL server.
c. 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:
a. In the Component Assignment area, click to select the Web check box, the Search check box, and the Index check box.
b. In the Job Server Component area, in the Job server box, click the name of the server.
c. 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.

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.