Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

SQL Server Alwayson Building one: planning

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

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

DC

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report