SQL Server AlwaysON

. 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