SQL Server Reporting Services 2008 R2 always show for login prompt

Question

Hi guys,

Whenever i try to access SSRS 2008 R2 through a URL i.e after being published on the net it always shows a login prompt when accessing the report. The problem does not appear on the developement enviroment.

how do i prevent this login prompt from showing whenever i try to access a report. at present we are solving this problem by providing a username and password in <appSettings> in the web.config. after doing this the login prompt does not appear.

is there a better solution to this? or am i doing this the wrong way?

Answer 1

I'm not sure from you're question is the login box a prompt to get you access to the report server or is it a prompt on the reports datasource.

It sounds a bit like permissions to access the report server, I guess you could try giving the app pool user permissions to access the report server and run the report or use an impersonation account to access the report.

Answer 2

I am assuming the prompt is for the username / password for the domain. Internally you are likely getting through the AD authentication check in your application as you will have permissions to deliver the report (you can test that premise with Firefox or other browser that doesnt handle AD authentication like IE does/

I think you may have setup for basic authorisation to view the report RSReportServer.config rather than web.config is that what you have done? (see this to see example http://msdn.microsoft.com/en-us/library/cc281309.aspx.)

If you are trying to get full anonymous access then you are in for some fun; luckily one of the RS team blogged a way to achieve it; I wouldn't advocate doing it straight onto a production box though.

http://blogs.msdn.com/b/jameswu/archive/2008/07/15/anonymous-access-in-sql-rs-2008.aspx