Configuring SQL Server 2008 Reporting Services on Windows 7

In setting up a local copy of SSRS 2008 on Windows 7 for an upcoming demo, discovered that the local security has been changed from prior versions.  Figured I’d take a minute and document this…

I know that SSRS was configured properly having double checked the Reporting Services Configuration Manager:

image

However, when I browsed out the the web server web service url listed above, I received the following error.  Figured that is a little strange, as I was able to publish a sample report project…

image

Did some checking… by default, the SSRS reporting server only allows the local Administrator to have permissions.  Launch IE as ‘Run As Administrator’ navigate to http://localhost/reports

Now, you can add a New Role Assignment, in my case I added my local user account, gave it the appropriate roles:

image

Opened the Reports home page <http://localhost/reports> once again using my standard account, all is well.

image

Happy reporting!

Published Wednesday, May 05, 2010 2:36 PM by sthompson

Comments

No Comments
Powered by Community Server (Commercial Edition), by Telligent Systems