Solved

SSRS error

Posted on 2008-06-16
1
173 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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

726 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