TF30040: 数据库配置不正确 [英] TF30040: The database is not correctly configured

问题描述

我继承了一个 TFS 2010 服务器，我试图使用管理控制台来执行一些任务(添加一个新的项目集合、添加一个控制台用户等)，它给了我这个错误:

I inherited a TFS 2010 server and I am attempting to use the Administration Console to perform some tasks (add a new project collection, add a console user, etc.) and it gives me this error:

TF30040:数据库配置不正确.联系您的团队Foundation Server 管理员.

TF30040: The database is not correctly configured. Contact your Team Foundation Server administrator.

我曾尝试查看 eventvwr 日志，但没有提及此错误.我认为 TFS 在安装时会自动设置 SQL Server 2008.有关如何解决此问题的任何想法?

I have tried viewing the eventvwr logs but nothing is mentioned about this error. I think TFS setup SQL Server 2008 automatically when it was installed. Any ideas on how to resolve this?

推荐答案

我想通了.通过以单用户模式启动 SQL Server，将自己添加为系统管理员.一旦您拥有该角色，控制台就会为您正确加载.

I figured it out. Add yourself as a sysadmin by starting SQL Server in single user mode. Once you have that role the console will load properly for you.

为了以单用户模式启动 SQL Server，您可以在命令行添加参数-m".您还可以使用 SQL Server 配置管理器工具，该工具为文件访问和其他权限提供适当的控制.要使用 Configuration Manager 工具恢复系统，请使用以下步骤:

In order to start SQL Server in single-user mode, you can add the parameter "-m" at the command line. You can also use the SQL Server Configuration Manager tool, which provides proper controls for the file access and other privileges. To use the Configuration Manager tool to recover your system, use the following steps:

1.从SQL Server 2005|配置"菜单打开配置管理器工具

1. Open the Configuration Manager tool from the "SQL Server 2005| Configuration" menu

2.停止需要恢复的 SQL Server 实例

2. Stop the SQL Server Instance you need to recover

3. 导航到高级"选项卡，然后在属性"文本框中将;-m"添加到启动参数"选项中的列表末尾

3. Navigate to the "Advanced" tab, and in the Properties text box add ";–m" to the end of the list in the "Startup parameters" option

4.点击确定"按钮，重启SQL Server实例

4. Click the "OK" button and restart the SQL Server Instance

注意:确保;"之间没有空格和-m"，注册表参数解析器对此类拼写错误很敏感.您应该会在 SQL Server ERRORLOG 文件中看到一个条目，上面写着SQL Server 以单用户模式启动."

NOTE: make sure there is no space between ";" and "-m", the registry parameter parser is sensitive to such typos. You should see an entry in the SQL Server ERRORLOG file that says "SQL Server started in single-user mode."

5. SQL Server 实例在单用户模式下启动后，Windows 管理员帐户可以使用 sqlcmd 实用程序使用 Windows 身份验证连接到 SQL Server.您可以使用 Transact-SQL 命令(例如sp_addsrvrolemember")将现有登录(或新创建的登录)添加到 sysadmin 服务器角色.以下示例将CONTOSO"域中的帐户Buck"添加到 SQL Serversysadmin"角色:

5. After the SQL Server Instance starts in single-user mode, the Windows Administrator account is able to connect to SQL Server using the sqlcmd utility using Windows authentication. You can use Transact-SQL commands such as "sp_addsrvrolemember" to add an existing login (or a newly created one) to the sysadmin server role. The following example adds the account "Buck" in the "CONTOSO" domain to the SQL Server "sysadmin" role:

EXEC sp_addsrvrolemember 'CONTOSO\Buck', 'sysadmin';
去

EXEC sp_addsrvrolemember 'CONTOSO\Buck', 'sysadmin';
GO

6. 恢复系统管理员访问权限后，使用配置管理器从启动参数中删除;-m"并重新启动 SQL Server 实例

6. Once the sysadmin access has been recovered, remove the ";-m" from the startup parameters using the Configuration Manager and restart the SQL Server Instance

这篇关于TF30040: 数据库配置不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！