SQL SERVER ALWAYS ON FAILOVER CLUSTER INSTANCE

最新推荐文章于 2026-06-20 09:16:35 发布

原创最新推荐文章于 2026-06-20 09:16:35 发布 · 775 阅读

16 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#网络

Shared disk & network setup

假期无事，未来大概率会有部署微软sqlserver群集的任务，提前用家中家中闲置两台laptop演练一番，

配置实在低，一台 4G ram, 另一台也只有 8G ram，如何整

好在两台笔记本的无线有线网卡都工作正常，快速计划如下

4G 内存的机器干脆直接部署DC – server0 , 另外一台8G 安装有win10 - Desktop, 虚拟化安装两台 windows server (winserver1, winserver2)

	Server0	Winserver1	Winserver2	Desktop
生产网络 ---通过无线网卡桥接连接完成加域等	192.168.31.106	192.168.31.132	192.168.31.133
心跳网络		10.10.10.10	10.10.10.11
共享存储网络 ---通过server0与desktop有线网卡网线直连然后虚机桥接网络连接	172.10.10.10	172.10.10.30	172.10.10.40	172.10.10.20
共享存储	Install iSCSI target 创建两个vhd, 一个计划用作仲裁，另一个计划当作共享存储	iSCSI initiator connect the VHDs	iSCSI initiator connect the VHDs

Join winserver to domain test.net

配置网卡IP 等，开通防火墙配置或者关闭防火墙，vmserver1,vmserver2 加入域，DC的安装配置就不再该节写了

network infor

（以下IP 信息都是在完全配置完成后截的）

Server0

Windows IP Configuration

Host Name . . . . . . . . . . . . : server0

Primary Dns Suffix . . . . . . . : Test.net

Node Type . . . . . . . . . . . . : Hybrid

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : Test.net

Ethernet adapter Ethernet:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Intel(R) Ethernet Connection (3) I218-LM

Physical Address. . . . . . . . . : 50-7B-9D-04-7F-27

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

