安装TFS 2017无法连接其他电脑的sql [英] Installing TFS 2017 and cannot connect sql in other computer

问题描述

在服务器配置向导中，在数据库步骤中，我们必须提供sql server实例名称，但我无法在其他计算机上访问sql.

以下截图来自安装指南:

错误信息如下:

我安装了 Management Studio 并且可以连接到 sql server，但是在 tfs 安装中我不能.防火墙没有阻止流量，因为我已经关闭了所有的防火墙

安装 TFS 2017 时需要什么角色来连接 SQL?

提前感谢您的帮助！

解决方案

确保您计划用于配置 TFS 的帐户是

In Server Configuration Wizard, in Database step, we have to provide the sql server instance name, but I cannot reach sql in other computer.

The screenshot below is from an installation guide:

The error message is the following:

I installed Management Studio and can connect to the sql server, but in the tfs installation i cannot. The firewall did not block the traffic because I have turned off all the firewalls

What roles is needed to connect SQL while installing TFS 2017?

Thanks any help in advance!

解决方案

Ensure that the account you plan to use to configure TFS is a member of the SysAdmin server role in SQL Server.

Installing TFS involves a complex set of operations that require a high degree of privilege - these include creating databases, provisioning logins for service accounts, and more. Technically, all that is required is membership in the ServerAdmin role; ALTER ANY LOGIN, CREATE ANY DATABASE, and VIEW ANY DEFINITION server scoped permissions; and CONTROL permission on the master database. Membership in the SysAdmin server role will confer all of these memberships and permissions, and is therefore the easiest way to ensure that TFS configuration will succeed. If necessary, these memberships and permissions can be revoked after TFS is installed.

More information you can refer to this article:

https://docs.microsoft.com/en-us/vsts/tfs-server/install/dual-server?view=tfs-2018

Adding a screenshot:

这篇关于安装TFS 2017无法连接其他电脑的sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！