Reporting Services Woes
SQL Server Reporting Services 2005 can at times be a nightmare to get working, so here are some tips to get your Reporting Services running using host headers and a couple of little things to watch out for.
Host Headers
If you are using a host header for your reporting services web site but each time you browse to the report manager you get presented with an error, then follow these steps.
Run through the “Reporting Services Configuration” tool as per Microsoft’s instructions http://technet.microsoft.com/en-gb/library/ms159868.aspx
After running successfully through the Reporting Services configuration we now need to edit the 2 following configuration files;
“RSWebApplication.config” located in the ReportManager directory, for example;
“ C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting
Services\ReportManager\RSWebApplication.config”
“Reportserver.config” located in the ReportServer directory, for example;
“C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\Reportserver.config”
In “RSWebApplication.config” locate the 2 lines;
<ReportServerUrl> </ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
Comment out the “<ReportServerVirtualDirectory>” node and place your host header value with the virtual directory for your report server web service path in the “<ReportServerUrl>”, for example;
<ReportServerUrl>http://MySSRS.k2.com/ReportServer</ReportServerUrl>
<!--<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>-->
In “Reportserver.config” locate the line;
<UrlRoot>http://blackpearl/reportserver</UrlRoot>
Replace the value with your host header and report server web service path, for example;
<UrlRoot>http://MySSRS.k2.com/reportserver</UrlRoot>
Something to watch out for, if you are running multiple instances of Reporting Services on one server make sure that in your “Reportserver.config” file the instance node points to the right instance path.
<InstanceId>MSSQL.9</InstanceId>
Mark Green