Failture to start Report Builder from Report manager

Dear all
I want to start report builder from report manager. I configured IIS with
integrated security. Everything seems well configured - users with access
rights can access Reporing Services, users without accessrights cannot.
But with reportbuilder I have a Authentication problem. A user from a client
machine cannot access report builder, while strangely accessing reportbuilder
from the server is possible. I assume the is a right problem, like the error
message below declares.
The weired thing is, that the user has the accessrights to the filesystem.
IIS can authenticate the user (event viewer) and I can see it also in the IIS
log. But no way to access the report builder.
Thanks for your help!
Regards,
Marc
MarcPLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application resulted in exception. Following failure messages were detected:
+ Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.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
* [17.07.2006 14:46:13] : Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [17.07.2006 14:46:25]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.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)
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.|||Hello Roger,
Thank you for post in MSDN newsgroup.
If I understand the issue correctly, a user from client cannot open report
builder while he could access report builder from local console of the RS
server. If I'm off-base, please let me know.
From the error log, it seems to be a permission issue. I suggest that you
try the following steps:
1. Get the RSWebApplication.config file located in the following folder in
most cases:
C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
Services\ReportManager
2. Backup the RSWebApplication.config to another folder.
3. Modify the RSWebApplication.config as follows:
From:
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
To:
<ReportBuilderTrustLevel>PartialTrust</ReportBuilderTrustLevel>
You may want to restart IIS by running "iisreset" to test the sitaution.
Please let me know if this helps. If you have further question, please feel
free to let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Peter
thanks for your patience and your help with my issues. Unfortunately your
advice did not fix the problem. See the error message below :-/.
Do you have any other idea what could be wrong configured?
Regards,
Marc
PLATFORM VERSION INFO
Windows : 5.1.2600.131072 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)
SOURCES
Deployment url :
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later
in the log.
* Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application resulted in exception. Following failure messages were detected:
+ Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.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
* [18.07.2006 07:53:08] : Activation of
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [18.07.2006 07:53:09]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://10.1.10.64/ReportServer/ReportBuilder/ReportBuilderLocalIntranet.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)
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.|||Hello Marc,
Thank you for your update. Based on my further research, it seems the issue
is related to the file security. I suggest that you try the following steps:
Open IIS and navigate to Web Sites | Default Web Site | ReportServer |
ReportBuilder
Right click ReportBuilder.application
/ReportBuilderLocalIntranet.application
Click Properties
Click File Security
Click Edit under Authentication and Access Control
Select Integrated Windows Authentication
Uncheck Anonymouse authentication
Repeat the above steps for ReportBuilder.exe and ReportBuilder.exe.manifest
ReportBuilderLocalIntranet.exe.manifest
Please also do above step on ReportServer and ReportBuilder Virtual
directory.
Also, I'd like to know if you have tested on different client and if you
logged on as a domain user with admin rights on report server from a client
machine.
If you have any update, please feel free to let me know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi Peter
Thanks for your reply. I first checked that everything is set just to
integrated windows authentication. But this did not resolve the problem. Then
I tested what happens when the files:
ReportBuilder.application
ReportBuilder.exe
ReportBulder.exe.manifest
ReportBuilderLocalIntranet.application
ReportBuilderLocalIntranet.exe.manifest
have Anonymous authentication (checked). And I granted the anonymous user
access to the files listed above.
And that gave me access to report builder!
What is strange I think, that Integrated Windows Authentication deosn't work
here. But perhaps I have a misconfiguration somewhere.
Best Regards,
Marc|||Hello Marc,
Thank you for your update. I understand that you'v resolved the issue by
granting anaonymous access to all of the files I mentioned. Though it is
not easy to find the root cause of the issue, I guess this might be related
to some issues on SRS VDs and options of web.config.
Your experience shall benefit the community. Thank you!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================