故障轉移群集 SQL Server 2016：“遠端電腦拒絕連接”

背景

我們有一個新的 SQL Server 2016 故障轉移集群（沒有 Always On）（clu1），它有 2 個節點（sql1-2）和 4 個角色/實例（app1-4）

從節點到集群實例的連接工作正常

SSMS：clu1-app1\app1

問題

但是，我們無法從任何其他機器連接到實例：

SSMS：clu1-app1\app1

'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

The network path was not found'

錯誤截圖 01

SSMS：clu1-app1\app1,1433

'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The remote computer refused the network connection.) (Microsoft SQL Server, Error: 1225)

The remote computer refused the network connection'

錯誤截圖 02

我們的網路工程師告訴我們連接通過了防火牆，但集群不響應 VLAN 外的連接。

設置

節點上的設置相同

允許遠端連接到伺服器被選中

軟體防火牆已關閉

SQL Server 網路配置設置

我已經從dbatools執行了“Test-DbaConnection” ，但我並不聰明……

問題

我還需要檢查其他設置嗎？

我們通過在 TCP/IP 屬性的“IPAll”部分添加動態埠來使其工作

引用自：https://serverfault.com/questions/970189