MSBuild Deploy SQL Database Project .dbproj - login fails

I have managed to get TeamCity building a .dbproj file using MSBuild as the build runner. The problem is it fails when it trys to login to the DB. I am using SQL Server Auth. i.e. I have created a builduser account and given it the required permissions. Indeed, if I do 'Build -> Deploy Solution' it works a treat. So why does it fail inTeamCity?

The error is "error Deploy01234: Could not connect to myDBserver : Login failed for user 'builduser' "


1 comment
Comment actions Permalink

Please check build agent service is running under proper account.


Please sign in to leave a comment.