SQL Server 2012 clustered instance
In continuation of our series on how to install a SQL Server 2012 clustered instance, let´s begin the actual installation, starting from the first node.The objective of this post is to demonstrate how to install the first node of a clustered SQL Server 2012 instance and how to basically manage it.
2. From Virtual Machine Setting click Add, to add a new network adapter and click Next.
3. Select "Custom: Specific virtual network", and from the list and click finish.
4. Sign in to SQL1 by using domain Administrator login.
5. Open "Server Manager", click on "Local Server", select Ethernet1, and rename it to "HeartBeat".
6. Double click on HeartBeat, then select Properties to set a static IP address. Uncheck these three options:
8. Click on DNS tab, uncheck Register this connection’s addresses in DNS option.
9. Finally, from WINS tab, select the Disable NetBIOS over TCP/IP option and click OK.
1. Open the Server Manager from the task bar.Configure Server
Now open Server Manager , select Local Server , right click on Ethernet(), and rename it to Domain.
Double click on domain, then select Properties to set a static IP address. Uncheck these three options:
- Linked-Layer Topology Discovery Mapper I/O Driver
- Linked-Layer Topology Discovery Responder
- Internet Protocol Version 6 (TCP/IPv6)
Double click on Internet protocol version 4, select Use the following IP address, set IP address with 192.168.10.1 and Preferred DNS with 192.168.10.100 , and leave Default Gateway empty.
We can change the computer name and join it to "SQL1" domain.
Heartbeat connection
After restarting the SQL1 virtual machine, we need to add a new heartbeat connection.
1. Right Click on the virtual machine name & select Setting
- Linked-Layer Topology Discovery Mapper I/O Driver
- Linked-Layer Topology Discovery Responder
- Internet Protocol Version 6 (TCP/IPv6)
7. Double click on Internet protocol version 4, select Use the following IP address, set IP address with 192.168.20.1 , and leave Default Gateway and DNS Servers empty. Then click on Advanced.
Installing .NET Framework 3.5
2. From Server Manager Dashboard select Add roles and features. This will launch the Roles and Features Wizard allowing for modifications to be performed on the Windows Server 2012 instance.
5. From add and Roles features wizard just click next.
6. Mark in the box next to .Net Framework 3.5 Features and click next
Configure iSCSI Initiator
1.Go to Start Menu and click on Administrative Tools.
3.Fill the Target: with 192.168.10.100, then click on Quick Connect and click on Done and OK.
4. Open Disk Management, then right click on Disk 1 and click Online.
Add Windows Cluster feature
1. Open Server Manager and click on Add roles and features, and follow the regular steps
2. When you reach Features check the box of Failover Clustering, click on Add Features and on Next.
Congratulation you just finished your first node. :)
Post a Comment