Exception when I try to create Database on my test, using TeamCity for CI

Question

In one of my test I need to create a SQL Express database and then populate it.

It's run fine on my machine but when TeamCity tries to run the very same test it throws the following exception:

Test(s) failed. System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.
  ----> System.Data.SqlClient.SqlException : CREATE DATABASE permission denied in database 'master'.

What could be causing this?

[Check this](http://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx) or [This](http://stackoverflow.com/questions/1616515/sql-server-express-create-database-permission-denied-in-database-master) — noobob, May 09 '13 at 11:57
what account is your teamcity agent running under? Does it run as a user that has permission? — James Woolfenden, May 10 '13 at 09:50
I use this [script](http://archive.msdn.microsoft.com/addselftosqlsysadmin/) to solve the problem — Ben, May 10 '13 at 15:08

score 1 · Answer 1 · answered May 09 '13 at 12:07

1

In Enterprise Manager-> Data Basericht click on master db select Properties and add your permission

answered May 09 '13 at 12:07

KF2

9,887
8
44
77

score 1 · Accepted Answer · answered May 10 '13 at 15:13

1

I use this script to give administrator permission to [.]\System user (which is team city agent account).

answered May 10 '13 at 15:13

Ben

1,196
2
11
25

Exception when I try to create Database on my test, using TeamCity for CI

2 Answers2