December 2, 2015 at 2:56 am
Hi all,
I am deployed a ssrs project on one server (server A ) but i want to retrive the data from another serevr (Server b) . Build was success but hen i try to access the report from the internet explorer getting below error
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
December 2, 2015 at 8:12 am
You cannot connect to the data source, probably need to adjust the authentication/credentials that are used for the connection.
December 2, 2015 at 7:13 pm
You need to make sure that the credential configured at the data connection is valid for the database you are getting on your new server. Is this a SQL login or Windows authentication?
----------------------------------------------------
December 2, 2015 at 7:15 pm
Even if it is a valid user at the database, do you have the select permission on the objects that you need or are you calling a stored procedure that you need to provide the execute permission on maybe?
----------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply