Problem to generate ssrs reports from application
Hi,
After a lot of googling, i am posting this question. I am facing problem withh ssrs reports
Actually i am using 2 different servers. In one server i have SQL Server 2008, SSRS reporting Services has Windows 2008 server.
In another server i have my application, has windows 2003 server.
Now, i have deployed my reports in server and its working properly in that particular server even the Url 'http://<servername>/reportserver' also working out of that server properly, but when i am trying to open these reports from application its giving
an error like
"Request Failed with HTTP Status 401:Unauthorised".
and also one thing whenever i am using Url 'http://<servername>/reportserver' its aking for windows credentials. after giving them , the report is getting generated.
Please give your valuable suggestions and solutions as soon as possible.
Thanks & Regards
Jyoshna
jo
August 21st, 2012 4:54am
Hi Jyoshnaa,
Go to the report rdl and provide credential in DataSource over there and click on the SAVE PASSWORD option and then redeployed the same.
Amit
Please mark as answer if helpful
http://fascinatingsql.wordpress.com/
Free Windows Admin Tool Kit Click here and download it now
August 21st, 2012 7:35am