Post reply

avoid check for credentials when view a report

  • January 9, 2007 at 10:44 am

    #170913

    hello world,

    we have a web application that use sql server 2000 report server,

    nowdays we use an user in the report db to access the reports,

    so now when an user try to view a report is prompt for an user name and password.

     

    note: i've already setted iis for anonimous access and integrated security,

     

    so how can avoid check for credentials to see reports

     

     

  • January 23, 2007 at 12:44 pm

    #685036

    Create a SQL Server account with SA permissions (you need SA so that it can run "setuser" on the back end).

    Then check "Credentials stored securely in the report server" and "Impersonate the authenticated user after a connection has been made to the data source"

    When the report runs, it runs under the pseudo SA account but runs "setuser" first to impersonate the NT user who is logged in.  All permissions then will be those of the logged in user not SA.

    ~Lane

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply