Link to home
Start Free TrialLog in
Avatar of art_frank
art_frank

asked on

SSRS "My Subscriptions" blank for end-users

End users are able to create subscriptions, but when they click "My Subscriptions" in the upper right corner the page is blank.  The subscriptions exist -- I can see them in the Subscriptions table of the ReportServer database -- but the users who created them cannot.  How can I fix this?

SQL Server 2008 R2.  The report server is on the company intranet, so users typically authenticate using pass-through authentication, and I thought that might be part of the issue but I just had someone use Chrome and explicitly login and still he couldn't see his subscriptions.

Google-searched, couldn't find anything useful.  This link:
http://stackoverflow.com/questions/12157528/ssrs-my-subscriptions-is-empty
makes me think that it really has something to do with the user name and authentication.  But the person I mentioned above who explicitly logged in using Chrome used the exact same user ID formatted exactly the same way as appears in the Users table in the ReportServer database.

Thanks in advance for any help or guidance.
Avatar of lcohan
lcohan
Flag of Canada image

The issue is not browser related but SSRS security related and the "user" which I assume is a NT domain login must have sufficient rights to create and view subscriptions. You can create a custom role if you want then add users to that particular role instead of letting them to be SSRS admin.

Please see the answer under "HOW TO Grant the Manage All Subscriptions rights"

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/9f722f23-ddf2-4ce6-9ab3-61f95287bf28/how-to-grant-the-manage-all-subscriptions-rights?forum=sqlreportingservices
Avatar of art_frank
art_frank

ASKER

Yes, this is a domain user account.  I'm open to the idea that it's a permissions issue, but it looks to me like they're set correctly.  The user is a member of a group that has the "Browser" role, which appears to have the ability to subscribe to reports.
User generated imagePlus, it seems odd, from a permissions standpoint, that the users can CREATE subscriptions but then they can't SEE them.
So, as I suspected, the stackoverflow.com link that I refer to in my original post is on the right track.  Here's what I'm finding:

I finally (don't know why I didn't think of this sooner) connected to report manager as an administrator and took a look at the subscriptions on the report.  Here's what's odd -- the people who are affected have had their user logon id change at some point, and if I look at the "Owner" on the report it says:

DOMAIN\olduserid

But if I look at the Subscriptions table in the ReportServer database, these subscriptions use a UserID, so I look up the UserID in the Users table, look at the UserName field, and here it says:

DOMAIN\newuserid

So!  This is why these users aren't recognized as the subscription owners.  Which raises the question -- WHERE IS SSRS GETTING THE OLD USER ID?  Using Active Directory Users & Computers, I don't see the old user ID anywhere.  I don't see the old user ID in any of the ReportServer tables.
ASKER CERTIFIED SOLUTION
Avatar of art_frank
art_frank

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Because it's correct.