Friday, March 9, 2012

Report Manager Config Issue

Greetings,

*Microsoft Windows Server 2003

*MSSQL Server 2005 (with reporting services installed)

I have found a configuration issue after setting up the virtual directorties for the report service and report manager.

The reporting virtual directories are assigned to a non default website and the assigned site has a defined IP Address other than the machines assigned IP.

The Reporting Services Configuration Manager Created the virtual directories properly but there seems to be a problem with it reconizing a non-default IP Address for the site the reporting services directories are created under. Because I get -

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

When I open C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\RSWebApplication.config I see the following -

<UI>

<ReportServerUrl></ReportServerURL>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

I tried

<ReportServerUrl>http://<Site IP Address>/</ReportServerURL>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

and

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Still no luck - any suggestions?

Nevermind Figured it out -

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Works - just did not recycle the application pools in IIS. By the way if you are configuring the manager for a non-default IP address be carefull. For some reason the report manager does not like a <ReportServerVirtualDirectory> value if <ReportServerURL> is supplied.

No comments:

Post a Comment