Allow IIS Users to view reports in an asp.net application Reporting Services
Hello Guys.. Im making an asp.net web application that generates reports using reporting services and able to view the report on a reportviewer control. I was able to view the report using localhost but was unsuccessful in viewing it through our IIS webserver. Im guessing that the report server doesn't authenticate IIUSRs. i think there nothing wrong with my code because the application runs successfully when i run it on development mode. Problem happens when I publish it into our site. here a sample of my code thou.. to get you guy the idea. IReportServerCredentials irsc = new CustomReportCredentials("administratorr", "12345", @"http://mysite/reportserver"); rptvwer.ServerReport.ReportServerCredentials = irsc; //irsc; ReportParameter[] param = new ReportParameter[6]; param[0] = new ReportParameter("ACCTNO",acctno); param[1] = new ReportParameter("SLCODE", slcode); param[2] = new ReportParameter("DOCNO", docnum); param[3] = new ReportParameter("USERLOG", userlog); param[4] = new ReportParameter("STARTDATE",startdate.Trim()); param[5] = new ReportParameter("ENDDATE", enddate.Trim()); param[0].Visible = false; param[1].Visible = false; param[2].Visible = false; param[3].Visible = false; param[4].Visible = false; param[5].Visible = false; rptvwer.ShowCredentialPrompts = false; Microsoft.Reporting.WebForms.ReportParameter ass = new Microsoft.Reporting.WebForms.ReportParameter(); rptvwer.ProcessingMode = ProcessingMode.Remote; rptvwer.ServerReport.ReportPath = "/MPA_CIREPORTS/"+ coopcode.Trim() + "/" + reportfileext + coopcode.Trim(); rptvwer.ServerReport.SetParameters(param); rptvwer.ServerReport.Refresh(); How do I allow users that access to our site "http://mysite.com/reportofours" to view the reports inside that application. Do i have to set something on the IIS manager? or unto the reporting services? By the way.. Im using ASP.NET on C#, IIS7, SQL SERVER R2 with SSRS R2 as well.. Any references that I could use?
March 29th, 2011 10:48pm

i've found out about impersonation? any idea how to do this? Ive already added <identity impersonate="true" /> to my web.config but still it doesn't authenticate the user.. and thus not view the report on my asp app.
Free Windows Admin Tool Kit Click here and download it now
March 29th, 2011 11:32pm

well i've got it. Just to share it to you guys who have the same problem. you can look at this article here http://technet.microsoft.com/en-us/library/cc281309.aspx I simply replaced the default RSReportServer.config into this: <Authentication> <AuthenticationTypes> <RSWindowsBasic> <LogonMethod>3</LogonMethod> <Realm></Realm> <DefaultDomain></DefaultDomain> </RSWindowsBasic> </AuthenticationTypes> <EnableAuthPersistence>true</EnableAuthPersistence> </Authentication> any other ideas/method to do this? please share.... :)
March 31st, 2011 5:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics