January 31, 2009 at 5:29 pm
I receive Report Viewer error "The request failed with HTTP status 401: Unauthorized." only for one user on one workstation. The other 15 users on otehr boxes do not receive the error. I am pretty sure it is not a permission issue on the Report Server box, because I performed the following test.
Workstation A:
The common user is domain\KLW (has domain admin rights)
I receive the error when this user tries to use Report Viewer.
Workstation B:
The common user is domain\REF (has domain admin rights)
Report Viewer works fine.
I added domain\REF as user to Workstation A.
Report viewer works fine.
I added domain\KLW as user to Workstation B
Report Viewer works fine.
Thus the issue is something about the setup of KLW on Workstation A.
I uninstalled Framework 3.5, 3.0, and 2.0. Then reinstalled. Same error for user KLW. Any suggestions would be greatly appreaciated.
Doug Perkinson
February 2, 2009 at 11:20 am
Unless you are assigning permissions based on workstation names (instead of user ids) it should not matter what workstation any user signs on to. The report server may have a setting to deny access from the network for that workstation...it would have to be something unusual like that. Can you post more details?
February 2, 2009 at 12:01 pm
I am not basing permissions on machine name. I am tihinking that something became fouled up with a setting for user KLW on workstation A. I say that because that user can log onto any other workstaion and does not receive http 401 error. Additionally, I can log onto workstation A as any user OTHER than KLW and no http 401 error occurs. It therefore must be a setting on workstation A under the KLW user account.
[Thinking out loud]
1) Would there be any security permissions in IE that would prevent communications with the local (intranet) ReportServer.
2) Are .Net Framework settings user specific? Could a setting for that user have become corrupt?
Thanks,
Doug
February 2, 2009 at 12:09 pm
Would it be possible to delete the user's profile off of the suspect machine?
right click my computer, choose properties, advanced tab, user profiles...this would give you a fresh start....
February 2, 2009 at 12:59 pm
Bob,
I was saving that as my last resort. I really prefer to avoid that if possible.
I'm going to try one more thing tonight. I'm leaning toward it being a Framework issue. When I was installing Framework 3.5 SP1, it 'hung' before completing the install. Though I uninstalled and reinstalled 3.5, I read that the Windows Add/Remove Programs function does not always 'completely' remove all Framewrok related entries. I came across a utility that is supposed to 'gut' Framework entirely from a computer. I can then reinstall back up to 3.5 SP1.
Care to share your thoughts that a Framework registry or config file, referencing this specific user account, could be causing a http 401 error with the Report Server?
Doug
February 2, 2009 at 1:57 pm
Just outta curiosity, since a 401 error is security related, have you seen any messages in the Client Event viewers and/or the Server security logs stating how the authentication failed? could it perhaps be that you are forcing some sort of log in to your reporting server and the client chose to have windows remember the password, which if you ask they'll swear up and down they typed correctly but we all really know they entered the wrong password?
I'm guessing you've already tried this, but how about deleting all browser cookies, and other temporary files...
February 2, 2009 at 2:02 pm
Also, in the IE security settings for your intranet zone (I'm guessing that's where your SSRS server is)
IE Options, security Tab, Intranet Zone, settings, how is the User Authentication setting (scroll all the way down) set? If it's set to anonymous and your server doesn't allow anon connections that could be the issue. Also, this is a per user/Per Machine Setting unless of course you are enforcing it with a GPO.
-Luke.
February 2, 2009 at 6:58 pm
IE User Authentication is set to "Automatic logon only in in Intranet", which is the same setting as the new user (REF) user account I created. When logged on as REF, I don't receive the 401 error. I also deleted all cookies and temp files. I'm not sure there is much more within IE interface that I can rest.
Do you know if any user login information is stored in and Framework registry or config files on the workstation?
Doug
February 3, 2009 at 7:12 am
I'm not sure if it's stored within the framework or anywhere else (I'm a data guy not an app dev, I just play one on TV), but if you're hesitant to dump the user's profile due to local settings, documents (READ: .pst's), etc. stored within the profile you could always log in with an administrative account, copy the user's profile to another folder (make sure it all gets there so you don't get screwed!) and then delete the existing profile and log in with the user to create a new profile and copy back in the more important folders like those below (this is not an inclusive list)
My Documents,
Desktop,
App Data|Microsoft|Outlook,
App Data|Microsoft|Proof,
App Data|Microsoft|Signatures,
Local Settings|Application Data|Microsoft|Outlook
IE Favorites
Things in the above list should have nothing to do with Framework settings.
Another alternative could consider is the User State Migration tool to copy the profile to another machine or location to delete and reload it.
-Luke.
February 3, 2009 at 7:30 am
Thanks alot. I've decided to stop wasting time trying to find the error in the current user's configuration. I'll going forwward with creating a new user profile as you have suggested.
Thanks again for your input.
Doug
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply