Solved

All reports are designed in SQL Server reporting services. Whenever trying to access Report Builder option from report manager, they are getting "Can not retrieve the application. Authentication error

Posted on 2006-11-28
3
774 Views
Last Modified: 2013-12-03
Environment

We are using .NET Framework 2.0. We setup our web application in another domain. All reports are designed in Microsoft SQL Server reporting services and uploaded to report manager. We have given the link to Report manger from our application.

Issue
Whenever users trying to access Report Builder option from report manager, they are getting "Can not retrieve the application. Authentication error".

Trails made to resolve above issue
Trail 1
From the msdn we come to know the error is due to not setting the Anonymous user privilege
for the Report Builder folder in SQL Server Report services.
The URL reference:
<http://msdn2.microsoft.com/en-us/library/ms365173.aspx>
"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."
We enable Anonymous user access to the report builder folder in SQL Server Reporting services.

Trail 2
Given all we have been talking about was supporting proxy authentication
with default domain credentials, we would only be able to address this case
but not arbitrary credentials for proxy.
A tested, supported workaround is to set useDefaultCredentials to true as
the followings in the machine.config (see relevant documentation for more
details)
Reference URL:
<https://connect.microsoft.com/feedback/viewfeedback.aspx?FeedbackID=115468&wa=wsignin1.0&siteid=210>
A tested, supported workaround is to set useDefaultCredentials to true as the followings in the machine.config (see relevant documentation for more details)
<defaultProxy enabled="true" useDefaultCredentials="true">
We have tried above two work-around. Still its not resolved. Kindly give me solution how to resolve above issue
0
Comment
Question by:pvines
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 16

Accepted Solution

by:
Hillwaaa earned 125 total points
ID: 18031643
Hi pvines,

I think that you were on the right track using Trail 1.  Except where you said "We enable Anonymous user access to the report builder folder in SQL Server Reporting services" what the msdn link supplied says that you need to do is turn on anonymous access in IIS:

(from the article)
To enable Anonymous access, do the following:

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

Try that, and let us know how you go.

Cheers,
Hillwaaa
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question