How can I implement impersonation on SSRS without prompting the normal user.

Question

How can I implement impersonation (i.e. domain/user) across a domain for all users to use without prompting for user name and password SSRS. I have been trying to modify the configuration files without success. Besides the security risks please can someone help me.

Thanks in advance.

Answer 1

See

https://learn.microsoft.com/en-us/sql/reporting-services/security/authentication-with-the-report-server?view=sql-server-ver17

for more details about SSRS authentication.

Answer 2

You might want to double-check the account delegation setup and ensure your data sources support stored credentials or Kerberos authentication. For deeper insights into how impersonation affects overall system handling, this VA Disability Process explanation highlights how structured calculations handle layered access and role-based outcomes efficiently. This approach might inspire a similar method for SSRS environments.