Solved

SSRS error

Posted on 2008-06-16
1
172 Views
Last Modified: 2010-03-19
A set of reports and datasoures(from a remote sqlserver) were tested and run perfectly on a development local reportserver. But after being deployed to a remote reportserver, those reports generated the following:


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


Please advise. Thanks.
0
Comment
Question by:ksfok
[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 13

Accepted Solution

by:
rickchild earned 500 total points
ID: 21800866
First of all I would recommend temporarily allowing remote errrors, as this will allow you to see the full error rather than just the generic error you have there.
http://msdn.microsoft.com/en-us/library/aa337165.aspx

It sounds like the data source is incorrect, or does not have permission to access the database.
Is the database you are querying on the development server or the new remote server?

Is the data source using Windows Authentication (The person running the report will need access to the database set up in SQL)
or Stored Credentials (Should be a SQL Server Login and not a Windows Domain login if you are querying a different sever due to the Double-Hop authentication issue)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying 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

Suggested Solutions

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

737 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