Microsoft KB Archive/944210

= You receive an error message when you create, save, or open a report in Project Portfolio Server 2007 after you install SQL Server 2005 Service Pack 2 =

Article ID: 944210

Article Last Modified on 12/18/2007

-

APPLIES TO


 * Microsoft Office Project Portfolio Server 2007

-



SYMPTOMS
On a server that provides the reporting functionality for Microsoft Office Project Portfolio Server 2007, you install Microsoft SQL Server 2005 Service Pack 2 (SP2).

When you create a report or save a report in Project Portfolio Server 2007, you receive the following error message:

An attempt has been made to use a data extension 'PPSExtension' that is not registered for this report server.

More Info: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsDataExtensionNotFound&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00

When you open a report that is saved in Project Portfolio Server 2007, you receive the following error message:

An error has occurred during report processing.

More Info: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.3042.00



CAUSE
This problem occurs because the SQL Server Setup program removed an Extension XML element from the Rsreportserver.config file. This Extension XML element is added by the Project Portfolio Server 2007 Setup program.



WORKAROUND
To work around this problem, follow these steps:  Stop the SQL Server 2005 Reporting Services service. To do this, follow these steps:  Open SQL Server Configuration Manager. Click SQL Server 2005 Services. Right-click SQL Server Reporting Services , and then click Stop.  Add the Extension XML element that is removed by the SQL Server Setup program. To do this, follow these steps:  Open the following folder:

C:\Program Files\Microsoft SQL Server\ \Reporting Services\ReportServer

Note  represents the instance ID of the instance of SQL Server 2005 Reporting Services.</li> Back up the Rsreportserver.config file.</li> Open the Rsreportserver.config file in any XML editing program.</li> Locate the Extensions section of the file.

Note The Extensions section starts with the <Extensions> element.</li> In the Extensions section, locate the Data section.

Note The Data section starts with the  element.</li> Information in the Extension XML element is case-sensitive. If the case is incorrect, you cannot start the SQL Server 2005 Reporting Services service.</li></ul> </li> Save the changes, and then exit the XML editing program.</li></ol> </li> Restart the SQL Server 2005 Reporting Services service. To do this, follow these steps:  Open SQL Server Configuration Manager.</li> Click SQL Server 2005 Services.</li> Right-click SQL Server Reporting Services , and then click Start.</li></ol> </li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbexpertiseadvanced kbtshoot kbprb KB944210

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.