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.
ramasagar