SQL 08 Reporting

  • Is it possible to generate reports using SQL 2008 Reporting Services against SQL 2005 data? In my case migration isn't an option yet because it's a CRM 4.0 database which does not support 08. I can creeate the reports and run them in VS BI 2008 but up on the server I get this message.

    * An error has occurred during report processing. (rsProcessingAborted)

    o Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)

    + The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services. (rsOperationNotSupported)

  • Your description of what you are trying to do is misleading.

    I think you are trying to author reports using Visual Studio / BIDS 2008 and publish them to a Reporting Services 2005 server. You cannot do this. The reports themselves can use data sources that connect to any number of MS SQL server versions (or any OLEDB or ODBC Data source).

  • +1

    If I remember correctly (actual experiences):

    You can write report in BIDS2005, deploy to SSRS2005

    You can write report in BIDS2005, deploy to SSRS2008

    But if you write report in BIDS2008, you can only deploy to SSRS2008

    Data Source is almost irrelevant, it can connect to anything the provider provides (even non-SQL I believe)

    Then the reports will only have to reference the Data Source correctly without knowing the underlying DB type/version

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005

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

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