Re: The request failed with HTTP status 401: Unauthorized.

The solution is here
http://www.taznetworks.com/rss/2006/03/crm-30-sbe-sql-reporting-error.html

and / or here http://support.microsoft.com/default.aspx?scid=kb;en-us;896861

This was driving me crazy so I am posting the answer everywhere I saw someeone
else asking and getting no answers.

Hi,
 I have just installed MSRS 2005 & created & deployed a report at
Http://<MySrvr>/ReportServer & report path is
RerportProject/SampleReport
 using VS 2005 I just dragged & dropped the report viewer control on a web
page & set the properties as follows
 ServerReport -> ReportPath = RerportProject/SampleReport and ReportServerUrl
= Http://<MySrvr>/ReportServer and when I run this page I am getting this
error "The request failed with HTTP status 401: Unauthorized.", 

 I've also tried with writing the following code in the page load event
 ReportViewer1.ServerReport.ReportPath =
"/ReportingProject/EmpReport";
 ReportViewer1.ServerReport.ReportServerUrl =new
Uri("http://cs042/ReportServer");
 even this is causing tha same problem

 I even tried this solution
 1. Click Start, click Run, type regedit, and then click OK.
 2. In Registry Editor, locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
 3. Right-click Lsa, point to New, and then click DWORD Value.
 4. Type DisableLoopbackCheck, and then press ENTER.
 5. Right-click DisableLoopbackCheck, and then click Modify.
 6. In the Value data box, type 1, and then click OK.
 7. Quit Registry Editor, and then restart your computer.
 but it still not working.

 I've worked on MSRS 2000 also so I added the old ReportViewer control on to my
webpage with that the report is displayed fine, i dont under stand why the
reportviewer control of 2005 is causing problem

Yes I've done it. You just need to add identity impersonate = true in the
web.config, that's it..