Reporting services on my site always asks for username and password. I want to set it as domain users are never asked for username / password so I'll have a single-sign on. The Reports Application in IIS is set to have Windows Authentication.
Usually the users access the reports by IP address of the Reporting Server :
Can someone enumerate the options I should check ?
Thank you
How is Reporting services authenticating to the back-end database? What database type (SQL Server, Oracle, MySQL, etc.) is it connecting to?
If you're connecting to a SQL Server, using the requesting user's credentials, you'll need to setup Kerberos authentication to avoid the "double-hop" issue. This will also involve setting up the appropriate SPNs within AD.
Perform some research, and verify that this is what you wish to do in your environment.
In the IIS management console, in the properties for the "Reports" virtual directory, on the "Directory Security" tab, click the "Edit..." button for the "Anonymous access and authentication" settings. Ensure that "Integrated Windows Authentication" is the only option checked off.