After SQL Server Reporting Add-in Install cannot access PWA
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.RRankin
February 8th, 2011 4:23pm
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: 10.1.0.52
User: NT AUTHORITY\NETWORK SERVICE
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.RRankin
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2011 4:26pm