Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
SSRS and SharePoint

Answered SSRS and SharePoint

  • Monday, January 16, 2012 11:55 PM
     
     
    Sign In to Vote
    0

    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?

     

All Replies

  • Wednesday, January 18, 2012 5:36 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    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.