TFS could not connect to database. Login field

0
votes

I am getting the following error. Cannot solve.New to TFS. Please help.

TF246017: Team Foundation Server could not connect to the database. Verify that the server that is hosting the database is operational, and that network problems are not blocking communication with the server.--> login failed. Login from untrusted domain and cannot be used with windows authentication.

1
visual-studio-2010tfsazure-devops
check connection strings for your tfs, also can you access the db under the credentials? - cpoDesign
I am sorry as I am working on tfs for just a couple of days, can you please tell me where to check the connection string for TFS? :( - rahulsen002
I hope in the Web.config. But, I need to know with which user credentials, TFS is trying to log in? - rahulsen002
could you access admin console for tfs? - cpoDesign
Check following guide for tfs: geekswithblogs.net/TarunArora/archive/2011/06/11/… - cpoDesign

1 Answers

1
votes

If you open SQL Server Manager on your TFS Server application tier using "runas" to open it under the same credentials that you expect TFS to use you should be able to diagnose more:

1) install SQL Server Manager on TFS AppTier 2) right-click on the SQL Server Manager icon and select 'run-as' ( you may need to hold alt) 3) enter the TFS Service (refer to TFS Installation Guide) credentials to open 4) try to connect to your SQL Server If you cant connect verify that SQL is installed where you think it is and that there are no firewall issues for the standard SQL ports.