reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

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 : https://reports.mysite.com/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 https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/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
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/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 informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.

reportbuilder.application Authentication Error

This is the strangest thing. Whenever I try to access report builder from 90% of machines, I get the following error:

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 : https://reports.mysite.com/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 https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading https://reports.mysite.com/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
* [5/10/2006 8:48:02 AM] : Activation of https://reports.mysite.com/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [5/10/2006 8:48:11 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading https://reports.mysite.com/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 informtion is available.
-

Ok, so here's the catch. It works one 1 machine, a co-workers machine. I can login as any user and it'll work fine. But when I try it on any other machine, including my laptop, my desktop, my server, etc. I get that error. I've tried adjusting the IE Security settings, firewall settings, even tried different browsers. Here's some of the stuff installed on my machines:

Laptop
-Windows XP Pro
-ASP.NET Validation Tool
-Visual Basic Express w/ SQL Server Express
-.NET 1.1/2.0 Framework

Desktop
-Windows XP Home
-Visual Studio 2005 Professional
-.NET 1.1/2.0 Framework

Server
-Windows Server 2003 Enterprise
-SQL Server 2005
-.NET 1.1/2.0 Framework

Any help on this would be greatly appreciated. Even our lead developer has no clue, it won't work on his machine either!

I found a solution here.sql

ReportBuilder Issues w/ Form Authentication

I successfully created an authentication and authorization extension for SQL Server 2005 Reporting Services. However, when I login into Report Manager, I never see the Report Builder button. I assigned the account to System Administrator and also gave it Content Manager permissions. I searched everywhere but can't find an answer. If I revert back to Windows Authentication, everything works fine.I got the Security Extension Sample up and running, and it also does not show the Report Builder button. Is this a bug with Report Manager or am I not setting something in the config files?|||You can modify your security component to allow this by making sure that permission for each activity is granted to a sysadmin user group (specified in your configuration file) at login. (This is your authorization class if you follow the sample.)

If the only thing you are worried about is Report Builder access you can control through through a link in your own solution as well. All the button does is launch http://yourservername/ReportServer/ReportBuilder/ReportBuilder and let the click-once app take over. You would may still need to fix your auth class to save anything though.

ReportBuilder default save folder is Reportserver/Models

Hi all,
When any user has created a report (based on a published model) using
ReportBuilder and wants to save it, the default save location is
../Reportserver/Models and not (as I expected) the root folder.
1) As far as I know the default save folder should be the root folder
(/Reportbuilder). Is that correct?
1-1) If yes - What causes this "misbehaviour"
2) Is it possible to change the default save folder to root (or maybe even
"My Reports")?
SW:
Windows Srv 2003 R2 SP1 - 64bit
SQL 2005 SP2 - 64bit
Thanks for any answers or comments!
PeterIf i am reading this correct
Right click the folder in solution explorer and change the default
folder location to My Reports
Cheers|||Hi!
I'm not sure if you get me right - or I get you wrong :-)
Thx for your reply.
> If i am reading this correct
Just to make it clear: I am not talking about where to publish the solution,
but where Report Builder tries to save a newly create report.
> Right click the folder in solution explorer and change the default
> folder location to My Reports
Please explain what folder I should right click?
If I open the project in VS 2005 the structure is
Project name
Data Sources
xxxxx.ds
Data Source views
xxxxx.dsv
Report Models
xxxxxxxx.smdl
Best regards,
Peter
-- Original Message --
From: "blueboy" <matt_meech@.hotmail.com>
Newsgroups: microsoft.public.sqlserver.reportingsvcs
Sent: Monday, June 18, 2007 10:43 AM
Subject: Re: ReportBuilder default save folder is Reportserver/Models
> If i am reading this correct
> Right click the folder in solution explorer and change the default
> folder location to My Reports
> Cheers
>
"blueboy" <matt_meech@.hotmail.com> wrote in message
news:1182156196.524637.78530@.m36g2000hse.googlegroups.com...
> If i am reading this correct
> Right click the folder in solution explorer and change the default
> folder location to My Reports
> Cheers
>

reportbuilder clickonce

