Reporting Services Web Service
in [Reports]
|
Prev: SSRS cannot work with IIS 7 in 64 bit Windows 2008
Next: Report export fails with with exception: System.IO.IOException: The file exists
From: Bob on 1 Oct 2008 04:11 I have two identical report servers one of which is for development (localhost) and the other is production. From an ASP.NET project I try to add a Web Service Reference. When I do this to http://localhost/ReportingServices all works fine. If I try to do the same thing to the production server say:- http://a.b.c.d/ReportingServices I am prompted for a username and password. On both servers there is a single data source that uses SQL server credentials stored securely. No other passwords are set and there is no big security requirement. I have a web service set up on the same machine that I can access with no problems nor credentials. No combination of passwords that I have tried will work. What can possibly be needed please? Versions - Visual Studio 2008 SP1 SQL Server 2005 SP2 -- Bob
From: Bob on 1 Oct 2008 10:16
Further to my own question:- Via IIS I can configure anonymous access but then any attempt to connect to the web service tells me that IUSER_XXX has insufficient permissions. If I opt for basic security then I can enumerate reports available using IE by simply pointing IE at http://a.b.c.d/ReportServer and answering the security prompt. However if I try to add a web service reference I answer the security prompt and get this gibberish (IP address edited):- The HTML document does not contain Web service discovery information. Metadata contains a reference that cannot be resolved: 'http://a.b.c.d/ReportServer'. The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="CSHARP.LOCAL"'. The remote server returned an error: (401) Unauthorized. If the service is defined in the current solution, try building the solution and adding the service reference again. I should point out that the site is about as confidential as a soap commercial (washing soap that is) so this whole security business is getting VERY tedious! Help! Bob -- Bob "Bob" wrote: > I have two identical report servers one of which is for development > (localhost) and the other is production. > > From an ASP.NET project I try to add a Web Service Reference. When I do this > to http://localhost/ReportingServices all works fine. > > If I try to do the same thing to the production server say:- > http://a.b.c.d/ReportingServices I am prompted for a username and password. > > On both servers there is a single data source that uses SQL server > credentials stored securely. No other passwords are set and there is no big > security requirement. > > I have a web service set up on the same machine that I can access with no > problems nor credentials. > > No combination of passwords that I have tried will work. What can possibly > be needed please? > > Versions - Visual Studio 2008 SP1 > SQL Server 2005 SP2 > -- > Bob |