Solved

SSRS "My Subscriptions" blank for end-users

Posted on 2014-02-25
5
2,074 Views
Last Modified: 2014-03-08
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.
0
Comment
Question by:art_frank
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 39889294
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
0
 

Author Comment

by:art_frank
ID: 39889501
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.
role assignmentPlus, it seems odd, from a permissions standpoint, that the users can CREATE subscriptions but then they can't SEE them.
0
 

Author Comment

by:art_frank
ID: 39895599
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.
0
 

Accepted Solution

by:
art_frank earned 0 total points
ID: 39900805
Where is SSRS getting this old user ID?  I'll tell you:  the sys.server_principals table.  This is the list of logins at the SQL Server Database engine level under Security > Logins. The user name in the Users table of the ReportManager database needs to match the sys.server_principals user name. Fixing the user accounts was as easy as:

ALTER LOGIN [DOMAIN\olduserid] WITH NAME = [DOMAIN\newuserid]

for all the affected users.
0
 

Author Closing Comment

by:art_frank
ID: 39914434
Because it's correct.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to increase the row limit in Jasper Server.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question