Running SQL Reporting Services on Vista
I recently decided to fire up SQL Server 2005 Reporting Services on my Vista laptop. I installed SQL Server 2005 (with SP2 of course!) and made sure that I used the SQL Server User Provisioning tool to give myself full rights. I then launched the Report Manager, and stopped dead in my tracks. I couldn't access the Report Manger. Hmm.
I am running Vista with ALL of the security features enabled. I do this for two reasons. First, it is more secure. Second, I want to learn how to work in the new environment without turning security features off. I knew that I had a security issue, but I didn't want to "fix" the problem by removing security. Therefore, I launched an elevated IE instance and added my credentials to the Report Manager. I gave myself full rights to everything. That should do it, right? Nope! I still couldn't access Report Manager from a standard IE instance. Hmm.
I did some more research and found this blog post:
My problem was solved. All I needed to do was to add the SSRS site to my trusted sites list. This allowed the Report Manager to run in an un-elevated browser instance, but with protected mode turned off. That was the trick, and it all works now.
I hope this helps!