July 19, 2006 at 3:52 pm
Hi
I am using url and soap acces in my project. There is no problem with url.
However with SOAP access to open a report (the Reporting server is the same) from my localhost I have no problem.
But when I try opening the same report on test server I get the following error.
Any suggestions.
Thanks.
System.Web.HttpUnhandledException: Exception of type System.Web.HttpUnhandledException was thrown. ---> System.Net.WebException: The request failed with HTTP status 401: Unauthorized.at System.Web.Services.Protocols.SoapHttpClientProtocol.
ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
July 24, 2006 at 8:00 am
This was removed by the editor as SPAM
August 3, 2006 at 1:18 pm
An error of 401 Unauthorized probably means you
a) Don't have default access to the database the report draws from
b) Are using an SSL connection and forgot to enter username/password
If your report doesn't have default credentials set up for its database, you'll have to create a new DataSourceCredentials element in your SOAP, something like:
<Credentials>
<DataSourceCredentials>
<DataSourceName>dbname</DataSourceName>
<UserName>user</UserName>
<Password>password</Password>
</DataSourceCredentials>
</Credentials>
If you're using a secure connection, you'll have to set up the SSL ahead of time before passing the SOAP. I've only ever done this in C#, which makes it stupid easy to do -- create a new NetworkCredential object and assign it to ReportService.Credentials before calling ReportService.Render.
EDIT: Don't know why my name got set to Takumi, but ok.
August 3, 2006 at 1:25 pm
NT allows only a single hop between servers. On your desktop, It's not an issue as the client and website are on the same server. You're only hop for authentication is to the report server. Soon as you go to production, you add an additional hop in and authentication fails.
You can move the app and report server to the same box or look into using Kerberos to allow for multiple hops.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply