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
Course Of The Month
7 days, 3 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SSRS error
Posted on 2008-06-16
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.
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.
[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
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)
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)
Featured Post
![[Webinar] Learn How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/21/e0b7778f-e79e-4b5d-9ec6-5496e40be42e.png)
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…
Suggested Courses
Course of the Month7 days, 3 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
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.