tobania / VSTS.Extension.SqlReportingServices

VSTS Extension for uploading SSRS Reports
MIT License
14 stars 20 forks source link

Datasource credentials change on first publish #57

Open PedroC88 opened 3 years ago

PedroC88 commented 3 years ago

When deploying reports with the tool the credentials on the data sources change, our reports must always use "without any credentials" because they are passed as parameters depending on the environment the user is connecting to.

When deploying from VS the reports have the right setting, when deploying from the tool they revert to "By prompting the user viewing the report for credentials" with the fields blank. This only happens when the report is new, after it exists on the server it won't lose it's setting after redeploying.

This is very inconvenient because we have to go and manually fix the settings every time we're pushing a new report.