Database permissions required For TeamCity build on named database


We are trying to run builds of two different databases in TeamCity using the DLM Automation plugin. One is able to use LocalDB, which works fine. The other needs to make use of a temporary database server for a number of reasons (Linked Server usage, MSSQL Enterprise Editon features etc). This build does not work.

The problem we encounter is 'failed to clean the database', where it attempts to drop users/groups. The cleaning process drops the group that the account running the build is a member of, ergo dropping its own permissions to the database.

What is the standard practice here? It seems like the account executing the build must have server level permissions on the database as opposed to being contained within a group on the database, else it will be dropped. Or can the build process be changed to ignore certain objects, namely the user/group executing the build?



Sign In or Register to comment.