How enable SQL Server 2012 Reporting Service on SharePoint 2010
-
Thursday, February 14, 2013 8:21 AM
I have Intranet portal with followings. Currently no Performance Point Services or Reporting Services are used.
SRV1-Front-End server: SharePoint 2010 Enterprise (will not upgraded to SharePoint 2013)
SRV2-Back-End server: SQL Server 2008R2 (will not upgraded to SQL Server 2012)
Now I would like to deploy reports and dashboards to SharePoint portal using third server:
SRV3-BI Server: SQL Server 2012 SP1I have already build cube with Analyses Services on SRV3. I have also created a report that can be deployed succesfully with native mode to http://SRV3/ReportServer.
Now How I'm able to enable and deploy reports on SharePoint 2010 on SRV1? Basic steps I need to do?
I do find Reporting Service Integration settings in Central Admin. What should be URL?
Kenny_I
- Edited by Kenny_I Thursday, February 14, 2013 10:03 AM
All Replies
-
Friday, February 15, 2013 2:11 AMModerator
Hi Kenny,
In SQL Server 2012, Reporting Services Configuration Manager no longer supports Reporting Services SharePoint mode. Configuration of SharePoint mode is completed using SharePoint Central Administration.
To configure Reporting Services in SharePoint mode, we should install SQL Server Reporting Services add-in for SharePoint 2010 products. We can use either the SQL Server 2012 or the SQL Server 2008 R2 versions of the Reporting Services add-in for SharePoint 2010 products. And then you can create a Reporting Services service application in SharePoint Central Administration.
For more information, please see:Reporting Services Report Server (SharePoint Mode)
Regards,
Fanny LiuFanny Liu
TechNet Community Support
- Marked As Answer by Kenny_I Thursday, February 21, 2013 10:23 AM
.png)
