Processor: AMD FX 4100 (3.6 GHz) 4 core, 12MB Cache
Mother board : M5A88-M, Bios Ver 0801
OS: Windows server 2008-R2, with SP1.
After successful installation expand the roles in Server management, now we have to create a new Virtual Machine.
3 Hold on….. before that we have to create one virtual network in Hyper-v as bellow
I named it as VM Network, and choose the ‘Private Virtual Machine Network’
5. For setting up AlwaysOn, we need minimum 3 VM, out of which one should be Active Directory. First I am creating the VM for AD and so I am using the VM name as AD. Using this wizard we can keep the Virtual machine file in any location of the Physical machine. I am using a location in my E: drive.
6. I have allocated 1 GB of RAM to my first VM. You can allocate it as per the availability.
7. Select Private network, which we created. This is our Domain network.
8. Choose the virtual hard disk
9. Now we have to say about the Operating system on this VM. I am using same OS as my physical machine which is Windows Server 2008. Here I have used the ‘Install an operating system from a boot CD’ and then press the finish button
bcdedit /set xsavedisable 1
Once you connect to that VM, you can install OS from DVD drive. On first login Administrator password has to set. Then connect to AD as administrator, using Hyper-v manager, and Disable Firewall, and set the computer name as ‘AD’ and set the ‘VM Network’ IP as ‘184.108.40.206’.
You can copy the Virtual hard disk and create Node1 and Node2.
So now we have 3 VM with the below details
1. AD (ip 220.127.116.11)
2. Node1 (ip 18.104.22.168)
3. Node2 (ip 22.214.171.124).
11. Now we have to Setup Active Directory in the first virtual machine -AD.
Finally I got the below screen
12. After that add the Role ‘Active Directory domain services‘
Now we need to restart the virtual machine AD
Shutdown AD machine in hyper-v.
18.I have created a domain user ‘manupradeepmanu’ . After creation of this user you need to add this user in Administrator.
For that click ‘Administrator’ group in the same window, then add the users.
19 You can disable the firewall in all the VM as this is a demonstration. In actual case we have to create rules in Firewall for Inbound and outbound connection.
Now you have to make sure you are able to ping to each machine. If you are not able to ping them, something wrong in the setup and then you will not be able to setup your domain network
20. Now we have to add Node1 virtual machine to domain the created domain. In my case domain is Manupradeep.com
For that connect to Node1, using built in administrator(this is the first username which is created automatically and yo will be feeding the password at the time of OS installation)
Go to Network connections and in ‘IP set page’ check the DNS ip as 126.96.36.199
<<I will upload the screen shot>>
Go to “Server Manager”–>Computer Name–>Change–>Domain.
Finally you will get a confirmation
22. Similarly Add Node2 to domain after chaning the name and ip to Node2, and 188.8.131.52
(Follow the same step as 20, in Node2)
23. Steps 23 to 26 are optional, and not mandatory for AlwaysOn. Uusing these steps i have configured one more network, and using which we can copy some data between physical machine and virtual machine. You can’t copy any information from physical machine (server) to AD,Node1 and Node2 with out a network
24. Add Internal network to all vm, after stopping them in Hyper-v.
25. Disable all the firewalls, and set ip of physical machine to 192.168.10.20
26. Make shared folders in Node1 and Node2, and copy SQL server setup to Node1-shared and Node2-Shared
27. Add feature ‘Failover Clustering’ in both the node.
Server Manager–>Add Feature–>Failover Clustering
You can restart the machine if it asking for that.
Now you can see one more item in the Administrative Tools as ‘Failover Cluster Manager’
28. Set domain user as Administrator of Node1
Now we are going to set up Failover Cluster for high availability
29.Enable “AlwaysOn High Availability Group” on both the Nodes and restart SQL Service
Right click on ‘SQL server’ and select properties, Go to AlwaysOn High Availability Group and enable the checkbox
30. Log in with manupradeepmanu to Node1, Admin tools–>Failover cluster manager–>create a cluster.
31. I have selected cluser name as cluster_manu, and selected 184.108.40.206 as ip of the cluser.
32. In SQL server configuration manager, Select ‘SQL server Services’
Start the mssql service if it not running.
Now we have to go for High Availability Group in SQL.
Double check step 29 by Right click on ‘SQL server’ and select properties, Go to AlwaysOn High Availability Group and enable the check-box
33. Log in to Node1, SQL server Management studio
34. Change the log on userid for SQL server service on all the Node to the domain user.
35. Create a userdatabase, DB_MANU and created a table, inserted 10 records
36. Take a full backup of the database.
37. SQL server management studio –>Node1–> Alwayson High Availability–>Create new Availability group.
Check the backup preferance option tab
38. Here we have to add the Listener for Availability group. I have used the name “AVG_Listener” and have used the IP “220.127.116.11”.
39. Restarted the same wizard
So we have done with the setup, once you check the databases in Management Studio you can see the below screen
Here you have to double check the service account of SQL service, and it is better to use the domain user, and the shared location which we mentioned in the Cluster creation should be accessible to this account. If there is any mismatch , the database synchronisation will not work
40. Now we are going to test “Manual failover”
For this i have created a table in primary and inserted few records. Then open the secondary and see the values. As we have selected “Synchronous” both the nodes will get updated.
If you check the primary and secondary nodes we can understand its roles are changing once we manually fail-over to the other node.