SQL Server - Sql sever reporting service browser authentication

Asked By farrukh on 05-Apr-12 05:30 AM
Hi All,

I have configured the sql server reporting services config manager. I want to know that how to get rid of windows authentication popup messege from the internet browser each and every time i have to provide admin credientials and i cant give the password to users as well

Somesh Yadav replied to farrukh on 05-Apr-12 05:47 AM

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.


farrukh replied to Somesh Yadav on 06-Apr-12 07:18 AM

I create exactly the windows login in sql server give data reader access to user and then on the brower define new role to exactly the same windows login and give report only access.

This really solve my issue i have created few users as like as windows users when ever any user open the reports on the browser he has to provide his own user and credentials to access report.