SQL Server Performance

Deploy Changes DataSource Definition

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

  1. dmatta59 New Member

    Have succeeded in making reports accessible to users with the following options
    on the DataSource Definition:

    CreditialRetrieval Store
    WindowsCredentials True
    ImpersonatUser False
    UserName DomainLogin

    However, the windowsCredentials option changes when the shared data source is re-deployed.
    Cannot seem to find how to set this in the shared data source. Can only set the option manually from the Report Server Manager. Is there any other way?

  2. dmatta59 New Member

    Apparently had changed some of the datasource values of a deployed report using the report manager. So, the values become "out" of sync and the "missing" values are noticed when the report is redeployed.

    Fixed the problem by changing the datasource values at the source.


Share This Page