Be seen. Boost your question’s priority for more expert views and faster solutions
SSRS error
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.
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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)