What the the best SQL server securables for account running Azure DevOps build agent
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?
0 · Share on Twitter