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.
- Log off from MyNode2. This is required to avoid running into known bug.
- Log on to MyNode1.
- Move all the resource groups to MyNode1 using Cluster Admin
- Go to DVD drive and double click on setup.exe from Servers folder
- Accept EULA. Next.
- Click ‘Install’ and wait for SQL Server to configure components and setup the installation. Once the required components (.NET Framework 2.0, MS SQL Native Client and the SQL Server 2005 setup support files) have been installed click ‘Next’
- Click ‘next’ when prompted with the screen ‘Welcome to the Microsoft SQL Server Installation Wizard. The installation will then proceed through the ‘System Configuration Check’- click ‘next’ to proceed.
- Enter Registration Information, click ‘next’
- Components to Install- Select all components (SQL Server Database Services, Workstation components) , then click ‘next’
- Since this is the first installation of a new database instance for SQL server, select ‘Default Instance’.
- Provide Virtual Server Name (VirtualSQL)
- Provide Virtual SQL Server IP Address (220.127.116.11) in Next screen and click on Add. Then Next
- Provide SQL Group in Next screen as shown below
- Click Next on Below Screen
- Provide Administrator Password in next screen and click Next
- Provide SQL Service Account created earlier on domain controller(sqlsvc)
- Provide Domain Group which we created earlier (SQL Admin Groups)
- Authentication Mode. Choose Mixed Mode (Windows Authentication and SQL Server Authentication), provide sa password and click ‘next’
- Keep the default settings (SQL Collations- Dictionary Order, case-insensitive, 1252 character set) and click next
- Error and Usage Report Settings. Leave defaults (none checked). Click ‘next’
- Check installation Settings, click ‘install’.
- During the install process you can always see what is happening on other node.
- Once the installation process is completed, click ‘next’
- And finally… Finish.
Now we are done with the setup and we should see the resources in cluster admin under SQL Group.
Any feedback is greatly appreciated.