[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
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
Medium Priority
?
778 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
1 Comment
 
LVL 16

Accepted Solution

by:
Hillwaaa earned 500 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

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

How to increase the row limit in Jasper Server.
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses
Course of the Month18 days, 2 hours left to enroll

830 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