Home » SQL ServerRSS

Report Builder

Hi Guys I installed sQL Client tools onto a users pc and I am trying to get them access to report builder but when she clicks on it doesnt connect. however she can connect to Reporting Services and and the database but not Report Builder.  I am using Internet Explorer


PLATFORM VERSION INFO
Windows : 5.1.2600.196608 (Win32NT)
Common Language Runtime : 2.0.50727.3082
System.Deployment.dll : 2.0.50727.3053 (netfxsp.050727-3000)
mscorwks.dll : 2.0.50727.3082 (QFE.050727-3000)
dfdll.dll : 2.0.50727.3053 (netfxsp.050727-3000)
dfshim.dll : 2.0.50727.3053 (netfxsp.050727-3000)

SOURCES
Deployment url : http://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://ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading http://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
* [6/16/2009 6:48:07 PM] : Activation of http://ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [6/16/2009 6:48:07 PM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
 

7 Answers Found

 

Answer 1

Hi muzzettemm1,

From your description, a user can connect  to Report Service and the database  but not Report Builder. While connecting to Report Builder, the error “The remote server returned an error: (401) Unauthorized” occurs.

The error means the user does not have proper permission to run the Report Builder application.

By default, the ReportBuilder folder inherits the Integrated Windows authentication setting from the parent ReportServer folder. This default setting will not work if the client  and server computer are in different domains (or if the client is authenticating the user locally). Users will get HTTP 401 access  denied errors and ClickOnce authentication errors such as "Cannot retrieve application" rather than the connection they expect.

To solve the issue, please follow these steps:

1.Please make sure the client and server computer are in the same domain.

2.Please make sure the Report Builder folder use the Windows Integration authentication.

3.There are not proxy server between the client and the server.

Please feel free to ask, if you have any more questions.

Thanks,

Jin Chen

 

Answer 2

Jin,

I am currently having the same issue, but we have the Report Server configured to use Basic Authentication.

Can you explain to me why Basic Authentication still returns the 401?

Another note:  when connecting with Report Builder 2.0, it asks for user name and password when connecting to data source,  asks for user name and password when selecting the data source and clicking next. The design a query UI opens and I am able to query the data, so this is proof that the user name and password entered is connecting to the Model and returning data from the DB.  After building the query, arranging the fields, selecting the layout, and choosing a style, I click run and I get the 401 error.  I am thinking that it should be asking me for a user and pass again at this step, but it doesn't.  I hope this provides more information for you.

thanks,

cfloyd
cafloyd
 

Answer 3

hi Jin Chen,
i like to check with you is it a requirement for the client  and server to be in the same domain.
i am using windows  integration for my ssrs(sql 2005) report  builder.
i got the same issue here.
my report manager works fine, but not the report builder.
 

Answer 4

Hi tommy,

What about using the following URL directlly? That means open the URL with Internet Explorer directlly.

http://<ReportServer>.domain.com/ReportBuilder/ReportBuilder.application

Please use the FQDN of the report  server such as server1.contoso.com, not the netbios name(server1)

Thanks,
Jin Chen
 

Answer 5

Hi Jin,
i am using the FQDN like what you have suggestedd
i am able to start the report  manager but not the report builder.
i keep getting the 401 error when i access  report builder.

btw
 i am accessing the ssrs via a different domain.
both domain is not trusted.
i am using ssrs 2005 on nlb.
i am able to access both report manager and report builder  in the same domain.

senarios tested.
A
I have tested when setting the ssrs, iis for anonumous access.
i am to access report builder on the different domain.
B
after setting the iis to windows  integrated.
 i am able to access report manager but not report builder from the different domain.

so my conclusion is
accessing report builder must be in the same domain
but i need to find if there is any article from MS,
mention this a requirement for report builder.
 

Answer 6

Hi tommy_toh_522,

 
By default, the ReportBuilder folder inherits the Integrated Windows authentication setting from the parent ReportServer folder. This default setting will not work if the client  and server computer are in different domains (or if the client is authenticating the user locally). users  will get HTTP 401 access  denied errors and ClickOnce authentication errors such as "Cannot retrieve application" rather than the connection they expect.

 

To enable Anonymous access, do the following:

1.       In Internet Information 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.

 

When you enable Anonymous access, users will be prompted for their credentials each time they launch Report Builder, even if they have already been authenticated to Report Manager.

 

For more information, please see section “How to Enable Anonymous Access on the ReportBuilder Folder”:

http://msdn.microsoft.com/en-us/library/ms365173(SQL.90).aspx

 

Please feel free to ask, if you have any more questions.

 

Thanks,

Jin Chen

 

Answer 7

hello;

i had the same problem, i solved it bu changing the account wich is used by the reporting  services to run, from localservice to networkservice

 hope it helps,

thanks

 

 
 
Search for  Report Builder
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter