Database Build - userid problem

Question

Hi, I'm making good progress with my database Build.  It Builds if I don't specify "deploy".  Having a little problem with the userid for the database deploy.  Getting this message:

Could not connect to corpsqlsrvr : Login failed for user 'myuid'.

For various reasons I have to use "SQL Server Authentication".  When I "Test" the connection in TFS, it says the test succeeded, although that's only when I input the password manually.   I have "remember password" checked but the edit connection window comes up with the password blank.  My dba tells me this userid now has db_owner rights to the database I'm trying to deploy.  When I use Mgmt Studio to login with this userid manually I can create tables and procs with this userid.  Any thoughts on why Test Connection would work but not the actual Deploy? 

Answer 1

Hi flash7gordon,

Thanks for your post!

I am moving this thread to SQL Server for better response!

Best Regards,

---

Cathy Kong [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Cathy,  I disagree with moving this problem to MS Sql Data Access.  I can logon to MS Sql 18 ways from Sunday with this ID.   There's something with what TFS is doing with the login from the Build Server that is the problem.  Plus a lot of other people are having a problem similiar to mine.  http://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/08ebf2b1-af25-4c73-9261-237ea3843987/

Answer 3

We solved this problem by switching to Windows Auth from SQL Server Auth.  This wasn't our preferred solution because we didn't particularly want to allow another userid to write our databases but it worked.  In my opinion SQL Server Auth on a TFS 2010 Build server has a bug and does not work.  But if you have the sql admin capabilities to modify all the various databases, I am offering you a solution.