Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
COURSE of the MONTH
13 days, 11 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
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):
. Check for publisher's certificate revocation
. Check for server ce…
Introduction:
When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database.
Problems start when you try to combine that with some "user input" pass…
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…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month13 days, 11 hours left to enroll
800 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.