Click here to Skip to main content
15,065,044 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
After Restore Database 2015 to 2018 TFS. I got this error.

TF246017: Team Foundation Server could not connect to the database. Verify that the instance is specified correctly, that the server that is hosting the database is operational, and that network problems are not blocking communication with the server.

What I have tried:

Login to TFS after restore database to TFS 2018
Updated 7-May-18 17:36pm
Maciej Los 8-May-18 3:01am
This is your 4. time when you ask the same question! (Your questions)[^]
Stop doing it. Respect the rules!

1 solution

The first question is, is the database still in recovery? Ensure that the restore has been completed and the database is opened. See: How to: Restore a Database Backup (SQL Server Management Studio) | Microsoft Docs[^]

Also check that the database name is configured correctly in TFS in case you changed the database name when restoring. If the restore is done to a new SQL Server instance, ensure that TCP/IP is enabled, see Configure a Server to Listen on a Specific TCP Port | Microsoft Docs[^]

If still encountering problems, search for more information from
- SQL Server log, critical errors are logged here
- Windows Event log may also contain additional information.
Comments 7-May-18 23:50pm
Thanks for your reply. Database restored completed. and TCP/IP also enabled. i will try 8-May-18 1:44am
I fixed that error. now i got this one

TF401054: The requested service level property TFS_SERVICE_LEVEL did not match the expected value. Team Foundation Server requires the Dev16.M122.7 service level but the database currently implements Dev14.M113.
Wendelius 8-May-18 11:29am
This sounds like you're trying to restore a database from older TFS version to new TFS. Is this is the case, it's not supported, instead you should upgrade the database. Have a look at Move a team project collection | Microsoft Docs[^]
Maciej Los 8-May-18 15:45pm
Mika, this member repost the same question again and again...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900