Solved

SSRS "My Subscriptions" blank for end-users

Posted on 2014-02-25
5
1,857 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
  • 4
5 Comments
 
LVL 39

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Suggested Solutions

Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

706 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now