SSRS 2008 R2 How to get rid of the dialog box when opening reports

advertisements

I can open and view reports and see the data no problem, but I'm running sql server 2008 R2 Reporting Services which is prompting the user for a login id and password. I have the reports on a separate server than the databases, so that may be part of the issue. I've been all over google looking for a solution with no success as of yet. Any help would be greatly appreciated.

Does anybody know how to get rid of the dialog boxes, the prompts asking for username and password?


If you're getting this error in Internet Explorer you need to check how the User Authentication is set in Internet Options -> Security Settings:

If it's set to Automatic logon with current user name and password you shouldn't be prompted.

Obviously there are security considerations here!

Here's a useful link: Enter Credentials.

Also, make sure your Data Source is not set to Connect using Credentials supplied by the user running the report: