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:


http://www.jameskovacs.com/blog/ReportingServicesOnWindowsVistaRedux.aspx


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!

Skip to main content