Solved

SSRS "My Subscriptions" blank for end-users

Posted on 2014-02-25
5
2,123 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

615 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