Sysadmin in SSRS doesn’t have access to view reports
Short and simple post this week. When setting up a Reporting Services Server this week, I added a user as a SysAdmin as they should have full access to the server to maintain it in the future. After setting up the user they tried to click in to the end of month reports folder…and couldn’t get in.
Turns out that being a Sys Admin doesn’t give you access to report folders, you need to add access on the folders or individual reports.
In some ways this makes a lot of sense – don’t give access to users who don’t need it. But when the Sys Admin can give themselves access, is it just an inconvenience?