ssrs-An error has occurred during report processing.

  • 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

  • You cannot connect to the data source, probably need to adjust the authentication/credentials that are used for the connection.

  • 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?

    ----------------------------------------------------

  • 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