Report Builder on SQL Server 2005
Hi, When clicking the report builder button in report manager the download starts, gets to 922kb out of 6mb and stops with the following error code: PLATFORM VERSION INFO Windows : 5.1.2600.196608 (Win32NT) Common Language Runtime : 2.0.50727.1882 System.Deployment.dll : 2.0.50727.1433 (REDBITS.050727-1400) mscorwks.dll : 2.0.50727.1882 (QFEN-1.050727-1800) dfdll.dll : 2.0.50727.1433 (REDBITS.050727-1400) dfshim.dll : 2.0.50727.1433 (REDBITS.050727-1400) SOURCES Deployment url : http://<servername>/ReportServer/ReportBuilder/ReportBuilder.application Server : Microsoft-IIS/6.0 X-Powered-By : ASP.NET X-AspNet-Version: 2.0.50727 Application url : http://<servername>/ReportServer/ReportBuilder/ReportBuilder.exe.manifest Server : Microsoft-IIS/6.0 X-Powered-By : ASP.NET X-AspNet-Version: 2.0.50727 IDENTITIES Deployment Identity : ReportBuilder.application, Version=9.0.4035.0, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=msil Application Identity : ReportBuilder.exe, Version=9.0.4035.0, Culture=neutral, PublicKeyToken=c3bce3770c238a49, processorArchitecture=msil, type=win32 APPLICATION SUMMARY * Online only application. * Trust url parameter is set. ERROR SUMMARY Below is a summary of the errors, details of these errors are listed later in the log. * Activation of http://<servername>/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected: + Exception occurred loading manifest from file ReportBuilder.exe: the manifest may not be valid or the file could not be opened. + File ReportBuilder.exe is not a valid Portable Executable (PE) file. + File {0} is not a valid Portable Executable (PE) file. COMPONENT STORE TRANSACTION FAILURE SUMMARY No transaction error was detected. WARNINGS There were no warnings during this operation. OPERATION PROGRESS STATUS * [15/02/2011 09:52:42] : Activation of http://<servername>/ReportServer/ReportBuilder/ReportBuilder.application has started. * [15/02/2011 09:52:47] : Processing of deployment manifest has successfully completed. * [15/02/2011 09:52:47] : Installation of the application has started. * [15/02/2011 09:52:48] : Processing of application manifest has successfully completed. * [15/02/2011 09:52:50] : Request of trust and detection of platform is complete. ERROR DETAILS Following errors were detected during this operation. * [15/02/2011 09:53:01] System.Deployment.Application.InvalidDeploymentException (ManifestLoad) - Exception occurred loading manifest from file ReportBuilder.exe: the manifest may not be valid or the file could not be opened. - Source: System.Deployment - Stack trace: at System.Deployment.Application.Manifest.AssemblyManifest.ManifestLoadExceptionHelper(Exception exception, String filePath) at System.Deployment.Application.Manifest.AssemblyManifest.LoadFromInternalManifestFile(String filePath) at System.Deployment.Application.Manifest.AssemblyManifest..ctor(String filePath) at System.Deployment.Application.DownloadManager.ProcessDownloadedFile(Object sender, DownloadEventArgs e) at System.Deployment.Application.FileDownloader.DownloadModifiedEventHandler.Invoke(Object sender, DownloadEventArgs e) at System.Deployment.Application.FileDownloader.OnModified() 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.DownloadDependencies(SubscriptionState subState, AssemblyManifest deployManifest, AssemblyManifest appManifest, Uri sourceUriBase, String targetDirectory, String group, IDownloadNotification notification, DownloadOptions options) at System.Deployment.Application.ApplicationActivator.DownloadApplication(SubscriptionState subState, ActivationDescription actDesc, Int64 transactionId, TempDirectory& downloadTemp) at System.Deployment.Application.ApplicationActivator.InstallApplication(SubscriptionState& subState, ActivationDescription actDesc) at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromExtension) at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state) --- Inner Exception --- System.IO.IOException - File ReportBuilder.exe is not a valid Portable Executable (PE) file. - Source: System.Deployment - Stack trace: at System.Deployment.Application.PEStream.ConstructFromFile(String filePath, Boolean partialConstruct) at System.Deployment.Application.PEStream..ctor(String filePath, Boolean partialConstruct) at System.Deployment.Application.Manifest.AssemblyManifest.LoadFromInternalManifestFile(String filePath) --- Inner Exception --- System.ComponentModel.Win32Exception - File {0} is not a valid Portable Executable (PE) file. - Source: System.Deployment - Stack trace: at System.Deployment.Application.PEStream.DosHeader..ctor(FileStream file) at System.Deployment.Application.PEStream.ConstructPEImage(FileStream file, Boolean partialConstruct) at System.Deployment.Application.PEStream.ConstructFromFile(String filePath, Boolean partialConstruct) COMPONENT STORE TRANSACTION DETAILS No transaction information is available. This works on my PC, but not any other end-user (the people that will be using this tool). I have changed the proxy settings so as to not automatically detect settings and this half works. If I copy the reportbuilder.exe on to the local users PC it will open and connect to the report server, but not if I click on the 'report Builder' icon in report manager. I really need to get this sorted and have been trying for 3 days with every solution I can find on here. Anyone have any ideas? Any help would be much appreciated. Thanks
February 18th, 2011 9:55am

Hi G Parsons, A new installation of Reporting Services includes predefined role definitions that you can use to make Report Builder available to users. To use Report Builder on a new installation, you must do the following: 1. Create a role assignment under Home that includes the Report Builder role. An item-level role assignment is necessary for granting access to report models. 2. Create a system-level role assignment that includes the System User role. A system-level role assignment is necessary for granting access to Report Builder. You must create these role assignments for each user who requires access to Report Builder. For more information about creating role assignments, see Creating, Modifying, and Deleting Role Assignments and Role Assignments for Report Builder Access. If the report server uses basic authentication to authenticate a local Windows user account, you must enable Anonymous access on the ReportBuilder folder in IIS. To enable Anonymous access, do the following: 1. In Internet Manager, expand Web Sites, navigate to and then expand the ReportServer virtual directory. 2. Right-click Report Builder, and then select Properties. 3. On the Directory Security tab, in Authentication and access control, click Edit. 4. Click Enable anonymous access, and then click OK. For more information about Configuring a Report Server for Report Builder Access: http://msdn.microsoft.com/en-us/library/ms365173(v=SQL.90).aspx Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 12:03am

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

Other recent topics Other recent topics