Permission requirement

duongthaiha

Hi
We have one user using SQL Authentication for deployment with VSTS. Is there defined permission requirement for that user used for deployment please? We have tried db_owner on Target Database however still lacking permission.
Thank you very much

dnlnln

Thank you for your question and sorry to hear you're running into a problem with your deployment.

Granting the db_owner role on the user within the db should be sufficient to deploy to an existing database. Would you mind posting the part of the build log that is raising the error so we can investigate further?