Reporting Services 2012 Inter-Version Supportability

  • Article

 

Do you want to install/upgrade to the new version of Reporting Services 2012?

You can see below the different combinations that are compatible with this new version concerning databases, BIDS, Report Viewer, SharePoint and PowerPivot.

It is mostly compatible with prior versions, incompatibilities revolve around loss of support for SQL Server 2000, BIDS 2000 and Report Builder 1.0

RS databases, BIDS & Report Viewer

Create  ReportServer database on SQL 2000

Not  supported

Create  ReportServer database on SQL 2005 and later

Supported

Upgrade  ReportServer 2000 database on SQL 2000

Not  supported

Upgrade  ReportServer 2000 database on SQL 2005

Supported

Upgrade  ReportServer 2005 and later database on SQL 2005 and later

Supported

Deploy  from BIDS 2000 to Reporting Services 2012

Unsupported

Deploy  from BIDS 2005 and later to Reporting Services 2012

Supported

Deploy  Report Model projects to Reporting Services 2012

Not  supported

Upgrade  BIDS 2000 and later projects in BIDS 2012

Supported

Upgrade  Report Model Projects in BIDS 2012

Not  supported

Use  ReportViewer 8.0 and later against Reporting Services 2012

Supported

Use  ReportViewer 11.0 against Reporting Services 2000 or 2005

Not  supported

Use  ReportViewer 11.0 against Reporting Services 2008 and later

Supported

 

Reporting Services, SharePoint & Add-in, Data Alert and Power View reporting features

  

SharePoint Version

  

  

  

Report Server Add-in

  

  

  

Report Server Back-end

  

  

  

Power View and Alerting Available

  

Windows  SharePoint Services 3.0

2005

2005

No

Microsoft  Office SharePoint Services 2007

2005

2005

No

Windows  SharePoint Services 3.0

2008

2008  or 2008 R2

No

Microsoft  Office SharePoint Services 2007

2008

2008  or 2008 R2

No

SharePoint  Foundation 2010

2008  R2 or 2012

2008  SP2 or 2008 R2

No

SharePoint  Foundation 2010

2012

2012

No

SharePoint  Server 2010 Standard Edition

2008  R2 or 2012

2008  SP2 or 2008 R2

No

SharePoint  Server 2010 Standard Edition

2012

2012

No

SharePoint  Server 2010 Enterprise Edition

2008  R2 or 2012

2008  SP2 or 2008 R2

No

SharePoint  Server 2010 Enterprise Edition

2012

2012

Yes 1

 

SharePoint, databases, PowerPivot

  

SharePoint Version

  

  

  

SQL 2012Catalog

  

  

  

PowerPivot

  

SharePoint  Foundation 2010

No

No

SharePoint  Server 2010 Standard Edition

No

No

SharePoint  Server 2010 Enterprise Edition

No

No

SharePoint  Foundation 2010 Service Pack 1

Yes 2

No

SharePoint  Server 2010 Standard Edition Service Pack 1

Yes 2

No

SharePoint  Server 2010 Enterprise Edition Service Pack 1

Yes 2

Yes 3

 

Note:
  1.   Power View and Data Alerts require the new Business Intelligence Edition or the Enterprise Edition of both SQL Server Reporting Services and SharePoint Server 2010. These features are also available, for testing purposes, in Developer and Evaluation editions.
  2.   If you want to use PowerPivot 2012and/or SQL Server 2012 for the SharePoint Catalog database, then you must install Service Pack 1 for SharePoint 2010. These features do not work with the RTM version of SharePoint 2010.
  3.   PowerPivot only comes with the Enterprise Edition of SQL Server and requires the Enterprise Edition of  SharePoint Server 2010 (SP1).

 

Note:

   The BI Edition contains all the Enterprise features of Reporting Services and Analysis Services, including Data-driven Subscriptions, Data Alerts, Power   View, and PowerPivot. It comes with the Standard Edition equivalent of the SQL Server database engine, though.