Authentication problem with SSRS 2005 site (with ADFS) after ASP.NET 3.5 upgrade
We have a windows 2003 server (Enterprise Edition, SP2) that hosts several websites on separate IP addresses, including a Reporting Services site (SSRS 2005). Earlier this year the user authentication was upgraded to ADFS (Active Directory Federation Services, Windows NT-Token Configuration), and everything was running fine. Two months ago we upgraded from ASP.NET 2 to ASP.NET 3.5, and now the Reporting Services is not so fine. Basic authentication with ADFS is working and people can run existing reports on the site, but we can no longer launch Report Builder, deploy reports from Visual Studio, or display embedded reports on web pages. Everything we are finding on the internet advises us to enable Integrated Windows Authentication on the website, but this is the exact opposite of the ADFS installation instructions. And in case it matters we have a separate SQL Server. We believe the problem is security related, but cannot track down the root problem. From Visual Studio when trying to deploy a report we get the following error: =================================== A connection could not be made to the report server https://cinvs2004.[xyz].com/reportserver. (Microsoft Report Designer) =================================== The request failed with an empty response. (System.Web.Services) ------------------------------ Program Location: 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) at Microsoft.SqlServer.ReportingServices2006.ReportServiceAuthentication.GetAuthenticationMode() at Microsoft.ReportDesigner.Project.ReportServiceClient2006.CheckAuthenticated() at Microsoft.ReportDesigner.Project.ReportClientManager.DetectEndpointAndAuthenticate(String url, ICredentials credentials, String& authCookieName, Cookie& authCookie, EndpointType& endpointType) at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url) at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy() From Reporting Services, when launching Report Builder the detailed error message is: PLATFORM VERSION INFO Windows : 6.1.7600.0 (Win32NT) Common Language Runtime : 4.0.30319.237 System.Deployment.dll : 4.0.30319.1 (RTMRel.030319-0100) clr.dll : 4.0.30319.237 (RTMGDR.030319-2300) dfdll.dll : 4.0.30319.1 (RTMRel.030319-0100) dfshim.dll : 4.0.31106.0 (Main.031106-0000) SOURCES Deployment url : https://cinvs2004.[xyz].com/ReportServer/ReportBuilder/ReportBuilder.application ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of https://cinvs2004.[xyz].com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected: + Downloading https://cinvs2004.[xyz].com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. + The remote server returned an error: (500) Internal Server Error. COMPONENT STORE TRANSACTION FAILURE SUMMARY No transaction error was detected. WARNINGS There were no warnings during this operation. OPERATION PROGRESS STATUS * [9/12/2011 3:11:08 PM] : Activation of https://cinvs2004.[xyz].com/ReportServer/ReportBuilder/ReportBuilder.application has started. ERROR DETAILS Following errors were detected during this operation. * [9/12/2011 3:11:15 PM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype) - Downloading https://cinvs2004.[xyz].com/ReportServer/ReportBuilder/ReportBuilder.application did not succeed. - Source: System.Deployment - Stack trace: at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next) at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles() at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState) at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation) at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension, BrowserSettings browserSettings, String& errorPageUrl) at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) --- Inner Exception --- System.Net.WebException - The remote server returned an error: (500) Internal Server Error. - Source: System - Stack trace: at System.Net.HttpWebRequest.GetResponse() at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next) COMPONENT STORE TRANSACTION DETAILS No transaction information is available.
September 12th, 2011 10:29pm

Hi, The following threads might be helpful for you: Report Builder not loading from Client machine http://social.msdn.microsoft.com/Forums/da-DK/sqlreportingservices/thread/cbd62e8d-2126-4991-af6c-86d307a932cf Report Builder download error from Report manager URL. http://social.msdn.microsoft.com/forums/en-us/sqlreportingservices/thread/B75C5823-533F-401F-8E94-D9E855FAEF7B If you need further assistance, for quick and accurate response to the question, it is recommended you create a new thread in the SSRS forum. The support professional there are more familiar with it and can help you in a more efficient way. SQL Server Reporting Services http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/threads Thanks for your understanding. Regards, Bruce
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2011 2:13am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics