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.
Thanks for one. I was pulling out my hair with this problem.
\\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!
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.
Muchas Gracias. Why can’t MSFT just give straight forward instructions?