Answered by:
Repoting Service 401: Unauthorized

Question
-
I have a problem when want to preview reporting service report from reportviewer with 401:Unauthorized message.
Environment:-
- Application (ASP.net) run from Web Server A
- Reporting Service run from Web Server B
- Both server configured with windows authentication
- application added with <identity impersonate="true"/> in the web.config
- We want to use windows authentication.
Senario:-
- A) When running the application from Sever A, No Problem.
- B)When running the appliocation from Client pc, 401:Unauthorized.
Checking:
- For senario A, we check Server A and B IIS log, user credential passed to both server.
- For senario B, creatdential only apprear at Server A, not server B ( that's y Unauthorized).
Try Out:
- A) We have tried some code where adding username and password to the <identity impersonate setting. Doing so, it is working fine.
- B) create CustomReportCredential class and passwing the UserName and Password. It is working.
As you notice try out A and B also using hardcoded Username and Password. But what we want is the Credential should based on the User that using the application that's why we want to use Windows Authentication. If hardcode Username and Password it will defeat the purpose.
Is the the problem in Report Service or IIS?
Can someone give us some light ?
- Moved by Cindy Meister MVP Friday, April 3, 2009 9:11 AM not VSTO, and not sure what the correct forum is
Friday, April 3, 2009 7:21 AM
Answers
-
Hello Maven,
Thank you for your post! I would suggest posting your question in the 'Home › ASP.NET Forums » Advanced ASP.NET » SQL Server Reporting Services' located here: http://forums.asp.net/191.aspx
Have a great day!
Thanks!
SachinW Tier 2 Application Support Server and Tools Online Engineering Live Services TeamFriday, April 3, 2009 12:06 PM -
Hi There,
Thank you for your post! I would suggest posting your question in one of the MS Forum,
Home › ASP.NET Forums » General ASP.NET » Security
located here: http://forums.asp.net/25.aspx
Have a great day!
Shrikant Maske Tier 2 Application Support Server and Tools Online Engineering Live Services Team- Proposed as answer by Shrikant Maske Friday, April 3, 2009 12:29 PM
- Unproposed as answer by Shrikant Maske Friday, April 3, 2009 1:14 PM
- Proposed as answer by Shrikant Maske Friday, April 3, 2009 1:14 PM
- Marked as answer by Shrikant Maske Wednesday, May 20, 2009 9:22 AM
Friday, April 3, 2009 12:29 PM
All replies
-
I don't know why you asked this in the VSTO forum, but it's definitely off-topic here. I'm moving the message to the "Where is the forum for..." forum for re-direction...
Cindy Meister, VSTO/Word MVPFriday, April 3, 2009 9:10 AM -
Hello Maven,
Thank you for your post! I would suggest posting your question in the 'Home › ASP.NET Forums » Advanced ASP.NET » SQL Server Reporting Services' located here: http://forums.asp.net/191.aspx
Have a great day!
Thanks!
SachinW Tier 2 Application Support Server and Tools Online Engineering Live Services TeamFriday, April 3, 2009 12:06 PM -
Hi There,
Thank you for your post! I would suggest posting your question in one of the MS Forum,
Home › ASP.NET Forums » General ASP.NET » Security
located here: http://forums.asp.net/25.aspx
Have a great day!
Shrikant Maske Tier 2 Application Support Server and Tools Online Engineering Live Services Team- Proposed as answer by Shrikant Maske Friday, April 3, 2009 12:29 PM
- Unproposed as answer by Shrikant Maske Friday, April 3, 2009 1:14 PM
- Proposed as answer by Shrikant Maske Friday, April 3, 2009 1:14 PM
- Marked as answer by Shrikant Maske Wednesday, May 20, 2009 9:22 AM
Friday, April 3, 2009 12:29 PM