IPv4 Address. . . . . . . . . . . : 172.10.10.20(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

NetBIOS over Tcpip. . . . . . . . : Enabled

Wireless LAN adapter Wi-Fi:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Intel(R) Dual Band Wireless-AC 7265

Physical Address. . . . . . . . . : 34-02-86-E3-D4-38

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

IPv4 Address. . . . . . . . . . . : 192.168.31.106(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.31.1

DNS Servers . . . . . . . . . . . : 192.168.31.106

192.168.31.1

NetBIOS over Tcpip. . . . . . . . : Enabled

Vmserver1

Vmserver2

Windows IP Configuration

Host Name . . . . . . . . . . . . : vmserver1

Primary Dns Suffix . . . . . . . : Test.net

Node Type . . . . . . . . . . . . : Hybrid

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : Test.net

Ethernet adapter Ethernet 2:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Hyper-V Network Adapter #2

Physical Address. . . . . . . . . : 00-15-5D-49-02-02

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::5098:87b:c56b:6ad9%6(Preferred)

IPv4 Address. . . . . . . . . . . : 10.10.10.10(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

DHCPv6 IAID . . . . . . . . . . . : 318772573

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2F-2D-F6-9A-00-15-5D-49-02-00

NetBIOS over Tcpip. . . . . . . . : Enabled

Tunnel adapter Local Area Connection* 10:

Media State . . . . . . . . . . . : Media disconnected

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Failover Cluster Virtual Adapter

Physical Address. . . . . . . . . : 02-E4-90-16-0A-F3

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Ethernet adapter Ethernet:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Hyper-V Network Adapter

Physical Address. . . . . . . . . : 00-15-5D-49-02-00

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

IPv4 Address. . . . . . . . . . . : 192.168.31.132(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

IPv4 Address. . . . . . . . . . . : 192.168.31.135(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

IPv4 Address. . . . . . . . . . . : 192.168.31.136(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.31.1

DNS Servers . . . . . . . . . . . : 192.168.31.106

NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Ethernet 3:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Hyper-V Network Adapter #3

Physical Address. . . . . . . . . : 00-15-5D-49-02-04

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::19bf:ccc7:985e:9ba%17(Preferred)

IPv4 Address. . . . . . . . . . . : 172.10.10.30(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

DHCPv6 IAID . . . . . . . . . . . : 385881437

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2F-2D-F6-9A-00-15-5D-49-02-00

NetBIOS over Tcpip. . . . . . . . : Enabled

Windows IP Configuration

Host Name . . . . . . . . . . . . : vmserver2

Primary Dns Suffix . . . . . . . : Test.net

Node Type . . . . . . . . . . . . : Hybrid

IP Routing Enabled. . . . . . . . : No

WINS Proxy Enabled. . . . . . . . : No

DNS Suffix Search List. . . . . . : Test.net

Ethernet adapter Ethernet 2:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Hyper-V Network Adapter #2

Physical Address. . . . . . . . . : 00-15-5D-49-02-03

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::31a2:5601:62ed:edda%5(Preferred)

IPv4 Address. . . . . . . . . . . : 10.10.10.11(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

DHCPv6 IAID . . . . . . . . . . . : 167777629

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2F-2D-F9-0A-00-15-5D-49-02-01

NetBIOS over Tcpip. . . . . . . . : Enabled

Tunnel adapter Local Area Connection* 1:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Failover Cluster Virtual Adapter

Physical Address. . . . . . . . . : 02-19-D1-5E-D7-F3

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::fa21:cfc8:df2e:32d8%18(Preferred)

IPv4 Address. . . . . . . . . . . : 169.254.2.226(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.0.0

Default Gateway . . . . . . . . . :

DHCPv6 IAID . . . . . . . . . . . : 302133742

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2F-2D-F9-0A-00-15-5D-49-02-01

NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Ethernet:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Hyper-V Network Adapter

Physical Address. . . . . . . . . : 00-15-5D-49-02-01

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

IPv4 Address. . . . . . . . . . . : 192.168.31.133(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . : 192.168.31.1

DNS Servers . . . . . . . . . . . : 192.168.31.106

NetBIOS over Tcpip. . . . . . . . : Enabled

Ethernet adapter Ethernet 3:

Connection-specific DNS Suffix . :

Description . . . . . . . . . . . : Microsoft Hyper-V Network Adapter #3

Physical Address. . . . . . . . . : 00-15-5D-49-02-05

DHCP Enabled. . . . . . . . . . . : No

Autoconfiguration Enabled . . . . : Yes

Link-local IPv6 Address . . . . . : fe80::8dbd:f81d:7d2f:e12e%8(Preferred)

IPv4 Address. . . . . . . . . . . : 172.10.10.40(Preferred)

Subnet Mask . . . . . . . . . . . : 255.255.255.0

Default Gateway . . . . . . . . . :

DHCPv6 IAID . . . . . . . . . . . : 234886493

DHCPv6 Client DUID. . . . . . . . : 00-01-00-01-2F-2D-F9-0A-00-15-5D-49-02-01

NetBIOS over Tcpip. . . . . . . . : Enabled

Login winserver with domain admin accounts

从AD中创建账号admin001, 为了避免权限的麻烦就直接赋予了domain admins

PS C:\Users\Administrator> Get-ADPrincipalGroupMembership admin001 | select name

name

----

Domain Users

Domain Admins

Shared disks setup

通过iSCSI 虚拟磁盘来做共享磁盘

安装iscsi 目标服务器角色server0，并配置

配置如下：

Vmserver1 & vmserver2 connect the two vhd disks

Online ->initialize the disk -> new volumn -> format the disk from vmserver1 or vmserver2

Windows server failover cluster install and configurations

Install WSFC feature on both vmserver1 and vmserver2

start wsfc console


Validate configuration
Add two servers
Run all test until complete
Create cluster Select the two servers Then name the cluster with IP

Install sql server failover cluster

On vmserver1 new sql server failover cluster installation

Then on vmserver2 add node to a sql server failover cluster

Validate the sqlserver failover cluster

Connect the sql instance via newsqlcluster