Reports not accessible through project portal by remote user

I have installed VSTS - Application Tier and Data Tier on seperate machines.The Application Tier has been connected to LIVE IP.

I am trying to access the reports via the project portal.(http://(liveip)/sites/teamproject/) Everything else is accessible, except the reports section. It shows "page not found" error.

The reason being, internally when application tier accesses the data tier it replaces URL with local machine's address of the data tier. As the reporting services is running on Data Tier.

I have come accross the tfsredirect.aspx, do i need to alter page in order to make reports accessible to a remote user or changes any setting on the data tier ?

I am unable to deduce the reason behind the problem.

Please help.

[898 byte] By [wmdpt] at [2008-2-26]
# 1

Hi,

Please check this registry key on the Application tier --HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\8.0\TeamFoundation\ReportServer

Look at the value for the key called "Key". This should point to where the report server is. This is what tfsredirect.aspx uses to determien the report server. please modify that to be http://<your ip address>

Let me know if that works!

mauli

MauliShah-MSFT at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 2

Hi,

Thanks for your help.

But now I am getting the following error message while accessing the URL through browser.

"Unable to get global configuration data."

Could you please guide me ahead.

Regards.

wmdpt at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 3

This usually means there is a permission issue connecting to the database. See:

http://support.microsoft.com/kb/900499

NickEricson at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 4
Have you been able to resolve your issue?
NickEricson-MSFT at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...

Visual Studio Team System

Site Classified