The request failed with HTTP status 401: Unauthorized.

RamaSagar Pulidindi

RamaSagar Pulidindi

Apr 17 2014 1:49 AM
Hi Fellas,

After struggling for two days and tried all the things found by googling i am fedup of the problem so
i am posting it here. The problem is

I have SQL Server 2008 RS2 installed Windows Server 2008 by using local administrator and i selected the option
install and configure Reporting Services while installing the SQL Server. i can open the report
from both http://ServerIP/ReportServer/ and can mamnge from http://ServerIP/Reports/Pages/Folder.aspx and can
also view the report from an aspx page using report viewer
But the problem is that when i try to open the report from the IIS server after publishing i am having the exception
 "The request failed with HTTP status 401: Unauthorized". I cant figure it out what is the problem.

I tried to give full rights to the folder ReportServices under SQL Server folder in Program Files.
but to success. i also tried by closing the firewall and failed again.

i tried to put following tag inside <system.web>

<identity impersonate="true" userName="sagar" password="***"/>

i tried in many ways but im not able to find the solution.

Can anyone help me to solve this problem i will be thankful.

Answers (1)