SQL Server Performance

Guest Pass Through

Discussion in 'SQL Server Reporting Services' started by dmatta59, Feb 11, 2004.

  1. dmatta59 New Member

    Have managed to allow users to generate their reports via their network id and passwords. But would like to make some reports "open" in the sense that no id or password is required within our company.

    Any simple example would be appreciated since have spent much time trying to create roles but to no avail.

    Thanxs,
    dmatta
  2. jasper_smith New Member

    In either the shared data source properties for your report or the data source tab for the individual report in Report Manager, supply the credentials to be used when executing the report and select the "Credentials stored securely in the report server" radio button. This can be a SQL or windows login. When a user accesses the report, it is these credentials that will be used to access the data rather than the users.


    HTH

    Jasper Smith
  3. dmatta59 New Member

    Let me try it!

    Thanxs!
    dmatta59

Share This Page