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