Error showing reports for Team Projects on Team Site, when Team Foundation Server is installed on different server that WSS

When you have the following:

• Team Foundation Server installed on ServerA
• Windows Sharepoint Services installed on ServerB
• Reporting Services installed on ServerC (or ServerA or any Server different of ServerB)
• Assume you are creating Team Projects on WSS using the Uri http://ServerB/Sites

And you create a Team Project on TFS, which is configured to use WSS 3.0 (maybe it works onf WSS 2.0), maybe the following error message is showed when the page tries to display the reports:

The following registry key is not set: HKLM\Software\Microsoft\VisualStudio\9.0\TeamFoundation\ReportServer\80\Sites for Uri /Sites/[ProjectName]/_layouts/tfsredirect.aspx?IsReport=1&ReportName=Remaining+Work

This is 'cause the ServerB, where is installed WSS need to know the Uri for the Report Server to redirect you, on this case, you need to create the following key on the registry for the ServerB (where WSS is installed)

• HKLM\software\Microsoft\VisualStudio\9.0\TeamFoundation\ReportServer\80\Sites

After created it, create the following String Values:

• BaseReportsUrl with value http://ServerC/Reports
• ReportsService with value http://ServerC/reportServer

With that key and values, the problem is resolved.

The reason for this, is because the WSS try to redirect your report to the server when Report Service is working, and for that reason need those keys on the registry.