Installing SQL Reporting Services on Server 2008

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

clip_image001

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s