Cannot create a connection to data source 'DataSource1'.

  • I have created a report with shared datasource and it show the report

    in preview but when depoly the report and calling the report using Asp.net or open using ReportManager then getting the following Error

    An error has occurred during report processing.

    Cannot create a connection to data source 'DataSource1'.

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

  • Are you deploying the datasource as well?

  • I have depoly datasource also

  • This error generally means SSRS have dropped your connection credentials so open your report in BIDs and edit the connection property and add the connection credentials.

    Kind regards,
    Gift Peddie

  • What is the data source accessing and where is it located in regards to the SSRS server? If you are using Windows Integrated security and the information you are trying to access is remote (not located on the same server) then you are going to need to configure Kerberos to be able to pass the security context properly or you are going to need to look at using SQL logins instead (depending on the data source you are trying to access).

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

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

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