Solved

SSRS - Users can't run reports

Posted on 2013-06-10
1
767 Views
Last Modified: 2013-06-10
I have set up SSRS. I have written the sp's and SQL functions to build the reports and they run just fine.

However, I'm logging into Windows as an administrator. The standard users cannot run the reports. Initially they couldn't even log into the reports home. I set up the permissions so that the Domain Users group could get access to reports. This didn't fully work until I actually allowed the Domain Users group to access the main folder in SSRS. Now they can see all the reports. All users on the domain are part of the Domain Users group. When they run them they get an error.

"An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source "DataSource1". (rsErrorOpeningConnection)
        For more information about this error navigate to the report server on the local server machine or enable remote errors"


Firstly, where do I enable remote errors? I've been through the reports server configuration and there is nothing I can find that enables remote errors. The server itself has no IIS instance running on it.

If I go into each report and check the security settings on it, it is inheriting from the parent folder. The security settings on the site are:

Domain Users - Site User

Under the folder settings:

Domain User: Browser which says the users "May view folders, reports and subscribe to reports"

Each report has security settings which inherit from the folder so what am I missing?

All I want is that anyone that can log onto the URL and is part of the Domain Users group in Windows, I would like them to be able to run the reports. It's really quite simple.

If you need more info, please ask.
0
Comment
Question by:Lee Savidge
1 Comment
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 0 total points
ID: 39235270
I fixed this stupid problem myself in the end.

Instead of using Windows Authentication I set up the datasource to use SQL Authentication with a SQL user. All datasources now use this logon and the problem has gone away.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Parse field in SQL View 15 96
SQL Server Deadlocks 12 47
What is format f12.8 for a CSV file 6 37
Sql Query Datatype 2 14
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

914 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

14 Experts available now in Live!

Get 1:1 Help Now