Solved

Not able to run report SSRS report

Posted on 2014-12-16
1
102 Views
Last Modified: 2014-12-17
I have a SSRS report that runs fine. The SQL points to two databases. The SQL runs fine in SQL server.
When I upload the report to the SSRS environment I get this error message:

An error has occurred during report processing.
Query execution failed for data set 'Production'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

I use the same rds file. Any ideas why I get this error and how to resolve?
0
Comment
Question by:Sanjeet
[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
1 Comment
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40503220
Depending on how your SSRS server is set up, you may have to go into report detais and change the data source to a shared data set, with a specific user id/password that has access to the data.

Either that, or the user that executes the report on the server doesn't have access to the SP/view/tables/whatever behind 'Production'.

Or both.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Calculation help 6 55
SSRS Calculation of two fields not working 7 68
SSRS 2016 KPI 2 39
SSRS Enable Remote Errors 4 41
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

756 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