Install SQLServer2012 cluster on Windows Server R2 System (abbreviated)

4 Servers (1 AD, 2 SQL Server, 1 iSCSI storage server)

9 IP (1 AD IP, 2 SQL Server IP, 2 heartbeat IP, 1 iSCSI Storage server IP, one cluster IP, 1 DTC IP, one cluster IP)

1. Build a domain environment

The IP address of the Dcserver is configured as 192.168.80.200,dns:192.168.80.200

Run dcpromo install AD on Dcserver

2, Node1 and Node2, and storage server join domain

3, install Starwind on the storage server, add a hard disk and format, open starwind,root password is starwind, add three target (Q, data, Sqldisk)

4. Implement shared storage on Node1 and Node2: Open Node1 Management tool->ISCSI Initiator properties, add Storage server IP192.168.80.20 in discovery. Connect two disks in "Target". You will then find two more disks in Disk Management and format them as E, F, respectively. Repeat the same action in the Node2.

5. On the domain control server, open the ad computer and user, create a new user username cluster password password1!. and join the Domain Admins group domains Admins

6. Open failover Cluster Manager on Node1 to create a cluster. Define the cluster name and Ip:winc, 192.168.80.10. Ensure that the domain administrator has Full Control (view on DC) before entering the cluster name and address, and after the cluster is created, verify that the quorum disk is correct.

7. Configure the service or application to increase the DTC. Define the name and IP:WINCDTC, 192.168.80.30.

8. Install SQL SERVER 2012 on one node: start the installation selection

SQL cluster name and address: SQLCluster, 192.168.80.40, start account cluster password password1! , login mode is Windows logon and SA login, password is limydb_123456.

9, in another node also installed SQL SERVER2012, start the installation of the time to choose

Start account cluster Password password1!

11. The SQL SERVER 2012 failover cluster was successfully installed. Test SQL Server failover, open a new machine node3, configure the network adapter to Vmnet8,ip address of 192.168.80. 60, open SQL, the password is limydb_123456.

Then use the database, you can disconnect Node1 or node2, the discovery of the database is still available, the cluster switch when the database may be slightly delayed, connected to the Node1 or Node2, to right-click to verify the cluster.

Install SQLServer2012 cluster on Windows Server R2 System (abbreviated)