How to fix TF246017 The Team foundation server could not connect to database

Question

I'm getting nothing but this error TF246017 I'm not able to access TFS as admin or domain user

1. While accessing administration console, showing the error TF246017
2. Domain users getting TF31001 where the server returns TF246017

TFS was working fine with SQL Server 2008. And now we have also installed SQL server 2012 in the same machine.( I believe it doesn't connected anyway to tfs server)

But, even after uninstalling SQL 2012, it displays the same error

In application tier/ database tier, getting error as Error retrieving value.

Unable to access http://xxxxxxx:8080/tfs displays same error TF246017

And also, im unable to locate the sql express database to take the backup.

How to resolve this issue?

Note : I'm using TFS 2012 and VS2010

Answer 1

I had a similar issue branch code in my version of TFS (Azure DevOps Premise). I tracked my issue down by looking at the event viewer on the local TFS server and found that I was that I was getting the following SQL error:

DESCRIPTION: SQL Server Assertion: File: , line=951 Failed Assertion = 'IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

I found the first item in the following answer solved my issue.

I simply switched my main TFS database containing my collection to FULL recovery mode and I was immediately able to proceed with my previously erroring task.

Answer 2

Connect to your SQL instance via SQL Server Management Studio and check if any of the TFS databases are in a "Recovery Pending" state. If so, restart your SQL instance and the state should return to normal. Worked for me!