Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Report Builder 2008: cannot retrieve application. Authentication error Expand / Collapse
Author
Message
Posted Tuesday, April 7, 2009 10:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 20, 2012 12:01 PM
Points: 7, Visits: 118
Hi Everyone,

We have recently deployed reports on SQL ReportServer 2008 and able to test AdHoc reports from a same server. But trying to execute theadhoc reports from external computers not in the same domain as the reports server we get the error "cannot retrieve application. Authentication error" and it generates a log file that has the following error report:

Downloading http://Ipaddress/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
The remote server returned an error: (401) Unauthorized.

Thanks,
yabay
Post #692300
Posted Tuesday, April 14, 2009 6:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 12:27 PM
Points: 13, Visits: 19
had the same issue, and an easy fix

on the remote machine, go to your User Account in Control Panel
Pick your Account
Select Manage Network Passwords
add an entry
put in the name of the report server
put in the user and password you use to login
apply it

try to run the report builder app again and it should download and install

has to do with permissions not getting passed for non-domain memebers so that the ClickOnce install routine can download the application file



Post #697174
Posted Monday, April 20, 2009 11:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 20, 2012 12:01 PM
Points: 7, Visits: 118
Hi Mike,

Thanks a lot. I followed the steps you provided and solved the issue.

Have a nice day.
yabay.
Post #700847
Posted Monday, June 8, 2009 10:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 29, 2011 1:51 PM
Points: 1, Visits: 14
Any other solutions to this? The workaround Mike gave does work and so far is the only way I can get Report Builder to launch from a non-domain computer. The (perceived) problem is that when you have the credentials stored,, you don't get prompted for a login at all when you hit the report manager site, which doesn't fly for many company security policies.


Post #730796
Posted Wednesday, October 7, 2009 7:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:31 AM
Points: 3, Visits: 17
I had same issue before.
Try to save your logon id and password when you logon to http://report server host name/reports. it worked.
hope it help you.
Post #799662
Posted Tuesday, January 11, 2011 4:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 11, 2011 4:09 PM
Points: 1, Visits: 15
This can also be due to the userid and password not being sent automatically to the site.

Either add the site to your "LocalIntranet" zone in IE (which automatically sends id and password) or make sure that the "automatic login with current username and password" option is set for the "Logon" option in the Internet zone.
Post #1046198
Posted Wednesday, January 9, 2013 6:59 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, April 19, 2013 9:29 PM
Points: 14, Visits: 94
Mike.

My server (yes, I am having the same issue) has the Windows 2008 R2 operating system and I don't see the Network Password option.

Can you offer a tip?

Thanks.

by the way, when I open the Report Server home page on the server and click Report Builder, it opens normally. Its on my laptop that I get the Authentication Error.

Thanks again.
Post #1405119
Posted Friday, December 6, 2013 5:17 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:25 PM
Points: 19, Visits: 145
Perfect! Thanks!
Post #1520778
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse