We deploy from Azure DevOps YAML pipelines to Azure App Services. We use msdeploy packages for this. In calendar week 45 of 2023, we discovered issues in our deployment pipeline. The pipeline started failing unexpectedly in various places.
The error message “ERROR_USER_NOT_AUTHORIZED_FOR_DEPLOYMENTPROVIDER” and details “Could not complete an operation with the specified provider (dbDacFx) when connecting using the Web Management Service.” were not very comprehensive for me, especially because it stopped working suddenly from one day to the next. Additionally, most of the linked help articles mainly relate to IIS.
This is the error we found in our pipelines in full.
##[error]Error: Error Code: ERROR_USER_NOT_AUTHORIZED_FOR_DEPLOYMENTPROVIDER
More Information: Could not complete an operation with the specified provider ("dbDacFx") when connecting using the Web
Management Service. This can occur if the server administrator has not authorized the user for this operation. dbDacFx
http://go.microsoft.com/fwlink/?LinkId=178034 Learn more at: http://go.microsoft.com/fwlink/?
LinkId=221672#ERROR_USER_NOT_AUTHORIZED_FOR_DEPLOYMENTPROVIDER. Learn more at: https://go.microsoft.com/fwlink/?
LinkId=221672#ERROR_USER_NOT_AUTHORIZED_FOR_DEPLOYMENTPROVIDER.
Error count: 1.