SSRS and SharePoint

Question

In order to use SSRS and SharePoint 2010 Enterprise what do you have to do to the SQL Server? Do you have to uninstall anything? Or do you just install the add in to the SharePoint Server? I want to know how to get SQL and Sharepoint working together without uninstalling anything. Is that possible?

Answer 1

Hi LNFei,

You do not have to uninstall anything, if you are using SSRS 2008 R2, we should have these steps:

1. Install SQL Server 2008 R2 November CTP Reporting Services and specify that the report server use SharePoint Integrated mode, if you have already install the SSRS in native mode, you can change to it to integrated mode using SSRS configuration tool.
2. Configure Reporting Services.
3. Install Reporting Services Add-in on the SharePoint.

For more information, you can refer to this link http://msdn.microsoft.com/en-us/library/cc281311.aspx

If you are using SQL Server 2012 RC0, you can refer to Robert's reply at this thread http://social.msdn.microsoft.com/Forums/en-US/sqldenreportingservices/thread/4beb3d1a-b20c-424b-bdeb-1b49316cfc4c 

Thanks,
Challen Fu

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.