更改TFS 2014的数据库配置 [英] Changing database config for TFS 2014
问题描述
免责声明：我不是开发人员或TFS管理员，我只是一个系统管理员，试图帮助解决与TFS相关的项目。
我们的组织有一个我们希望升级到2017年TFS的现有TFS 2014实例。在我们这样做之前，我们希望在测试环境中运行试验升级以解决任何问题。
我们现有的TFS 2014环境在专用于TFS的Windows 2012 VM上安装了TFS。 TFS数据库位于与其他应用程序共享的另一台SQL 2012服务器上。
要创建测试实例，我复制了TFS VM并将副本放在我们的测试vSphere环境中。 我把它与网络断开连接，从域中取消它，重命名它，并运行sysprep以生成新的SID。 然后我将
重新连接到网络，并使用新的计算机名重新连接到Active Directory。
我已经创建了所有TFS数据库的副本，我正在尝试将TFS的测试实例重新命名为这些数据库副本，但我似乎无能为力。 当我尝试使用TfsConfig或TFS管理控制台执行任何操作时，我收到有关数据库
连接的错误，似乎无法执行任何操作。 测试TFS VM实际上与托管prod TFS DB的SQL Server完全连接，因此我不确定为什么会抱怨数据库连接。
我已经完成了一些谷歌搜索，但没有提出解决方案。 有任何建议吗？
首先，没有TFS 2014. 是2013年还是2015年？ 无论哪种方式，我建议重新开始并在新硬件上进行升级。 也不建议将TFS数据库放在用于其他应用程序的计算机上。
Sql Server或实例应专用于TFS。
基本步骤是1）在新的Sql Server上复制和恢复配置，集合和数据仓库数据库。 2）在新的AT服务器上，安装TFS 2017并运行向导。
这将为您处理一切。 详细步骤可以在
https://blogs.msdn.microsoft.com/tfssetup/2016/11/30/upgrade-to-team-foundation-server-tfs-2017/
Disclaimer first: I am not a developer or TFS admin, I'm just a sysadmin trying to help out with a TFS-related project.
Our org has an existing instance of TFS 2014 that we want to upgrade to TFS 2017. Before we do that, we want to run a trial upgrade in a test environment in order to shake out any issues.
Our existing TFS 2014 environment has TFS installed on a Windows 2012 VM that's dedicated to TFS. The TFS DBs are on another SQL 2012 server that is shared with other applications.
To create a test instance, I duplicated the TFS VM and placed the copy in our test vSphere environment. I brought it up disconnected from the network, disjoined it from the domain, renamed it, and ran sysprep to generate a new SID. Then I reconnected it to the network and rejoined it to Active Directory using the new computer name.
I've created copies of all the TFS databases and am trying to repoint the test instance of TFS to these DB copies, but I can't seem to do anything. When I try to use TfsConfig or the TFS admin console to do anything I get an error about a database connection and can't seem to do anything. The test TFS VM actually has full connectivity to the SQL Server that's hosting the prod TFS DBs, so I'm not sure why it would complain about DB connectivity.
I've done some Googling, but haven't come up with a solution. Any suggestions?
First, there is no TFS 2014. Is it 2013 or 2015? Either way, I suggest starting over and doing an in place upgrade on new hardware. It is also not recommended to place the TFS databases on a machine that is used for other applications. The Sql Server or instance should be dedicated to just TFS.
The basic steps are 1) copy and restore the configuration, collection and data warehouse databases on the new Sql Server. 2) On the new AT server, install TFS 2017 and run through the wizard.
This will take care of everything for you. Detailed steps can be found at https://blogs.msdn.microsoft.com/tfssetup/2016/11/30/upgrade-to-team-foundation-server-tfs-2017/
You will want to choose the pre-production option for the upgrade.
这篇关于更改TFS 2014的数据库配置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
