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

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

Well, 6 parts have passed and now you should familiar with MSCS. This part, you’ll learn how to create another clustering service which is an important service that support clustering by design. It is Microsoft SQL Server. To setup MS SQL Server clustering, you’ll need to own a license of an enterprise edition of MS SQL Server. Next, I’ll show how to setup Microsoft SQL Server 2005 cluster. Like the previous part, I decide to separate this part into 2 posts because it’s a quite long part.

As I tell you before, MS SQL Server supports clustering by design so you don’t need to configure many things on Cluster Administrator as File Server Cluster. The main configurations will be on the installation of SQL Server 2005.

Step-by-step to create MSSQL server cluster

  1. Connect to the existing cluster. Log-in to BKKSQL010 with domain administrator privilege. The permission is required for installing MS SQL Server on each server.
    Log-in to the server
  2. Open Cluster Administrator -> Open a connection to ‘BKKCluster’.
    Connect to existing cluster
  3. Create a new group on ‘BKKCluster’ named as ‘SQL2K5’. This group will keep all the resources for MS SQL Server clustering.
    Create new group on cluster
  4. On Preferred Owners, add both servers to preferred owner. Click finish.
    Add Preferred Owners
  5. Move physical disk resource ‘Disk R:’ to this group. It’ll show a warning message, click Yes to proceed.
    Note: This resource is created from the previous part. If you haven’t read the part, you can create new physical disk resource and select Disk R:. The resource will be a data disk that keep installation and data files for SQL Server Cluster.
    Move physical disk resource
  6. Now you have ‘Disk R:’ resource in ‘SQL2K5’ group.
    'Disk R:' resource in 'SQL2K5' group
  7. Click on BKKSQL010 -> Active group to check if the group is on this server and status is online.
    Check the resource's status
  8. Next, install MS SQL Server 2005. Insert installation CD, click “Server components, tools, Books Online, and samples”.
    Install SQL Server 2005
  9. On EULA, check “I accept…” and click Next.
    I accept terms on EULA
  10. On Installing Prerequisites, click Install. The setup will install these prerequisite softwares automatically: .NET Framework 2.0, MS SQL Native Client and MS SQL Server 2005 Setup Support Files on the server.
    Installing Prerequisites
  11. When finishes installing on Installing Prerequisites, click Next.
    Installing Prerequisites
  12. On SQL Server 2005 Installation wizard, click Next.
    Microsoft SQL Server 2005 Setup
  13. On System Configuration Check, click Next.
    System Configuration Check
  14. On Registration Information, type name and company. Click Next.
    Enter Registration Information
  15. On Components to Install, select ‘SQL Server Database Services’ and ‘Create a SQL Server failover cluster’. Then, click Advanced for customize components to install.
    Note: This is only an example so I’ll not install other services except that the database services itself. Also, notice that you have to check ‘Create a SQL Server failover cluster’. This is the different step from installing a stand-alone SQL Server.
    Select Components to Install
  16. On Feature Selection, select to install ‘Management Tools’ in Client Components. This will install ‘SQL Server Management Studio’ which use to mange SQL Server in later step.
    Feature Selection
  17. On Instance Name, leave default instance. Click Next.
    Define Instance Name
  18. On Virtual Server Name, type the name for this SQL Server cluster. Click Next.
    Note: This will be the name that use to connect to the SQL Server cluster.
    Create a Virtual Server Name for SQL Server Cluster
  19. On Virtual Server Configuration, create an IP Address for this virtual server. In this example, I use ‘192.168.1.5’. Click Add.
    Create a Virtual IP Address for SQL Server Cluster
  20. On Virtual Server Configuration, the IP Address will be in Selected network and IP Address. Click Next to continue.
    Create a Virtual IP Address for SQL Server Cluster
  21. That’s it for this post. Continue on Getting started with Microsoft Cluster Service, Part VI: Create a MSSQL server cluster (2).
Series Navigation<< Getting started with Microsoft Cluster Service, Part 6: Create File Server Cluster (2)Getting started with Microsoft Cluster Service, Part 8: Create MSSQL server cluster (2) >>

One Response

  1. Chaitanya August 30, 2013

Leave a Reply

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