SQLServer 2008 R2 Reporting Service websevice url does not display with custom authentication
Hi:
I have installed SQLServer2008R2(CUD3) (64bits on Windows7) Reporting Service with custom authentication. I can log in to the report server and report manager and everything appears fine, but the webservice url:
http://myhost/ReportServer/ReportService2005.asmx no longer works (The webservice url did display before I put int custom authentication). I got a html back with error message.
This webservice url used to be not protected. I wonder if this is something changed in 2008R2 and it is a bug, or something I did not do it right.
Thanks for any help!
<html>
<head>
// some info here
</head>
<body bgcolor="white">
<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Access is denied.</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.
<br><br>
<b> Error message 401.2.: </b>Unauthorized: Logon failed due to server configuration. Verify that you have permission to view this directory or page based on the credentials
you supplied and the authentication methods enabled on the Web server. Contact the Web server's administrator for additional assistance.<br><br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4955
</font>
</body>
</html>
December 2nd, 2010 11:57am
Hi Larry,
Every connection to SQL Server Reporting Services(SSRS) must be authorized. Once we configure the SSRS to use Forms Authentication, and use URL to access the SSRS web services directly, the credential might be not valid. It is not authorized. This is why
we encounter the error "Unauthorized: Logon failed due to server configuration.".
To solve the issue, please open the Report Manager or Report Server and login before accessing the web services.
If we would like to access the web serivces from a ASP.NET application, we need to implement custom authentication cookie. The following article details the steps:
http://blogs.msdn.com/b/bimusings/archive/2005/11/04/489100.aspx
If you have any more questions, please feel free to ask.
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2010 12:38am
Hi, Jin Chen:
I got exactly the same error content even after I logged in the report server. My Report Server or Report Manger works fine. My client application consuming web service also works. The only problem is the web service wsdl xml is not delivered
from the URL. I checked the previous version (SQLServer2008) and confirmed that authentication is not required to display the webservice wsdl. But the R2 release is different. Even after logged in, the wsdl url still does not work.
If you have any ssrs from SQL2008R2 that is configured with form authentication, please check to see if you could get wsdl xml from URL.
Thanks.
Larry
December 3rd, 2010 12:56pm
Hi Larry,
I tried to reproduce the issue. In my environment, when I try to access
http://localhost/reportserver/reportservice2005.asmx, the report server required me to login. This is expected.
I suppose there may some configuration settings missing from the configuration files. Could you please double-check them again?
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
December 9th, 2010 4:29am
Hi Jin:
I reversed back to Windows integrated security and everything worked. Then I reconfigured the custom security and it works now so I guess I must have something not right in config files. Thanks a lot for your help.
Larry
December 14th, 2010 4:32pm
This topic is archived. No further replies will be accepted.
Other recent topics
