What are you looking for ?
Home » » Node (1)

Node (1)

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.

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:
  1. Linked-Layer Topology Discovery Mapper I/O Driver 
  2. Linked-Layer Topology Discovery Responder 
  3. 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
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:
  1. Linked-Layer Topology Discovery Mapper I/O Driver 
  2. Linked-Layer Topology Discovery Responder 
  3. 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.
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.

Installing .NET Framework 3.5

1. Open the Server Manager from the task bar.
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.
3. Select Role-based or features-based installation from the Installation Type screen and click Next.
4. The current server is selected by default. Click Next to proceed to the Server Roles tab.
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
7. Click on the link specify an alternate source path
8. Determine the .Net Framework 3.5 from windows sources " D:\sources\sxs" & click OK

Configure iSCSI Initiator

1.Go to Start Menu and click on Administrative Tools.
2.Double click on iSCSI Initiator and click on Yes.
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.
5. Again, right click on Disk 1 and click on Initialize Disk.
6. Right click on Disk 1 and click on New Sample Volume.


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.
3. By now you should be an expert in Add Roles and Features Wizard",follow  the regular steps till the setup completed successfully.

Congratulation you just finished your first node. :) 
Share this article :

Post a Comment

Flag Counter

Social Profile

 
Copyright x 2011. By Wael Medhat - All Rights Reserved