The request failed with HTTP status 401: Unauthorized.

Posted by Rama Sagar under Sql Server on 4/17/2014 | Points: 10 | Views : 2303 | Status : [Member] [MVP] | Replies : 0
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.



(No response found.)

Login to post response