HTTP Error 401.1 - Unauthorized
in [Reports]
|
Prev: Reportviewer Error Rendering Control on Sharepoint Designer
Next: Export To Excel throws Error WrapperReportRenderingException
From: Nedim on 5 Nov 2007 09:12 I have a Windows .Net 2.0 application that uses SQL Reporting Services 2005 (on a remote server). Everything works fine when developing that is, when both the server and the program are on the same system. But when the programe is on the client machine and the server different system, I get the following error: System.Net.WebException: The request failed with HTTP status 401: Unauthorized. at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods(). Aside from setting the server url and report path in the designer, only the following code is happening programatically for choosing the report this.reportViewer1.ServerReport.ReportPath = "/reportFolder/" + repName; I tried setting permissions fro everyone on reports folder, putting SetDataSourceCredentials method, nothing helped. Pls help :)
From: EMartinez on 5 Nov 2007 22:39 On Nov 5, 8:12 am, Nedim <Ne...(a)discussions.microsoft.com> wrote: > I have a Windows .Net 2.0 application that uses SQL Reporting Services 2005 > (on a remote server). Everything works fine when developing that is, when > both the server and the program are on the same system. > But when the programe is on the client machine and the server different > system, I get the following error: > System.Net.WebException: The request failed with HTTP status 401: > Unauthorized. at > Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods(). > Aside from setting the server url and report path in the designer, only the > following code is happening programatically for choosing the report > > this.reportViewer1.ServerReport.ReportPath = "/reportFolder/" + repName; > > I tried setting permissions fro everyone on reports folder, putting > SetDataSourceCredentials method, nothing helped. > Pls help :) This link might help. http://forums.asp.net/p/1160280/1916444.aspx#1916444 Also, you want to make sure that the user used in the application at least has Browser rights in the Report Manager. Hope this helps. Regards, Enrique Martinez Sr. Software Consultant
From: Nedim on 6 Nov 2007 03:58
After adding the domain in security, I got a new error, which is displayed in report viewer. client found response content type of 'text/html' but expected 'text/xml'. The request failed with the error message: -- The page cannot be displayed because an internal erver error has occured. "EMartinez" wrote: > On Nov 5, 8:12 am, Nedim <Ne...(a)discussions.microsoft.com> wrote: > > I have a Windows .Net 2.0 application that uses SQL Reporting Services 2005 > > (on a remote server). Everything works fine when developing that is, when > > both the server and the program are on the same system. > > But when the programe is on the client machine and the server different > > system, I get the following error: > > System.Net.WebException: The request failed with HTTP status 401: > > Unauthorized. at > > Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods(). > > Aside from setting the server url and report path in the designer, only the > > following code is happening programatically for choosing the report > > > > this.reportViewer1.ServerReport.ReportPath = "/reportFolder/" + repName; > > > > I tried setting permissions fro everyone on reports folder, putting > > SetDataSourceCredentials method, nothing helped. > > Pls help :) > > > This link might help. > http://forums.asp.net/p/1160280/1916444.aspx#1916444 > Also, you want to make sure that the user used in the application at > least has Browser rights in the Report Manager. Hope this helps. > > Regards, > > Enrique Martinez > Sr. Software Consultant > > |