none
How do I find out if SSRS is Intregrated or Native?

    Question

  • I'm new to SharePoint 2013.  We are using SQL 2012 SP1.  SharePoint was setup by someone else.  How do I tell if we are using SSRS in integrated or native?  Central Administrator shows SSRS is started and is pointing to our Database server for SharePoint.  I don't see SQL Reporting Service running on the Database server.

    Thanks

    Thursday, July 24, 2014 9:25 PM

Answers

  • Hi D84,

    According to your description, you want to identify the mode of the report server.

    For SSRS 2008 R2 or early versions, we can identify report server mode using the Reporting Services Configuration Manager. For SSRS 2012 or later versions, Reporting Services Configuration Manager no longer supports Reporting Services SharePoint mode. Configuration of SharePoint mode is completed using SharePoint Central Administration. Then we can verify whether we are using SharePoint integrated mode or not by following steps:

    1. From SharePoint central administration, click Manage services on server, verify the SQL Server Reporting Services Service is installed and in the Running state.
    2. Verify the Web Application Association is configured to point to the desired web application. If you click the name of the service application it will open the Management pages of the service application.
    3. In site settings, click Site collection Features, verify the Report Server Integration Feature is active.
    4. Verify you can launch Report Builder. We can create a basic report that only contains a text box and does not contain any data sources or datasets, save the report to the document library and the run the report from the library.


    For more information about verifying the installation depend on the report server mode, Please refer to the article below:
    http://msdn.microsoft.com/en-IN/library/ms143773.aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Wendy Fu

    Tuesday, July 29, 2014 6:15 AM
    Moderator

All replies

  • Hi ,

      You can find the SSRS mode from "Report Services Configuration Manager". Launch the Configuration Manager from Start--> All Programs --> Microsoft SQL Server 2012 -- > Configuration Tools -- > Report Services Configuration Manager


    Best Regards Sorna

    • Proposed as answer by PrajapatiNeha Friday, July 25, 2014 8:54 AM
    Friday, July 25, 2014 8:35 AM
  • That's true but configuration manager doesn't see any Reporting Services running on the database server where Central Administrator, Manage Service Applications, Properties (Reporting Services).

    So what type of SSRS is this?

    Friday, July 25, 2014 6:11 PM
  • Hi D84,

    According to your description, you want to identify the mode of the report server.

    For SSRS 2008 R2 or early versions, we can identify report server mode using the Reporting Services Configuration Manager. For SSRS 2012 or later versions, Reporting Services Configuration Manager no longer supports Reporting Services SharePoint mode. Configuration of SharePoint mode is completed using SharePoint Central Administration. Then we can verify whether we are using SharePoint integrated mode or not by following steps:

    1. From SharePoint central administration, click Manage services on server, verify the SQL Server Reporting Services Service is installed and in the Running state.
    2. Verify the Web Application Association is configured to point to the desired web application. If you click the name of the service application it will open the Management pages of the service application.
    3. In site settings, click Site collection Features, verify the Report Server Integration Feature is active.
    4. Verify you can launch Report Builder. We can create a basic report that only contains a text box and does not contain any data sources or datasets, save the report to the document library and the run the report from the library.


    For more information about verifying the installation depend on the report server mode, Please refer to the article below:
    http://msdn.microsoft.com/en-IN/library/ms143773.aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Wendy Fu

    Tuesday, July 29, 2014 6:15 AM
    Moderator