. Environment preparation
Virtual machines: ssag-bj-ad-01, ssag-bj-fc-01, ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-ad-01, ssag-sh-fc-01, ssag-sh-sql-01
?
. Primary domain Controller
SSAG-BJ-AD-01 Installing the server role Active Directory Domain Services,
?
. Secondary domain controllers
ssag-sh-ad-01 install? server role Active Directory Domain Services?
?
.? Join Domain
ssag-bj-fc-01, ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-fc-01, ssag-sh-sql-01
?
?
.? Installing a Failover Cluster
ssag-bj-fc-01, ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-fc-01, ssag-sh-sql-01
?
. Creating a Failover Cluster
Cluster core resources, IP address designation, re-online
Create a record in the DNS server
?
. Install database, open AlwaysOn
ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-sql-01
?
. Service run changed to domain user
SQL Server,sql Server Agent
ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-sql-01
?
. Open Named Pipes Service
ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-sql-01
?
. Add domain user as database administrator
ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-sql-01
?
. Add a firewall rule that allows SQL Server
ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-sql-01
?
. Join AlwaysOn
Back up the database, restore NORECOVERY mode
?
. Add a client access point
Add Resource Client Access point change IP, online
?
SQL Server AlwaysON