locked
View Report From Web Application Without Prompting Authentication - Reporting Services 2017 RRS feed

  • Question

  • My company just finish set up a reporting services server 2017. The service run under a domain name. At the same server, an IIS has been setup to run a web application in ASP.NET which will server the report from a report viewer. The IIS is currently running with default App Pool.

    GOAL : We want client to be able to access the report from the web application without having to fill in the username and password from anywhere be it on intranet or internet.

    Before this, we have ssrs 2008 with similar setup but for authentication we go with anonymous authentication, which is what we want, they can view report from anywhere. But from microsoft site, they stated that authentication isn't supported anymore in the latest version, and we have tried doing it which results in error 401: Unauthorized.

    Currently, I'm trying to do a kerberos authentication, Things that I have done :

    1. SPN for reporting services account.
    2. Delegation for reporting services account.
    3. Web application web.config I've added authentication mode="Windows" identity impersonate="true"
    4. On IIS, I've enabled windows authentication and impersonate.

    But when I try to request a report from the web application, I still got the prompt for username and password, when I fill in my domain and password, I still got the same error 401: Unauthorized.

    Am I doing something wrong? Is Kerberos really suitable for my GOAL?

    Thanks in advance.

    EDIT : Sorry, If I am posting in the wrong section. I don't know where is the correct section for this question.

    Thursday, October 8, 2020 3:36 AM

Answers

  • daim2604 --

    You have erroneously posted your SQL Server question in a public user forum dedicated to question about Microsoft Project Server, an enterprise project management application.  I would recommend you repost your question to one of the SQL Server sections of the Microsoft Q&A user forum at:

    https://docs.microsoft.com/en-us/answers/products/sql-server

    Hope this helps.


    Dale A. Howard [MVP]

    Thursday, October 8, 2020 3:55 PM