none
Cannot access to CrystalReportViewer in first-time access (ASP.NET page, Single Sign-on) RRS feed

  • Question

  • Greeting everyone, I added CrystalReportViewer control in my custom ASP.NET page. And I wanna user can experience single sign on features in my web application.

     

     

    The site map as follows:

    - Home (SSO is preferable, with top ten product list retrieved from custom DB – by using Windows Authentication)

    - Report (SSO is preferable, retrieved data from custom DB – by using Windows Authentication)

    - Document List (SSO is preferable, with iFrame and pointed to SharePoint Web Part)

     

     

    After I deployed the web application to IIS, I tried to login Windows as a domain user account. I can access Home page and Document List without login prompt(using IE 11).

     

     

    Btw, when I tried to view report, browser prompts Windows login and require user name / password. After I click cancel and “401 - Unauthorized” displayed.

    I can read crystal report viewer when I go to the page again and no more login required.

     

     

    I can reproduce the problem after I restarted IIS or access the same page by using other user account. May I ask your advice & help?

     

     

    Supplement information for server environment listed here:

    - SAP Crystal Reports 2013 Support Pack 1

    - Visual Studio Professional 2012

    - .NET Framework 3.5

    - Windows Server 2012

    - CrystalReportViewer control

    - CrystalDecisions.Shared (v 13.0.8.1216)

    - CrystalDecisions.Web (v 13.0.8.1216)

    - CrystalDecisions.CrystalReports.Engine (v 13.0.8.1216)

    - Report Template Folder permission (under IIS folder)

    -> Domain Users: Read, Read & Execute

    -> Domain Administrators: Full Control

     

    Thanks,

    Tony

    Monday, June 23, 2014 7:08 AM