Post reply

Reporting Services 2005 with sql server 2012 compatibility - Issues with sp2?

  • January 19, 2015 at 6:19 pm

    #300420

    I am not exactly sure what is causing this issue. I am creating a replica of our production environment in our staging environment. We currently are using Windows 2008R2 with SQL Server 2005 Reporting Services and for our database it is on SQL Server 2012 sp1 but is a sql 2005 database in compatibility mode. I cloned the vm that reporting services is currently using and restored the databases from production into our staging database environment. Our staging db environment is currently using windows server 2012 with sql server 2012 sp2 . When I try to connect to the database in staging i get the following error:

    The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services

    Any help would be greatly appreciated

  • January 21, 2015 at 3:57 am

    #1771742

    Hi,

    What Edition (e.g. Enterprise/Standard/BI/Web/Developer/Express) is each part?

    Are you seeing this message when connecting to the RS databases via Reporting Services Config Manager and/or trying as a datasource for a report?

    Thanks

  • January 21, 2015 at 9:06 am

    #1771877

    All versions are Standard Edition. And eeing this message when connecting to the RS databases via Reporting Services Config Manager

  • January 21, 2015 at 10:15 am

    #1771918

    Thanks, connecting via that should upgrade the RS databases automatically. Is the 2005 RS patched to the latest SP (SP4?)

  • January 21, 2015 at 3:48 pm

    #1772011

    Yes it is sp4

    Microsoft SQL Server Reporting Services Version 9.00.5069.00

  • January 23, 2015 at 4:20 am

    #1772546

    Ok thanks, if you look in the reporting services logs are there any more details?

  • January 25, 2015 at 10:03 am

    #1772953

    Unfortunately no.

  • January 26, 2015 at 11:04 am

    #1773193

    our database it is on SQL Server 2012 sp1 but is a sql 2005 database in compatibility mode

    Is this the case also on your copy of the environment?

    ----------------------------------------------------

  • January 26, 2015 at 2:51 pm

    #1773242

    No. The copy is sql 2005 on sql 2012 sp2

Viewing 9 posts - 1 through 8 (of 8 total)

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