Getting an error when report is opened in Report manager

  • Hello,

    I deployed a report from visual studio into report server http://server/reportserver.

    Now I opened the report manager using http://server/report and Iam able to see the datasource and the report.

    But when open the report Iam getting the following error:

    An error has occurred during report processing.

    Cannot create a connection to data source 'ABC'.

    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Could you please suggest me what to do here.

  • Hello,

    Have you tried executing the report from a browser on the actual Report Server? You should receive a more detailed error.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • Iam able to see the report in the actual report server. But Iam getting this error when tried see the report from other machines in the same domain.

  • Hello Again,

    Are you using a Shared Data Source? What Security Context are you using to connect to the Data Source e.g. Windows Integrated? If so, are you using the same Windows Account when displaying the report on both the Server and the Client?

    May be take a look at the suggestions from Dannol Liu at the bottom of this thread:-

    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1acd9e02-1bd6-417c-ae38-799bcd049ca0/

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply