Linglom's blog

This post is continued from Getting started with Microsoft Cluster Service, Part VI: Create a MSSQL server cluster (1).

The series are divided into 6 parts:

• Getting started with Microsoft Cluster Service, Part I: Introduction
• Getting started with Microsoft Cluster Service, Part II: Configure iSCSI disk
• Getting started with Microsoft Cluster Service, Part III: Create a new server cluster
• Getting started with Microsoft Cluster Service, Part IV: Add a node to the existing server cluster
• Getting started with Microsoft Cluster Service, Part V: Create a file server cluster (1)
• Getting started with Microsoft Cluster Service, Part V: Create a file server cluster (2)
• Getting started with Microsoft Cluster Service, Part VI: Create a MSSQL server cluster (1)
• Getting started with Microsoft Cluster Service, Part VI: Create a MSSQL server cluster (2)

Step-by-step

1. On Cluster Group Selection, select group name on cluster that you want MS SQL Server 2005 to configure and also select folder to keep data files. Click next.
   
2. On Cluster Node Configuration, add ‘BKKSQL020′ as another node to include to MS SQL Cluster server. Click next.
   
3. On Remote Account Information, enter password of the current account for install MS SQL Server on each server (if you select more than a node). This account must be an administrator of each server. In this exmaple, you’ll see that I logged in as a local administrator which will throw an error on the next step.
   
4. The error message showing that you’re trying to use local account to install MS SQL Server. But the setup requires you to logged in as a domain account that has an administrative privilege (eg. Domain admin). If you see this error message, you need to login again with that account.
   
5. Now, I re-login again and type the password. Click next.
   
6. Before proceed next step, the setup’ll require you to specify the service account and group for running MS SQL Server services. If you already have an domain account and group for running service, you can skip to step 9.
7. Create a new domain account with default privilege (normal domain user). In this example, I create a domain user ‘SQLClusterSrv’.
   
8. Set password for the account and check password never expires and user cannot change password.
   
9. Next, create a new Windows domain group for MS SQL Cluster services. I name a group as ‘ClusterSvrGroup’.
   
10. Back to the setup wizard. On Service Account, type the user account that you have just created. Click next.
    
11. On Domain Groups for Clustered Services, type the group that you’ve just created. The service account will be added to this group automatically. Click next.
    
12. On Authentication Mode, you can customized as you want. I’ll leave it as default. Click next.
    
13. On Cluster Settings, I’ll leave as default.
    
14. On Error and Usage Report Settings, click next.
    
15. On Ready to Install, click next to begin the installation.
    
16. On Setup Progress, the setup will install on each server simulteneous. Click on node to change to other node to see the installation progress. This is the installation progress on BKKSQL010.
    
17. On Setup Progress, this is the installation progress on BKKSQL020.
    
18. On Completing Microsoft SQL Server 2005 Setup, click finish. The setup has finished.
    
19. Open Cluster Administrator and click on ‘SQL2K5′ group, you’ll see the resources have been configured already.
    
20. Now try to test if the MS SQL Server is work properly. Open Microsoft SQL Server Management Studio and connect to the MS SQL Server cluster using the virtual name that you’ve specify when setup. In this example, it is ‘BKKSQLCluster’.
    
21. That’s it. The server is working!.
    

Summary

After all 6 parts, you should get better understanding and familiar with Microsoft Cluster Service. There are many type of services that can implement as clustering, for instance, DHCP, WINS, Print Spooler, SMTP, etc. It shouldn’t be hard for you to implement one of these services on your own after you have followed this article.