Report Builder 2008: cannot retrieve application. Authentication error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Administration » Report Builder 2008: cannot retrieve...

Report Builder 2008: cannot retrieve application. Authentication error

Rate Topic

Display Mode

Topic Options

Author

Message

yabay

Posted Tuesday, April 07, 2009 10:59 AM

Forum 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

Mike Mortensen

Posted Tuesday, April 14, 2009 6:21 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, July 02, 2012 4:04 PM
Points: 13, Visits: 15

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

yabay

Posted Monday, April 20, 2009 11:43 AM

Forum 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

jbillingsley

Posted Monday, June 08, 2009 10:25 AM

Forum 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

yizhenli

Posted Wednesday, October 07, 2009 7:34 PM

Forum 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

trent.ballew

Posted Tuesday, January 11, 2011 4:13 PM

Forum 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

pjlewis

Posted Wednesday, January 09, 2013 6:59 PM

Grasshopper

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

« Prev Topic | Next Topic »

Permissions