Getting started with Microsoft Cluster Service, Part 8: Create MSSQL server cluster (2)

This entry is part 8 of 8 in the series Getting started with Microsoft Cluster Service

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

Step-by-step create MSSQL server cluster

  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.
    Cluster Group Selection
  2. On Cluster Node Configuration, add ‘BKKSQL020’ as another node to include to MS SQL Cluster server. Click next.
    Cluster Node Configuration
  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.
    Remote Account Information
  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.
    Required domain admin permission
  5. Now, I re-login again and type the password. Click next.
    Remote Account Information
  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’.
    Create a service account
  8. Set password for the account and check password never expires and user cannot change password.
    Specify password for the service account
  9. Next, create a new Windows domain group for MS SQL Cluster services. I name a group as ‘ClusterSvrGroup’.
    Create a Windows domain group
  10. Back to the setup wizard. On Service Account, type the user account that you have just created. Click next.
    Specify Service Account
  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.
    Specify Domain Groups for Clustered Services
  12. On Authentication Mode, you can customized as you want. I’ll leave it as default. Click next.
    Select SQL Authentication Mode
  13. On Cluster Settings, I’ll leave as default.
    Cluster Settings
  14. On Error and Usage Report Settings, click next.
    Error and Usage Report Settings
  15. On Ready to Install, click next to begin the installation.
    Start 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.
    The installation progress
  17. On Setup Progress, this is the installation progress on BKKSQL020.
    The installation progress
  18. On Completing Microsoft SQL Server 2005 Setup, click finish. The setup has finished.
    Finish installation
  19. Open Cluster Administrator and click on ‘SQL2K5’ group, you’ll see the resources have been configured already.
    MS SQL Server's resource on Cluster Administrator
  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’.
    Connect to MS SQL Server cluster
  21. That’s it. The server is working!.
    Connected

Summary

After all 8 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.

Series Navigation<< Getting started with Microsoft Cluster Service, Part 7: Create MSSQL server cluster (1)

11 Comments

  1. Benoit July 13, 2008
  2. Poguellete August 3, 2008
  3. Jammy September 8, 2008
  4. Réda September 16, 2008
  5. Réda September 16, 2008
  6. Jonh_nathan March 8, 2009
  7. linglom March 10, 2009
  8. Zira March 26, 2009
  9. Rems September 8, 2009
  10. Moises July 31, 2010
  11. Coralie May 24, 2011

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.