ron.williams.IT.blog

I installed SQL 2005 Std 64-bit Reporting Services using a default configuration on a clean install of Server 2008.  I followed all the steps in Microsoft’s KB http://support.microsoft.com/kb/938245 entitled “How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008” but was still getting an error when browsing to http://localhost/reports or http://servername/reports :

“Error.  Unable to connect to the remote server”

Here is how I fixed it:

1. In IIS 7 Manager, highlight the ReportServer application
2. In right pane click on Handler Mappings
3. Click Edit Feature Permissions in the Actions Pane
4. Enable Script and Execute.
5. Click OK
6. Restart IIS and SQL Reporting Services service

I found the solution here:

http://blog.dastrup.com/?p=48