主页 / dba / 问题 / 148808
Accepted
buddinggeek
Asked: 2016-09-05 19:21:39 +0800 CST

AlwaysOn - 添加辅助副本时出现问题

  • 772

我在我的笔记本电脑 ( testlab ) 上安装了 AlwaysOn，其中包含三个虚拟机，其中一个是域控制器，两个托管 SQL Server 实例（计划是一个主要副本和一个辅助副本）。一切顺利，直到我想将辅助副本添加到可用性组。

请找到随附的屏幕截图。我已经在 TCP/IP 设置中将端口更改为 1433，并且还在 Windows 防火墙中为 SQL Server 添加了一个例外。两台服务器都在同一个集群网络中。不知道我还缺少什么。

在此处输入图像描述

sql-server availability-groups

2 个回答

  1. Best Answer

    您是否将浏览器服务添加到防火墙？UDP 1434。因为您使用的是实例名称，所以它们必须得到解析。否则删除实例名称以使用该 1433 端口。

    • 5

  2. 我使用 netsh 在 Windows 防火墙中打开尽可能多（或很少）的标准 SQL 端口。在管理员 cmd 提示符或 powershell 中运行它。我忘记了我从哪里“借用”了这个，但其他人已经在某个地方发布了这个。

    REM =========  SQL Server Ports  =================== 
netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 profile = DOMAIN
netsh advfirewall firewall add rule name = SQLAdmin dir = in protocol = tcp action = allow localport = 1434 profile = DOMAIN 
netsh advfirewall firewall add rule name = SQLBroker dir = in protocol = tcp action = allow localport = 4022 profile = DOMAIN 
netsh advfirewall firewall add rule name = SQLRPC dir = in protocol = tcp action = allow localport = 135 profile = DOMAIN 
netsh advfirewall firewall add rule name = SQLBrowser dir = in protocol = udp action = allow localport = 1434 profile = DOMAIN 
REM =========  Reporting Services Ports  ==============
netsh advfirewall firewall add rule name = SQLRptSrvcHTTP dir = in protocol = tcp action = allow localport = 80 profile = DOMAIN 
netsh advfirewall firewall add rule name = SQLRptSrvcHTTPS dir = in protocol = tcp action = allow localport = 443 profile = DOMAIN
REM =========  Analysis Services Ports  ============== 
netsh advfirewall firewall add rule name = SQLAnalySrvc dir = in protocol = tcp action = allow localport = 2383 profile = DOMAIN 
netsh advfirewall firewall add rule name = SQLAnalySrvcBrwsr dir = in protocol = tcp action = allow localport = 2382 profile = DOMAIN
    • 0

相关问题