如何修复 TF246017 Team Foundation 服务器无法连接到数据库 [英] How to fix TF246017 The Team foundation server could not connect to database

问题描述

除了这个错误我什么也没得到 TF246017 我无法以管理员或域用户的身份访问 TFS

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

1. 访问管理控制台时，显示错误 TF246017
2. 域用户获取TF31001，服务器返回TF246017

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

TFS 在 SQL Server 2008 上运行良好.现在我们还在同一台机器上安装了 SQL Server 2012.(我相信它无论如何都没有连接到 tfs 服务器)

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)

但是，即使在卸载 SQL 2012 后，它仍显示相同的错误

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

在应用层/数据库层，获取错误为Error retrieving value.

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

无法访问 http://xxxxxxx:8080/tfs 显示相同的错误 TF246017

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

而且，我无法找到 sql express 数据库来进行备份.

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

如何解决这个问题?

注意:我使用的是 TFS 2012 和 VS2010

Note : I'm using TFS 2012 and VS2010

推荐答案

我的 TFS (Azure DevOps Premise) 版本中有一个类似的问题分支代码.我通过查看本地 TFS 服务器上的事件查看器来跟踪我的问题，发现我收到以下 SQL 错误:

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()'.这个错误可能与时间有关.如果重新运行后错误仍然存​​在语句，使用 DBCC CHECKDB 检查数据库的结构完整性，或重新启动服务器以确保内存中的数据结构未损坏.

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.

我只是将包含我的集合的主 TFS 数据库切换到 完全恢复模式，我立即能够继续我之前出错的任务.

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.

这篇关于如何修复 TF246017 Team Foundation 服务器无法连接到数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！