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
Best Answer
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.