Click here to Skip to main content
16,013,322 members
Please Sign up or sign in to vote.
3.50/5 (2 votes)
See more:
Hello

I have a ssrs report which i have deploy on server and the ID is :- http://192.168.10.47/ReportServer_SQL2008R2[^]

which is working nicely , but if i am working the the server system then it is working but if i am working on client system then it is not working showing error : -

The request failed with HTTP status 401: Unauthorized.

when i run it on server every time it is asking for credential username and password.

I have go through google search but it is not working.

if any proper solution then please replay.

My code is :-

ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://192.168.10.47/ReportServer_SQL2008R2/Pages");
ReportViewer1.ServerReport.ReportPath = "/SSRS_REPORT/Customer List";
ReportViewer1.ServerReport.Refresh();

ReportParameter parm = new ReportParameter();
parm = new ReportParameter("Branch_Id", "1");
ReportViewer1.ServerReport.SetParameters(parm);
ReportViewer1.ServerReport.Refresh();
Posted

 
Share this answer
 
Authentication is missing, check this article
SSRS 2012 Forms Authentication[^]

Check this page for many tips related to SSRS
Rules to Better SQL Reporting Services[^]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900