Running SSRS on the Internet

  • Hi,
    I've been trying to find some information about the recommended way to run SSRS on the Internet with the data sources protected by a firewall.  Authentication with Integrated Security.
    I've tried putting SSRS portal in a DMZ with the SSRS database behind a firewall.   HTTPS/SSL provided by a Traffic Manager.
    This gave us HTTPS without having to install SSL on the SSRS server.
    It had side effects though, namely, random drops in connectivity which caused report issues.
    I've read here about adding SSL  to SSRS 
    Do Microsoft offer any recommendations on securing data/authenticating users for this use case?
    The newer versions of SSRS work really well with Mobiles so I'm keen to offer this to users.

  • leehbi - Monday, February 19, 2018 10:22 AM

    Hi,
    I've been trying to find some information about the recommended way to run SSRS on the Internet with the data sources protected by a firewall.  Authentication with Integrated Security.
    I've tried putting SSRS portal in a DMZ with the SSRS database behind a firewall.   HTTPS/SSL provided by a Traffic Manager.
    This gave us HTTPS without having to install SSL on the SSRS server.
    It had side effects though, namely, random drops in connectivity which caused report issues.
    I've read here about adding SSL  to SSRS 
    Do Microsoft offer any recommendations on securing data/authenticating users for this use case?
    The newer versions of SSRS work really well with Mobiles so I'm keen to offer this to users.

    This is an older article but still applicable:
    Planning for Extranet or Internet Deployment

    Sue

  • See this article: http://www.dabcc.com/microsoft-leveraging-web-application-proxy-in-windows-server-2016-to-provide-secure-access-to-your-sql-server-reporting-services-environment/

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Sue_H - Monday, February 19, 2018 11:44 AM

    leehbi - Monday, February 19, 2018 10:22 AM

    Hi,
    I've been trying to find some information about the recommended way to run SSRS on the Internet with the data sources protected by a firewall.  Authentication with Integrated Security.
    I've tried putting SSRS portal in a DMZ with the SSRS database behind a firewall.   HTTPS/SSL provided by a Traffic Manager.
    This gave us HTTPS without having to install SSL on the SSRS server.
    It had side effects though, namely, random drops in connectivity which caused report issues.
    I've read here about adding SSL  to SSRS 
    Do Microsoft offer any recommendations on securing data/authenticating users for this use case?
    The newer versions of SSRS work really well with Mobiles so I'm keen to offer this to users.

    This is an older article but still applicable:
    Planning for Extranet or Internet Deployment

    Sue

    I think the issue with this is that we can't separate out SSRS web front end from the server.  The article above needs development.   Not ideal.   Interesting that Microsoft make SSRS mobile friendly but doesn't provide a secure way to publish.

    Obviously a can of worms.  

    Would :
    DB  --> Firewall -->  SSRS --> Firewall , HTTPS, provide security?

    DB is a data mart so very keen to protect it.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply