I spent a couple of hours today trying to get SSRS 2005 working on Vista. I was getting the infamous IIS 500 error when browsing the Report Manager (http://localhost/reports) and Report Server (http://localhost/reportserver) virtual roots. I triple-verified the Brian Welcker’s recommendations and the Vista considerations in the SQL Server 2005 readme file. I couldn’t figure what’s going on especially given the fact that I installed SSRS on my home Vista machine with no problems. The only difference this time was that I performed file-only install of SSRS because I wanted to use an existing report catalog. In a moment of a Google eureka, I came across the How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer KB article. It turned out that the Reporting Services Configuration Utility put the IIS applications in the default application pool which in IIS 7.0 is running in Integrated Managed Pipeline Mode. I created a new ReportServer application pool in Classic Managed Pipeline Mode, put the ReportServer and Reports applications in, and the issue went away.
You might also like
Troubleshooting the SharePoint Add-in for Reporting Services Troubleshooting the SharePoint Add-in for Reporting Services
Applied Reporting Services 2008 Online Training Class with Teo Lachev Applied Reporting Services 2008 Online Training Class with Teo Lachev
SQL Server 2005 SP2 Brings Self-upgrading Catalogs SQL Server 2005 SP2 Brings Self-upgrading Catalogs