search

liprec / vsts-release-aas

Repository for my Analysis Service Azure pipelines tasks related to Azure Analysis Service or Power BI Premium
Other
27 stars 28 forks source link

Password gets deleted/ reset after deployment pipeline run #116

Closed caseking-jeff closed 1 year ago

caseking-jeff commented 2 years ago

We have noticed the following behaviour in our Azure Analytics Services deployment pipeline: After the pipeline has succesfully ran, the next processing job will fail with the following error:

OLE DB connection failed to be established Fehler bei der Anmeldung für den Benutzer "sa".

Which translates to: Login failed for user "sa".

After manually adding the password via the connection settings in SSMS the processing job succeeds with the deployed changes.

Our pipeline has the following settings:

Data source type: Advanced (multiple connections) Advanced settings:

[ { "name": "19x.xxx.x.xxx", "authenticationKind": "UsernamePassword", "connectionDetails": { "address": { "server": "19x.xxx.x.xxx", "database": "DWH" } }, "credential": { "Username": "sa", "Password": "xxxxx" } } ]

stale[bot] commented 1 year ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.