What the the best SQL server securables for account running Azure DevOps build agent
DamianWise
Posts: 21 Bronze 3
I am configuring the Azure DevOps on premises agent to build and deploy database using SQL Change automation. I have set up the agent to run as a service and have an active directory user to do this. What are the minimum securables on any target and build sql servers? I tried SQL server role dbcreator and that failed due to permissions. When I switched to sql server role of sysadmin, the build succeeded. I'd rather not use this role. What are the minimum required securables for all the clever things done with the powershell script? Are there any other considerations?
Best Answer
-
Tianjiao_Li
Posts: 684 Rose Gold 5
Hi @DamianWise
Please take a look of https://productsupport.red-gate.com/hc/en-us/articles/360016293733-SQL-Change-Automation-Powershell-permissions
The same permission is required for the addons in Azure DevOps as well.
