database.dbproj deploy
cant login to sql server when deploying .dbproj via teamcity : error Deploy01234: Login failed for user '...'.
Here http://devnet.jetbrains.net/message/5265779#5265779 it was said to check build agent service permissios - it has admin access on build machine. Any others suggestions?
Please sign in to leave a comment.
Hi Victor.
The account needs rights over SQL database.
Try to logon interactivelly to the account used by TeamCity agent, and run MSBuild manually right from agent's work folder.
Michael
I did nothing but after rebooting the agent service it worked well. Is it a miracle ? Thanks anyway.
That may happen if you add an account to a group in Active Directory - membership in global and universal groups is stored in security token and built on logon/service start.