Friday, March 16, 2012

"Remote access to report data sources and/or the report server database" is not suppor

I'm using SQL Express with Advance Services & I get this error when I try to deploy my reports. Why do I get this error

  • An error has occurred during report processing. (rsProcessingAborted)
  • Cannot create a connection to data source 'EDPSYS'. (rsErrorOpeningConnection)
  • The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)

    Justin Song

    SQL Express does not allow access to data sources not on the local machine. You will need to point to local data in your report.|||

    I'm new user of Reporting Services. I'm trying use Samples (AdventureWorks) and can't use it because this error. How do I point to local data in this samples? I create a Data Source named AdventureWorks with this string:

    data source="(local)";persist security info=False;initial catalog=AdventureWorks

    but is not working...

    |||

    I've seen this problem before. The way I solved it previously was to update the connectionstring from an old-style ADO format to the new SQL 2005 format.

    Old:

    data source=(local);persist security info=False;initial catalog=AdventureWorks

    New:

    Server=(local); Database=AdventureWorks; Trusted_Connection=yes;

    Hope this helps. Mark

  • No comments:

    Post a Comment