Solved

Not able to run report SSRS report

Posted on 2014-12-16
1
95 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 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

832 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