Install SQL Server 2008 R2 Cluster (part 1 of 4)

In the previous articles, I ever introduce how to build windows failover cluster with Microsoft iSCSI Target 3.3. So this is time to express what application will be installed on this cluster environment. It will be SQL Server application now.
Why? Because I need to build this lab for one project to realize the basic database management and SQL language even though I am not an DB expert or DBA!

At first, I search the related information from Internet or document to study hard. Then I summary some basic step and process to write down on this Blogger. If you will follow the procedure(including cluster service prerequisite in the previous article), I will promise SQL Server Cluster will be installed successfully. Let us begin to do the related process now!

(1).Install Application Server
Enable "ktmRm for Distributed Transaction Coordinator" Service

• Click "Start" --> "Administrative Tools" --> "Services"

•  Right-Click "ktmRm for Distributed Transaction Coordinator" Service and click "Properties" in menu

•  Change "Startup type" from Manual to Automatic ,click "Start" button next to click "OK" button

•  So do that the service status will be started now.

Add Application Server Role

• Click "Start" --> "Administrative Tools" --> "Server Manager"

•  Click "Roles" --> "Add Roles"

•  Click "Next > " button

•  Click "Application Server" check box

•  The message tell you need to install the required features firstly next to install Application Server. In the moment, please directly click "Add Required Features".

•  Click "Next > " button

•  Click "Next > " button

•  Click "Incoming Remote Transactions" and "Outgoing Remote Transactions" check box next to click "Next > " button

•  Click "Install" button

•  The installation process is running now.

•  Finally, the installation is successful now.