I have an ASP.NET web application on one server trying to access a report server on another. When the web application tries to take any action through the web service, it receives a "401: Unauthorized" error.
Both servers use Windows Server 2008, the SQL Server is running SQL 2008 (SP1). Both servers are on the same domain, but authentication is set up through a local account defined on the SQL machine (local Windows user, using Windows authentication).
I can successfully access the //server/reports and //server/reportserver sites from the app server using Internet Explorer with the credentials set up on the sql server. I can successfully authenticate & browse to //server/reportserver/reportservice2005.asmx and
see the wsdl file. The problem only exists when the web app itself tries to use the SSRS web service endpoint. Kerberos is set up, but not being used for this exchange.
Here is a simplified version of my code trying to do the exchange that fails with "401: Unauthorized":
ReportingService2005 rs = new ReportingService2005();
rs.Url = "http://server/reportserver/reportservice2005.asmx";
CredentialCache cache = ne
View Complete Post