Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Not able to run report SSRS report

Posted on 2014-12-16
1
Medium Priority
?
112 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
1 Comment
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

963 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