SharePoint 2013 and SQL Server 2012 installation.  Trying to get the SSRS native mode web parts installed as per these instructions:

http://msdn.microsoft.com/en-us/library/ms159772.aspx

Have tried both via PowerShell and stsadm.  In both cases, get an error regarding "Failed to extract the cab file in the solution".  Have done this a bunch of times in SharePoint 2007 and 2010, is this solution no longer supported in 2013 and if so, is there a supported way of integrating with SSRS in Native Mode for SharePoint 2013?

Are you running SP1 on your SSRS installation?  If not, upgrade and try again.  Otherwise, no the SQL 2012 RTM (which is what you've linked to) only supports to SharePoint 2010.

Yes, SQL Server 2012 SP1 is installed.

The database engine may be at SP1 but Trevor is referring to the shared feature

Let me be clearer.  The SSRS server that is trying to be integrated is SQL Server 2008 R2.  SSRS is not installed on SQL Server 2012, only the database engine and the management tools.  As part of this installation (no Reporting Services installed), the RSWebParts.cab file is located in C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Reporting Services\SharePoint and is dated 10/20/2012.  I have installed SQL Server 2012 SP1 on this installation.

It sounds like what I need is an updated RSWebParts.cab file, if one actually exists.  If we surmise that it does exist, then it sounds like while the SQL Server 2012 install puts that file out there without SSRS being installed but that the SQL Server 2012 SP1 install is not inclined to update it unless SSRS is installed?

Is that all correct?  Or are we just hypothesizing that an updated RSWebParts.cab file exists in SQL Server 2012 SP1?

Hello

Your only option for SharePoint 2013 is SSRS SQL 2012 SP1.

Hello

No, you can use a slipstream copy of SQL 2012 to update shared features, the version should be 11.3.xx I believe.  

Installed a new VM, installed Windows Server 2012.  Downloaded the full slipstream version of SQL Server 2012 SP1.  Installed Database Engine and Management tools.  Got the 10/20/2012 version of RSWebParts.cab.  Added the Reporting Services Add-In.  Still have the 10/20/2012 version of RSWebParts.cab...

Shared Component Report Viewer and Report Explorer Web parts from SQL Server 2008 R2 are not supported on SharePoint 2013. For reference, from the link you posted:

Requirements for using the Report Viewer and Report Explorer Web Parts include the following:

• Supported versions of SharePoint products and technologies are:

  • Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server  2007.

  • SharePoint Foundation 2010 and SharePoint Server 2010.

Yes, and it is the same requirements/supported version for SQL Server 2012 (which is what I am using), not SQL Server 2008 R2. 

The bottom line is that it *appears* that there currently is no supported version of the Native Mode (2.0) version web parts for SQL Server Reporting Services (RSWebParts.cab) for SharePoint 2013.  Therefore, there is currently no way to integrate SharePoint 2013 with a SQL Server Reporting Services instance running in native mode. 

Everyone agree?

• Edited by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 1:07 PM forgot something

Yes, and it is the same requirements/supported version for SQL Server 2012 (which is what I am using), not SQL Server 2008 R2. 

The bottom line is that it *appears* that there currently is no supported version of the Native Mode (2.0) version web parts for SQL Server Reporting Services (RSWebParts.cab) for SharePoint 2013.  Therefore, there is currently no way to integrate SharePoint 2013 with a SQL Server Reporting Services instance running in native mode. 

Everyone agree?

• Edited by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 1:07 PM forgot something

Yes, and it is the same requirements/supported version for SQL Server 2012 (which is what I am using), not SQL Server 2008 R2. 

The bottom line is that it *appears* that there currently is no supported version of the Native Mode (2.0) version web parts for SQL Server Reporting Services (RSWebParts.cab) for SharePoint 2013.  Therefore, there is currently no way to integrate SharePoint 2013 with a SQL Server Reporting Services instance running in native mode. 

Everyone agree?

• Edited by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 1:07 PM forgot something

I would agree with that statement.

OK, let me amend my statement a bit. 

Found this article:  http:// social.msdn.microsoft.com /Forums/sqlserver/en-US/5b9de028-5b6a-47c7-8da8-793d1a78df55/error-with-sql-server-2012-rswebpartscab-for-sharepoint-2010

Mind you, I was able to get the SQL Server 2012 version of RSWebParts.cab to install successfully on the SharePoint 2010 dev box in the environment, but figured that trying the SQL Server 2008 R2 version of RSWebParts.cab was worth a shot.  It worked (or at least it installed and I am able to add the web parts to pages).  Will post an update once I am able to test full web part functionality with an SSRS Native Mode server.

So, what I can say from my testing:

• SQL Server 2012 version of RSWebParts.cab works (installs) for a SharePoint 2010 installation but not for a SharePoint 2013 installation.
• SQL Server 2008 R2 version of RSWebParts.cab works (installs) for a SharePoint 2010 installation and for a SharePoint 2013 installation.
• There is no update to RSWebParts.cab in SQL Server 2012 SP1 (at all, not in any part of it including the Reporting Services Add-In), the file is always 10/20/2012.

So, as long as you are trying to integrate a SQL Server 2008 R2 SSRS Native Mode instance or lower on your SharePoint 2013 farm, there is a solution.  However, it will likely not work against a SQL Server 2012 SSRS Native Mode installation.   So, the amended statement is that:

"The bottom line is that it *appears* that there currently is no supported version of the Native Mode (2.0) version web parts for SQL Server Reporting Services2012 (RSWebParts.cab) for SharePoint 2013.  Therefore, there is currently no way to integrate SharePoint 2013 with a SQL Server Reporting Services 2012 instance running in native mode."

And, no, none of this really makes any sense in the least but that is what my testing shows.

• Edited by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 6:09 PM clarification
• Marked as answer by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 6:09 PM

OK, let me amend my statement a bit. 

Found this article:  http:// social.msdn.microsoft.com /Forums/sqlserver/en-US/5b9de028-5b6a-47c7-8da8-793d1a78df55/error-with-sql-server-2012-rswebpartscab-for-sharepoint-2010

Mind you, I was able to get the SQL Server 2012 version of RSWebParts.cab to install successfully on the SharePoint 2010 dev box in the environment, but figured that trying the SQL Server 2008 R2 version of RSWebParts.cab was worth a shot.  It worked (or at least it installed and I am able to add the web parts to pages).  Will post an update once I am able to test full web part functionality with an SSRS Native Mode server.

So, what I can say from my testing:

• SQL Server 2012 version of RSWebParts.cab works (installs) for a SharePoint 2010 installation but not for a SharePoint 2013 installation.
• SQL Server 2008 R2 version of RSWebParts.cab works (installs) for a SharePoint 2010 installation and for a SharePoint 2013 installation.
• There is no update to RSWebParts.cab in SQL Server 2012 SP1 (at all, not in any part of it including the Reporting Services Add-In), the file is always 10/20/2012.

So, as long as you are trying to integrate a SQL Server 2008 R2 SSRS Native Mode instance or lower on your SharePoint 2013 farm, there is a solution.  However, it will likely not work against a SQL Server 2012 SSRS Native Mode installation.   So, the amended statement is that:

"The bottom line is that it *appears* that there currently is no supported version of the Native Mode (2.0) version web parts for SQL Server Reporting Services2012 (RSWebParts.cab) for SharePoint 2013.  Therefore, there is currently no way to integrate SharePoint 2013 with a SQL Server Reporting Services 2012 instance running in native mode."

And, no, none of this really makes any sense in the least but that is what my testing shows.

• Edited by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 6:09 PM clarification
• Marked as answer by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 6:09 PM

OK, let me amend my statement a bit. 

Found this article:  http:// social.msdn.microsoft.com /Forums/sqlserver/en-US/5b9de028-5b6a-47c7-8da8-793d1a78df55/error-with-sql-server-2012-rswebpartscab-for-sharepoint-2010

Mind you, I was able to get the SQL Server 2012 version of RSWebParts.cab to install successfully on the SharePoint 2010 dev box in the environment, but figured that trying the SQL Server 2008 R2 version of RSWebParts.cab was worth a shot.  It worked (or at least it installed and I am able to add the web parts to pages).  Will post an update once I am able to test full web part functionality with an SSRS Native Mode server.

So, what I can say from my testing:

• SQL Server 2012 version of RSWebParts.cab works (installs) for a SharePoint 2010 installation but not for a SharePoint 2013 installation.
• SQL Server 2008 R2 version of RSWebParts.cab works (installs) for a SharePoint 2010 installation and for a SharePoint 2013 installation.
• There is no update to RSWebParts.cab in SQL Server 2012 SP1 (at all, not in any part of it including the Reporting Services Add-In), the file is always 10/20/2012.

So, as long as you are trying to integrate a SQL Server 2008 R2 SSRS Native Mode instance or lower on your SharePoint 2013 farm, there is a solution.  However, it will likely not work against a SQL Server 2012 SSRS Native Mode installation.   So, the amended statement is that:

"The bottom line is that it *appears* that there currently is no supported version of the Native Mode (2.0) version web parts for SQL Server Reporting Services2012 (RSWebParts.cab) for SharePoint 2013.  Therefore, there is currently no way to integrate SharePoint 2013 with a SQL Server Reporting Services 2012 instance running in native mode."

And, no, none of this really makes any sense in the least but that is what my testing shows.

• Edited by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 6:09 PM clarification
• Marked as answer by Greg Deckler (Quick Solutions) Wednesday, June 19, 2013 6:09 PM

So from what I get from reading this and other posts, Native mode is not supported in SharePoint 2013? So when we migrate from SharePoint 2010, we will have to convert thousands of reports? I can't believe this is what Microsoft envisioned when the support for native mode was deprecated. We will probably not migrate to SharePoint 2013 if this is the case.

• Proposed as answer by Greg Fishberg Monday, May 19, 2014 9:40 PM

So from what I get from reading this and other posts, Native mode is not supported in SharePoint 2013? So when we migrate from SharePoint 2010, we will have to convert thousands of reports? I can't believe this is what Microsoft envisioned when the support for native mode was deprecated. We will probably not migrate to SharePoint 2013 if this is the case.

• Proposed as answer by Greg Fishberg Monday, May 19, 2014 9:40 PM

So from what I get from reading this and other posts, Native mode is not supported in SharePoint 2013? So when we migrate from SharePoint 2010, we will have to convert thousands of reports? I can't believe this is what Microsoft envisioned when the support for native mode was deprecated. We will probably not migrate to SharePoint 2013 if this is the case.

• Proposed as answer by Greg Fishberg Monday, May 19, 2014 9:40 PM

We tried to install the the SQL Server 2014  RSWebParts.cab file onto our SharePoint 2013 farm, but got the same error. What's doing on here? Why wouldn't SQL 2014 support SharePoint 2013? This suggests a bug needs to be raised. 

It's not a bug, it is by design.

Neglecting to update your product is by design? It should have been pulled if it it's no-longer supported.