SSRS 2008 Add-in for MOSS 2007, Report Viewer 401: unauthorised error
Battling with network issues can be a PITA – battling with network issues AND application errors is a FPITA!
A problem popped up the other day with the Report Viewer, while selecting a report to display in the SQL Server 2008 Report Viewer web part.
We could run the Report Viewer web part on the server itself, but from anywhere else on the network it just didn’t work and it kept throwing this error:
Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.
Rather annoying so we thought the proxy was causing the problem..but, nopes, doesn’t seem like that was the issue as we were told that the internal servers, if addressed via fully qualified domain names, didn’t get proxied.
ok…what else to do? some suggested Alternative Access Mappings were wrong…tried to add what was “missing” there..still a no go.
It was obvious that something was dropping off the authentication request somewhere as we were running in “Windows Authentication” mode, using NTLM.
Go to the SharePoint 3.0 Central Administration –> Application Management –> Reporting Services –> Manage Integration Settings and change the Authentication Mode to “Trusted Account”..
Now, of course, i need to find out why Windows Authentication mode isn’t working…at least we can proceed now.