Reporting Services permissions on SQL Server R2 SSRS

by

This did the trick for me. http://thecodeattic.wordpress.com/category/ssrs/. Go down to step 35 to see the error you are getting. Paraphrasing:

Once you’re able to log in to YourServer/Reports as an administrator, click Home in the top-right corner, then Folder Settings and New Role Assignment. Enter your user name and check a box for each role you want to grant yourself. Finally, click OK. You should now be able to browse folders without launching your browser with elevated privileges.

Don’t forget to set the security at the site level **AND ** at the folder level. I hope that helps.

Rick

More Related Contents:

  1. SSIS LookUp is not dealing with NULLs like the docs say it should
  2. T-SQL: Export to new Excel file
  3. Enable ‘xp_cmdshell’ SQL Server
  4. SQL Server Connection Strings – dot(“.”) or “(local)” or “(localdb)”
  5. Sql Server ‘Saving changes is not permitted’ error ► Prevent saving changes that require table re-creation
  6. SQL MERGE statement to update data
  7. A transport-level error has occurred when receiving results from the server [closed]
  8. storing passwords in SQL Server
  9. How does sql server sort your data?
  10. Should every User Table have a Clustered Index?
  11. How to restore to a different database in SQL Server?
  12. Why is SQL Server 2008 Management Studio Intellisense not working?
  13. T-SQL substring – separating first and last name
  14. How to implement polymorphic associations in an existing database
  15. How to get week number of the month from the date in sql server 2008
  16. How to deploy SQL Server Compact Edition 4.0?
  17. Optional parameters in SQL Server stored procedure
  18. Entity Framework Database.SetInitializer simply not working
  19. Cannot open backup device. Operating System error 5
  20. What is the default transaction isolation level for SQL Server with ADO.NET?
  21. T-SQL strip all non-alpha and non-numeric characters
  22. How can I get a trigger to fire on each inserted row during an INSERT INTO Table (etc) SELECT * FROM Table2?
  23. Avoiding IF ELSE due to variable been NULL
  24. How do I find the data directory for a SQL Server instance?
  25. Where are SQL Server connection attempts logged?
  26. Can I pass variable to select statement as column name in SQL Server [duplicate]
  27. SQL Server 2008 Connection Error “No process is on the other end of the pipe”
  28. Recursive Child/Parent queries in T/SQL
  29. SQL Server 2008 Spatial: find a point in polygon
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment