This is the last part of the series. Once you have configured windows cluster and MSDTC, installing SQL is piece of cake. I already mentioned in part 1 that you have to download ISO (SQLEVAL.ISO) which we would need to attached as CD drive which would have setup files. I have copied the image on E:\Virtual Server\SQLEVAL.ISO
We also need to create domain account and domain groups in domain controller. So, logon to domain controller. Go to Start > Run > DSA.msc and follow below screen-shots.
Give the details of account (i.e. SQLSVC)
Set the password after clicking next button. Make sure that "Password never expires" is checked and "User cannot change password" is checked.
One account is created, lets add a Group and add SQLSVC into the group.
Give Group Name "SQL Admin Groups"
Right click on "SQL Admin Groups" properties and add "members"
Now you are done with Domain controller.
Now, let's mount ISO image to MyNode1 and MyNode2. To do this, go to Virtual server console.
Click on CD/DVD and fill details as below
Above has to be done on both the nodes. Once you do that, you can see SQL Installation CD mounted on MyNode1 and MyNode2.
Lets Start SQL setup now.
Now we are done with the setup and we should see the resources in cluster admin under SQL Group.
Any feedback is greatly appreciated.
Well explained and helpfull. Thank you.
I love your patience
Nice article. I learnt how to work on clusters...
it's a great notes for sql holders mr.
Balmukund i hve doubt on fail over clustring how to install cluster in windows service pack 2 at 2005 sql server
Can you please explain the question?
Hi, Do you have any step by step documents which explains SQL server 2005 cluster install on Windows 2008 R2 ? or Can you share steps which I need to be aware of during this install