SQL Server Performance Forum – Threads Archive

Deploy Changes DataSource Definition

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? dmatta59

---

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. dmatta59

---

]]>