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 ExplorerPLATFORM 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.applicationERROR 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

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 ChenJin Chen - MSFT

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

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.

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 ChenJin Chen - MSFT

Hi Jin,i am using the FQDN like what you have suggesteddi 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.AI have tested when setting the ssrs, iis for anonumous access.i am to access report builder on the different domain.Bafter 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 domainbut i need to find if there is any article from MS, mention this a requirement for report builder.

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 ChenJin Chen - MSFT

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

Hi Jin Chen, I can't find "ReportServer" virtual directory in IIS Manager. Since SSRS has its own web server, isn't this normal? In that case, how to enabled anonymous access to Report Builder application? Thanks