• Article

Recover Windows SharePoint Services

If the computer that is running Microsoft Windows SharePoint Services fails, you can quickly prepare a new computer that has a new server name. Run the Microsoft Office PerformancePoint Server 2007 Setup.msi, and then run Planning Server Configuration Manager to set up a new Planning Web Service server. Replace the failed one with the newly created one.

Note

The terms Windows SharePoint Services and SharePoint Services are used collectively in PerformancePoint Server documentation to refer to Office SharePoint Server 2007 and Windows SharePoint Services 3.0.

Recover Windows SharePoint Services

  1. Prepare the new computer running Planning Server for use as the Windows SharePoint Services server. For more information about preparing the new computer for use with Windows SharePoint Services, see the PerformancePoint Server 2007 Deployment Guide.

    For a multi-computer deployment scenario, you must configure the security settings among the computers that are running SQL Server and Windows SharePoint Services. For information about configuring security among these computers in multi-computer deployment scenarios, see the PerformancePoint Server 2007 Deployment Guide.

  2. On the new computer running Windows SharePoint Services, create a new Web site from IIS Manager by performing the following steps.

    1. Configure the newly created Web site.

    2. Install and configure Windows SharePoint Services.

    3. Define the configuration database. (The configuration database is in the Planning Server computer that runs SQL Server.)

    4. Define the content database. (The content database is in the Planning Server computer that runs SQL Server.)

    5. Create a subsite. Grant global administrator, Service Identity Account, and Web Service Server Contributor permissions on the subsite.

  3. Manually copy all files from the source system URLs to the new URL location.

  4. Manually update the Storage URL column in the Workbooks table.

    Update the application database by using the following command.

    UPDATE dbo.Workbooks
SET StorageUrl = @NewStorageUrl
WHERE [StorageUrl] is Not NULL

    Note

    The Workbooks table contains the Storage URL that is used by the Assignments table (joined by WorkbookID) and BizForms (joined by FormID, which is WorkbookID).

    The source system table might have many different Storage URL values for various usages in the Assignments and BizForms tables. But for the new Windows SharePoint Services system, you can simply place all Storage URLs into one single URL location to start with. The file copy task can be difficult, because you need to copy these files from all URL locations into one location.

    Update the Planning System Database by using the following command.

    UPDATE BizSystem
SET 
AssignmentFormsUrl = @NewAssignmentFormsUrl,
AssignmentMasterFormsUrl = @NewAssignmentMasterFormsUrl,
FormTemplatesUrl = @NewFormTemplatesUrl,
ReportUrl = @NewReportUrl

    Where BizApplicationLabel = @BizApplicationLabel

    -- all these are default URLs for each purpose.

  5. Reconnect Windows SharePoint Services. Point Windows SharePoint Services back to its configuration and content databases on the new computer that is running SQL Server.

    Take the following steps:

    1. On the computer that is running Windows SharePoint Services, open Internet Information Services. Expand the list and open the Web Sites folder.

    2. Right-click SharePoint Central Administration and select Browse.

    3. Select Set Configuration database server. Change the server name to the new name for the server that runs SQL Server.

    4. Select Connect to existing configuration database. Click OK.

    5. Select Set default content database server and verify that the new name is correct. If it is not, update the name to the new database server name, and then click OK.

    If Windows SharePoint Services cannot be reconnected, remove it and then reinstall Windows SharePoint Services from its install point. The steps are:

    1. On the server running Windows SharePoint Services, uninstall Windows SharePoint Services by using Add or Remove Programs.

    2. On the server running Windows SharePoint Services, open Internet Information Services and delete the SharePoint Web site and the stsAdminAppPool.

    3. Install Windows SharePoint Services on the server.

See Also