Hello!
Does anyone know which permissions our users will need in order to let
reportbuilder install from the SSRS homepage?
I have read that the clickonce process should make this smooth, BUT when we
try this, the reportbuilder does not install unless "local
administrator"-permissions are assigned to the users. According to the log,
the deployment process is trying to write to the registry - and this is
probably what makes the app require admin-permissions.
Strange - since Ive read an MS-article stating that the users should not
need these permissions.
Anyone has any comments ?
DavidOn Feb 22, 8:49=A0am, "David"
<david_sundstrom_sandegard.nos...@.hotmail.com> wrote:
> Hello!
> Does anyone know which permissions our users will need in order to let
> reportbuilder install from the SSRS homepage?
> I have read that the clickonce process should make this smooth, BUT when w=e
> try this, the reportbuilder does not install unless "local
> administrator"-permissions are assigned to the users. According to the log=,
> the deployment process is trying to write to the registry - and this is
> probably what makes the app require admin-permissions.
> Strange - since Ive read an MS-article stating that the users should not
> need these permissions.
> Anyone has any comments ?
> David
David,
What I did was go into Site Settings and create a new System Role
called ReportBuilderUser with just the Execute Report Definition task
assigned. After that it was just a case of assigning that role to the
individuals or groups that need to see the Report Builder button in
Report Manager.
Don't feel bad about needing help on this. Unless it's changed, the
MS documentation for this is not clear.
HTH
toolman|||Hi toolMan, thx for answering!
Thing is that in order for ReportBuilder application to install, the user
seem to need some permissions on their LOCAL computer (not the server
site-wide settings-stuff).
The ReportBuilder app seems to write to some registry-keys and in order to
do this, the users seems to need to be local adminstrators of their
machines.
Does anyone recognize this?
"toolman" <timd@.infocision.com> wrote in message
news:d7250e41-06f3-45e4-bf04-fa4e1ccf0330@.41g2000hsc.googlegroups.com...
On Feb 22, 8:49 am, "David"
<david_sundstrom_sandegard.nos...@.hotmail.com> wrote:
> Hello!
> Does anyone know which permissions our users will need in order to let
> reportbuilder install from the SSRS homepage?
> I have read that the clickonce process should make this smooth, BUT when
> we
> try this, the reportbuilder does not install unless "local
> administrator"-permissions are assigned to the users. According to the
> log,
> the deployment process is trying to write to the registry - and this is
> probably what makes the app require admin-permissions.
> Strange - since Ive read an MS-article stating that the users should not
> need these permissions.
> Anyone has any comments ?
> David
David,
What I did was go into Site Settings and create a new System Role
called ReportBuilderUser with just the Execute Report Definition task
assigned. After that it was just a case of assigning that role to the
individuals or groups that need to see the Report Builder button in
Report Manager.
Don't feel bad about needing help on this. Unless it's changed, the
MS documentation for this is not clear.
HTH
toolman

reportbuilder button not appearing

Hi Everyone,
I am not getting the reportbuilder button on the toolbar in report
server portal. I have implemented forms security on the reporting
services instance.
Can anyone please help me solve this problem?
Thanks in advance,
BharathHi All,
I got the resolution for this problem. I was implementing the sample
from SQL 2000 on an SQL 2005 platform. After implementing the forms
authentication using the sources from SQL 2005 the button is
appearing...
Bharath
bharath wrote:
> Hi Everyone,
> I am not getting the reportbuilder button on the toolbar in report
> server portal. I have implemented forms security on the reporting
> services instance.
> Can anyone please help me solve this problem?
> Thanks in advance,
> Bharath

ReportBuilder authentication

I am using the Report Builder in my application. When it is opened from an environment where there is no proxy, it is asking for authentication and it is working properly.

But when it is opened from the client environment where there is proxy, it is not asking for authentication and he cannot select or view any source of data.

How can I force the Report Builder in the client environment to prompt for authentication? If this cannot work, is there any other possible solution? (Not that it is not allowed to open the port)

Thank you in advance.

Hi,

As you mentioned, the only difference is set the proxy or not, right? Based on my knowledge, I don't think it would affect the behavior of Forms Authentication.

Could you help to check on the following points:

? If you use Forms Authentication, anonymous access must be enabled on the report server virtual directory in Internet Information Services (IIS).
? ASP.NET authentication must be set to Forms. You configure ASP.NET authentication in the Web.config file for the report server.
? Reporting Services can authenticate and authorize users with either Windows Authentication or custom authentication, but not both. Reporting Services does not support simultaneous use of multiple security extensions.

Thanks.

|||

Will that affect the reports?

|||

Hi,

? If you use Forms Authentication, anonymous access must be enabled on the report server virtual directory in Internet Information Services (IIS).
? ASP.NET authentication must be set to Forms. You configure ASP.NET authentication in the Web.config file for the report server.
? Reporting Services can authenticate and authorize users with either Windows Authentication or custom authentication, but not both. Reporting Services does not support simultaneous use of multiple security extensions.

These actions take effect on the reporting servcie site level. It's for the security on reporting servcie site. So it won't affect the detail reports.

Thanks.

sql