Main Contents

SQL 2005 Reporting Services on Windows 2008 and IIS 7

June 16, 2008

After installing SQL 2005 Reporting Services on a Windows 2008 64-bit server, I was getting an error “unable to connect to remote server” when browsing to http://localhost/Reports. I verified that I had followed all the steps outlined in http://support.microsoft.com/kb/934164 but it still didn’t work. Granted, that KB article is for Vista, but the steps were fairly accurate. After a little more research, I figured out I also had to do the following: In IIS 7 Manager, highlight the ReportServer application, go to Handler Mappings, click Edit Feature Permissions in the Actions Pane, and enable Script and Execute.

Filed under: Microsoft, Windows |

4 Comments

  1. Lee July 29, 2008 @ 12:28 pm

    Thanks for one. I was pulling out my hair with this problem.

  2. Mihail Mihailov August 14, 2008 @ 3:41 am

    \\bc-srv-02\Public\SQL\sql-\Richard’s Blog - » SQL Reporting Services Cannot Access rsReportServer_config File.htm

    After verifying that the SQL instance in question was running under the Network Service account I navigated to the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer directory, and opened up the security properties of the rsReportServer.config file. I noticed Network Service was not listed. I explicitly granted Network Service access to the rsReportServer.config file, restarted IIS, and it started working!

  3. Dave Bowness November 11, 2008 @ 9:43 am

    OMG…now that I’m bald you tell me. I pulled my hair out for daze on this one. Hair Club for men, here I come.

  4. Andy January 26, 2009 @ 6:13 am

    Muchas Gracias. Why can’t MSFT just give straight forward instructions?