Compatibity of SQL Sever 2008 R2 with SharePoint 2013 for SQL Server Reporting Services & PowerPivot

Question

Hi Guys,

In my development box, I have my SQL server 2008 R2 and SharePoint 2013 installed, now am not able to configure the reporting services and Powerpivot services for SharePoint 2013. On searching a lot on internet I found that SQL server 2008R2 is not compatible with SharePoint 2013 for reporting services, below is the link:

https://msdn.microsoft.com/en-us/library/gg492257.aspx

Is that so ?? If yes, is there any way we can get SSRS reports to work in SP 2013.

Cheers,

Amit

Answer 1

Hi Amit,

According to your description, you are unable to configure SSRS 2008 R2 in SharePoint 2013 integrated mode, but you want to run reports in SharePoint 2013, right?

As you know, the combination of the SQL Server 2008 R2 and SharePoint 2013 is not supported to be installed in SharePoint mode. Based on the article you mentioned, SharePoint 2013 integrated mode can be only configured with SQL Server 2014 or SQL Server 2012 SP1. So in your scenario, if you want to run reports in SharePoint 2013 integrated mode, you should upgrade existing SQL Server 2008 R2 instance to SQL Server 2014 or SQL Server 2012 SP1. For more information, please refer to this article: Upgrade to SQL Server 2014. Then you could refer to this article to configure Reporting Services in SharePoint 2013 mode: Install Reporting Services SharePoint Mode for SharePoint 2013

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

---

Qiuyun Yu
TechNet Community Support

Answer 2

Thanks Qiuyun for the confirmation.