Report builder - open error - (401) Unauthorized.

[Cheng@discussions.microsoft.com Kenny Cheng]

Hi,

Does anyone have similar error for Report Builder? It seems odd for the
messages. I don't know what is going wrong after the installation.

Many thanks.
Kenny
kenny_t...@hotmail.com

=============

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://sql2005client/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
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.application
resulted in exception. Following failure messages were detected:
+ Downloading
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.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
* [08/02/2006 15:19:48] : Activation of
http://sql2005client/ReportServer/ReportBuilder/ReportBuilder.application has
started.

ERROR DETAILS
Following errors were detected during this operation.
* [08/02/2006 15:19:57]
System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading
http://sql2005client/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)
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.

[Radu]

I am getting a very similar error:

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed
later in the log.
* Activation of

http://rgv-bos-bl2/ReportServer/ReportBuilder/ReportBuilder.application

resulted in exception. Following failure messages were detected:
+ Downloading

http://rgv-bos-bl2/ReportServer/ReportBuilder/ReportBuilder.application

did not succeed.
+ The remote server returned an error: (401) Unauthorized.

+ The target principal name is incorrect

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

In my case it looks like a security related issue. I gave my account
all possible rights on the report server but no luck.

Radu

[WMH]

I'm not sure if this will work for you but I managed to get report builder to
work on my servers, both development and production. I changed so many
things that I cannot say for certain this is what has to be done, but I
thought it might give you a direction.

The error indicates that it is a permission problem even though everything
seems to be set properly, right? In my scenario I've got Anonymous access
disabled and basic authentication configured, Integrated Windows
authentication is deselected. All of these settings are the same on the
report server, report manager, and report builder virtual directories and
even the files underneath each directory.

Here's what I did, I opened c:\program files\Microsoft SQL
Server\MSSQL.2\Reporting Services\Report Server\web.config
I edited the web.config file to reflect forms authentication instead of
Windows and told it not to impersonate
<authentication mode="Forms" />
<identity impersonate="false" />

I saved the file and opened https://www.server.com/reports - it of course
errored because the server is not configured for forms authentication. I
then reset the Web.Config file back to the original configuration
<authentication mode="Windows" />
<identity impersonate="true" />
Save the Web.config file

Open IIS and navigate to Web Sites | Default Web Site | ReportServer |
ReportBuilder
Right click ReportBuilder.application
Click Properties
Click File Security
Click Edit under Authentication and Access Control
Select Integrated Windows Authentication
Leave the Basic Authentication option selected as well if already selected.
Click OK
Repeat the above steps for ReportBuilder.exe and ReportBuilder.exe.manifest

From a workstation, not the server console
Browse to https://www.server.com/reports log in click Report Server
Click Report Builder and login again.
Report Builder opens

If you want you can then go back and remove the Integrated Windows
Authentication on ReportBuilder.exe.manifest and Reportbuilder.exe. Do not
change Reportbuilder.application or reportbuilder will not work.
I'm not sure what security holes I may have opened, but at least its working
for now.

Let me know if this works for you.

"Kenny Cheng" wrote:

> HI, Radu.
>
> Yes, I searched the KB for support but no luck.
> I use the standalone server but no active directory.. not sure it relates to
> security rights.
>
> One throught may be related to the ASP.NET app pool is running under
> NetworkService? it may not have access right to run Report Builder for the
> users?
>
> kenny