Solved

Not able to run report SSRS report

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

708 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

13 Experts available now in Live!

Get 1:1 Help Now