Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 944210 - Last Review: September 18, 2011 - Revision: 3.0
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
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
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.
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
(InstanceName), 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\MSSQL.X\Reporting
Services\ReportServer
Note MSSQL.X represents the instance ID of the
instance of SQL Server 2005 Reporting Services. - Back up the Rsreportserver.config file.
- Open the Rsreportserver.config file in any
XML editing program.
- Locate the Extensions section of the file.
Note The Extensions section starts with the <Extensions>
element. - In the Extensions section, locate the Data
section.
Note The Data section starts with the <Data> element. - Before the end of the Data section, add the following
Extension element:
<Extension Name="PPSExtension" Type="Microsoft.Office.Project.PortfolioServer.Reporting.PPSConnection,Microsoft.Office.Project.PortfolioServer.Reporting">
<Configuration>
<Key Name="Binaries" Value="Path\PortfolioServer\PortfolioServer\bin\"/>
<Key Name="Config" Value="Path\PortfolioServer\PortfolioServer\Web.config"/>
</Configuration>
</Extension>
- For the word "Path" in this code, substitute the path
where you install the application files of Project Portfolio Server 2007. By
default, "Path" is "C:\Inetpub."
- The <Data> section ends with the
</Data> element.
- Information in the Extension XML element is
case-sensitive. If the case is incorrect, you cannot start the SQL Server
2005 Reporting Services service.
- Save the changes,
and then exit the XML editing program.
- Restart 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
(InstanceName), and then click
Start.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
APPLIES TO
- Microsoft Office Project Portfolio Server 2007
| kbexpertiseadvanced kbtshoot kbprb KB944210 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate