TFS error : TF246017

Question

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

Posted 7-May-18 17:22pm

amnk.info

Updated 7-May-18 17:36pm

v2

Add a Solution

Comments

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Answer 1 · 2018-05-07T17:38:00

Solution 1

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.

Posted 7-May-18 17:38pm

Wendelius

Comments

amnk.info 7-May-18 23:50pm

Thanks for your reply. Database restored completed. and TCP/IP also enabled. i will try

amnk.info 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...