none
SSRS 2016 Mobile Reports For External access RRS feed

  • Question

  • What is required to allow external users access to SSRS 2016 Mobile reports, excluding Power BI Service. Power BI Mobile apps do not seem to allow it.

    Is it possible to set up an external facing SSRS Web portal (SQL 2016) which shares the Reporting Services db and TEmpdb, so no duplicate maintenance/deployment of reports is Required? I can find NO recent docs about how to do this?

    If we do a custom web app which displays reports via Iframe - will report interactivity still work? If not, how might that be overcome?

    Otherwise,

    Must we go with SSRS VPN hosted in Azure with AD replication ?

    Or what might be a good solution for this?


    Distinguished Data Analytics Architect - Mariner http://www.mariner-usa.com

    Tuesday, May 16, 2017 6:31 PM

All replies

  • Hi Wayne Snyder,

    Based on my understanding, you want to configure SSRS 2016 mobile reports for external access, right?

    As you know, it is not possible to allow external users to visit the report server via Power BI Mobile app. As mobile apps support both Basic and NTLM authentication for Reporting Services,  it can only accept the internal connections to view SSRS 2016 mobile reports.

    For your requirement, you can use Web Portal to view reports over an internet or extranet connection. Please refer to below summary steps:

    1. Install Reporting Services on an Internet-facing Web server using the files-only installation mode.
    2. Create and deploy a custom security extension to support forms authentication or a single-sign on technology.
    3. Configure Report Manager for minimal permissions. The Browser role and System User role are sufficient for viewing reports.
    4. To point Report Manager to a different report server instance that runs on a separate computer, you must configure the Report Manager URL and then modify the <ReportServerVirtualDirectory> and <ReportServerUrl> settings in the RSReportServer.config file to point Report Manager to the report server instance.
    5. On the report server that you are connecting to, turn off features that you will not use.

    For more detailed introduction, please see this MSDN document: Planning for Extranet or Internet Deployment

    Best regards,
    Yuliana Gu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Yuliana Gu Monday, May 22, 2017 6:34 AM
    Wednesday, May 17, 2017 2:35 AM