规划: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