These are the steps I followed to install a development Microsoft SharePoint 2010 server with PowerPivot and Reporting Services integration.
I installed Microsoft SharePoint Server 2010 by following the steps on:
http://powerpivot-info.com/post/66-step-by-step-guide-on-installing-powerpivot-for-sharepoint
Then I followed the steps on: http://technet.microsoft.com/en-us/library/bb326356(SQL.105).aspx and http://msdn.microsoft.com/en-us/library/aa905871(SQL.105).aspx to enable Microsoft SQL Server 2008 R2 Reporting Services integration for Microsoft SharePoint Server 2010.
After following these steps, I was able to publish PowerPivot excel reports and Microsoft SQL Server 2008 R2 Reporting Services reports to one top level site collection on Microsoft SharePoint Server 2010. See screen dumps:
Start Microsoft SQL Server 2008 R2 setup > Installation > New installation or add features to an existing installation
New installation or add shared features
SQL Server Feature Installation
Reporting Services
Instance Configuration
Server Configuration
Start Reporting Services Configuration Manager
Choose Report Server Instance
Create a new report server database
Report Server Database Configuration Wizard
Report Server Mode > SharePoint Integrated Mode
Additional actions in Reporting Services Configuration Manager
Web Service URL > Apply
Report Manager URL > Apply
The SharePoint 2010 pre-requisite installer now automatically guides you to download and install the Reporting Services 2008 R2 for SharePoint 2010 Add-in. Btw, you can download the Reporting Services add-in manually as well. In most cases you can just activate the Report Server Feature in SharePoint Central Administration (http://technet.microsoft.com/en-us/library/bb677366(SQL.105).aspx). In some case you must first download and install the add-in manually, in my case I re-configured the Reporting Services 2008 R2 for SharePoint 2010 Add-in and then activated the Report Server feature on the Central Administration site.
Reconfigure the Microsoft SQL Server 2008 R2 Reporting Services Add-in > Start > Control Panel > Programs and Features > Right click SQL 2008 R2 Reporting Services SharePoint 2010 Add-in > Configure
Activate Report Server Integration Feature and Report Server Central Administration Feature > Central Administration > Site Actions > Site Settings > Site Collection features
Configure Reporting Services Integration > Central Administration > General Application Settings > Reporting Services Integration
Reporting Services > Reporting Services Integration
Reporting Services > Set server defaults
Create a Report Library > Site Actions > More Options > Report Library
Enable Report Server Content Types
http://technet.microsoft.com/en-us/library/bb326289(SQL.105).aspx
Create a Report > Report Library > Documents > New Report Builder Report (Click once deployment Report Builder 3.0 should start)
Run click once deployment Report Builder 3.0 (78.2 MB)
Create you’re first report
The Microsoft SQL Server 2008 R2 sample databases can be found at: http://sqlserversamples.codeplex.com/ (82.5 MB). At this moment the November CTP sample database are the last version. RTM sample database should be released soon.
Save the report to SharePoint 2010
Open report in Microsoft SharePoint 2010
Result full screen
Result as webpart
Hello,
It’s really nice blog about sharepoint 2010
SharePoint is a fastest growing product and is implemented by over 18000 companies all over the world. It provides you various benefits
Thanks
Hi Roel,
Thanks for sharing this. I implemented alike it without any problems. One thing: I did not understand why you created a second instance (Reporting2008) and later you create the database in the PowerPivot Instance. I used “Add features to an existing instance”, adding the Reporting Service to the PowerPivot instance and this works fine as well.
Anyway it is the result that counts and thanks again!
Groetjes, Frits
Nice post.Microsoft SharePoint is one of the most popular platforms for organisations to collaborate on work tasks and pool resources.Using Sharepoint 2010, businesses can set up websites and share information quickly and easily.
Thanks.
SharePoint Consulting
Hi Roel,
I have one big question I never found a clear ansewer: shall we setup SQL and SPT on the same server or on 2 different servers? In case of ‘two different servers’ where can I find a best proctice to do that (step-by-step guide)?
wkr
Beat
Dear All,
I would really appreciate if any one could guide me that – Does SharePoint Analysis services meaning one report building, i mean where does the OLAP and MOLAP come in?