规划:3台虚拟机:1台作为域控(DC),另外2台安装SQL Server

序号名称

TCP/IPv4

备注

1

sqldc

192.168.0.100
255.255.255.0
192.168.0.254
DNS:127.0.0.1

DC

2

sql01

192.168.0.101
255.255.255.0
192.168.0.254
DNS:192.168.0.100

Node 1

3

sql02

192.168.0.102
255.255.255.0
192.168.0.254
DNS:192.168.0.100

Node 2

4

sqlalwayson

192.168.0.110

VIP-Cluster

5

sqllistener

192.168.0.111

Alwayson VIP

 

环境配置:

1. 服务器安装Windows 2012 R2

2. 域控安装AD/DNS

3. SQL服务器安装 .NET Framework 3.5/4.0、SQL Server 2014

4. 域控放置WCF仲裁文件夹(偶数节点)

5. SQL服务器安装WCF, 启用Alwayson