Reporting services cant connect do remote server

  • Hello

    Im using SQL Server 2005 Workgroup and Reporting Services. Most of my reports connect to local server but one need remote server connection. I made new data source and configure report but when I wish render report I get error:

    An error has occurred during report processing.

    Cannot create a connection to data source '...'.

    The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services.

    Server version is:

    9.00.3068.00 SP2 Workgroup Edition

    On my developer machine where is Developer edition (9.00.3042 SP2) works fine.

    Any suggestion?

  • The error message pretty much says it all - Workgroup Edition is restricted to accessing local SQL Server databases only.

    Developer Edition does not have this restriction which is why you can develop reports but they don't run when deployed.

Viewing 2 posts - 1 through 1 (of 1 total)

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