asked on

SSRS 2008 R2 report builder 3.0 remote clickonce deployment error

Hello,

I did a fresh install on sql server 2008 R2 enterprise on a windows server 2003 server.
I configured SSRS and all works fine however when I click on the Report builder link in Report manager remotely I get the below clickonce error. When I open report manager on the server (localy) report builder 3.0 opens fine, I get error when using client machine. only port opened on server is port 80. Please advise, thanks.

Error:

PLATFORM VERSION INFO
      Windows                   : 6.0.6002.131072 (Win32NT)
      Common Language Runtime       : 2.0.50727.4200
      System.Deployment.dll             : 2.0.50727.4016 (NetFxQFE.050727-4000)
      mscorwks.dll                   : 2.0.50727.4200 (NetFxQFE.050727-4200)
      dfdll.dll                   : 2.0.50727.4016 (NetFxQFE.050727-4000)
      dfshim.dll                   : 2.0.50727.4016 (NetFxQFE.050727-4000)

SOURCES
      Deployment url                  : http://10.0.0.90/ReportServer_SQLEXPRESS/ReportBuilder/ReportBuilder_3_0_0_0.application

ERROR SUMMARY
      Below is a summary of the errors, details of these errors are listed later in the log.
      * Activation of http://10.0.0.90/ReportServer_SQLEXPRESS/ReportBuilder/ReportBuilder_3_0_0_0.application resulted in exception. Following failure messages were detected:
            + Downloading http://10.0.0.90/ReportServer_SQLEXPRESS/ReportBuilder/ReportBuilder_3_0_0_0.application did not succeed.
            + The remote server returned an error: (401) Unauthorized.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
      No transaction error was detected.

WARNINGS
      There were no warnings during this operation.

OPERATION PROGRESS STATUS
      * [06/06/2010 9:16:43 PM] : Activation of http://10.0.0.90/ReportServer_SQLEXPRESS/ReportBuilder/ReportBuilder_3_0_0_0.application has started.

ERROR DETAILS
      Following errors were detected during this operation.
      * [06/06/2010 9:16:43 PM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
            - Downloading http://10.0.0.90/ReportServer_SQLEXPRESS/ReportBuilder/ReportBuilder_3_0_0_0.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: (401) Unauthorized.
            - 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.

wolfman007

It sounds like you do not have anonymous access enabled for the report builder installation file. Therefore remote users cannot download it.

The solution is to configure IIS to allow anonymous access to the http://hostname/reportserver/reportbuilder directory

Have a look at the following web site.

SSRS ReportBuilder won't run - Unauthorized
http://branoblogging.blogspot.com/2008/05/ssrs-reportbuilder-wont-run.html

wolfman007

The file you need to give anonymous access to is

http://10.0.0.90/ReportServer_SQLEXPRESS/ReportBuilder/ReportBuilder_3_0_0_0.application

Then you will be able to download it using Click Once

savvytechworx

ASKER

Hi wolfman007:

Thanks for replying but I'm afraid your answer only applies to SSRS 2005 which depends on IIS. SSRS 2008 and SSRS 2008 R2 do not rely on IIS, they use the report server config manager which has an internal webhosting utility.

However, your answer could still be correct in that I need to give report builder 3 anonymous access somehow.

wolfman007

Have a look at the following web site it has a section for Enabling Anonymous Access to Report Builder Application Files in SQL Server 2008 Reporting Services.

http://msdn.microsoft.com/en-us/library/cc281309.aspx

Enable Anonymous access by doing the following:

•Verify that the report server is configured for Basic authentication.

•Create a bin folder under ReportBuilder and copy four assemblies to the folder.

•Add the IsReportBuilderAnonymousAccessEnabled element to the RSReportServer.config and set it to True. After you save the file, the report server creates a new endpoint to Report Builder. The endpoint is used internally to access program files and does not have a programmatic interface that you can use in code. Having a separate endpoint allows Report Builder to run in its own application domain within the Report Server service process boundary.

•Optionally, you can specify a least-privilege account to process requests under a security context that is different from the report server. This account becomes the anonymous account for accessing Report Builder files on a report server. The account sets the identity of the thread in the ASP.NET worker process. Requests that run in that thread are passed to the report server without an authentication check. This account is equivalent to the IUSR_<machine> account in Internet Information Services (IIS), which is used to set the security context for ASP.NET worker processes when Anonymous access and impersonation are enabled. To specify the account, you add it to a Report Builder Web.config file.

The report server must be configured for Basic authentication if you want to enable Anonymous access to the Report Builder program files. If the report server is not configured for Basic authentication, you will get an error when you attempt to enable Anonymous access.

ASKER CERTIFIED SOLUTION

wolfman007

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

savvytechworx

ASKER

Thanks wolfman007, I will try this and let you know if it works.