In SSRS ther are two options you can set, when the credentials of the datasource are stored securely in the report server:

  • Use as Windows crendentials when connecting to the datasource

This option must be checked, when you want to use “Windows Integrated Security Authentication” and not “SQL Authentication”

  • Impersonate the authenticated user after a connection has been made to the datasource

This option must be checked, when you want to use the current user to query the database, instead of the given account. The given account is used to connect to the database, but after the connection has been made, the current user is used to query the database. If the current user does not have permissions an exception will occur.

image

2 Comments

  1. what if database and application be in different servers?
    assume i have a server for database and another server for web base application, and i have these two servers in domain so what kinda user i should set here?
    the problem is this user for my scenario should be admin of domain other wise i get “Unautorized 401” error on my reports viewer!

    @sh4ho

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.