SLTechnology News&Howtos › Database ›

SQL Server Alwayson Building one: planning

Shulou Source: shulou.com Published: 2022-06-01 09:05:09 10月02日 Update

Plan: 3 virtual machines: 1 as domain control (DC), the other 2 install SQL Server

Serial number name TCP/IPv4

Remarks 1

Sqldc

192.168.0.100

255.255.255.0

192.168.0.254

DNS:127.0.0.1

two

Sql01

192.168.0.101

255.255.255.0

192.168.0.254

DNS:192.168.0.100

Node 1

three

Sql02

192.168.0.102

255.255.255.0

192.168.0.254

DNS:192.168.0.100

Node 2

four

Sqlalwayson

192.168.0.110

VIP-Cluster

five

Sqllistener

192.168.0.111

Alwayson VIP

Environment configuration:

1. Server installs Windows 2012 R2

two。 Domain control installation AD/DNS

3. SQL server installs .NET Framework 3.5max 4.0, SQL Server 2014

4. Domain control places WCF arbitration folder (even number nodes)

5. Install WCF on SQL server and enable Alwayson