After SQL Server Reporting Add-in Install cannot access PWA RRS feed

  • Question

  • The add-in for SQL Server Reporting was successfully installed and reports can be deployed to non-PWA sites.  But PWA cannot be accessed, "Unexpected error has occurred."  In Event Viewer there is an ASP.Net Information entry ...

    Event code: 4007
    Event message: URL authorization failed for the request.
    Event time: 2/8/2011 11:37:31 AM
    Event time (UTC): 2/8/2011 4:37:31 PM
    Event ID: 9f18a25a730d43189b118fcce43b3b8b
    Event sequence: 2
    Event occurrence: 1
    Event detail code: 0
    Application information:
        Application domain: /LM/W3SVC/1720207907/root/SharedServices1-1-129416566476528900
        Trust level: Full
        Application Virtual Path: /SharedServices1
        Application Path: C:\Program Files\Microsoft Office Servers\12.0\WebServices\Shared\
        Machine name: SHAREPOINT
    Process information:
        Process ID: 6664
        Process name: w3wp.exe
        Account name: Domain\user  --this was the user that originally installed Sharepoint

    Request information:
        Request URL: http://sharepoint:56737/SharedServices1/PSI/Authentication.asmx
        Request path: /SharedServices1/PSI/Authentication.asmx
        User host address:
        Is authenticated: True
        Authentication Type: NTLM
        Thread account name: Domain\user --this was the user that originally installed Sharepoint
    Custom event details:

    Any ideas would certainly be appreciated.

    • Moved by Mike Walsh FIN Tuesday, February 8, 2011 9:20 PM PWA is Project Server only (From:SharePoint - Setup, Upgrade, Administration and Operation (pre-SharePoint 2010))
    Tuesday, February 8, 2011 5:00 PM


  • Thanks to those who to a look at my question ... I found the problem.  The Application Pool for the web site had Network Service set for pool identity.  When it was changed to match the original install user PWA came back to life.
    Tuesday, February 8, 2011 6:54 PM