Windows 2008 Clustering with SQL Server 2008 cluster installation Configuration

Source: Internet
Author: User
Tags failover sql 2008

First, Summary:

This article mainly describes how to install the cluster configuration for SQL Server 2008 on a Windows Server R2 system.

Second, prepare:

At least three servers need to be prepared in advance (the reason to see here, my experiment is installed on the desktop computer, the system installed here does not speak. If you do not have a host device, this experiment installs the implementation on the VMware virtual machine. Basically the same, the virtual machine this piece I do not speak here.

Because there is no storage server on hand, all the iSCSI storage servers can only be simulated with Microsoft Iscsitarget software. All in fact, I used this device to install a domain controller and use him to emulate iSCSI storage disks. The primary and standby server node requires two network ports, the heartbeat line and the cluster communication line.

The end of the blog is that I encountered during the installation of some error messages, as well as the solution, if you have an error in the installation process to see if there is the same error.

The simple structure diagram is as follows:

650) this.width=650; "src=" Http:// "title=" Qq20160416095512.jpg "alt=" Wkiom1crm4tqqzyhaac6lhahgnw663.jpg "/>

Third, server information description

Name IP description

Iscsilist domain Controller/Storage Server

WIN-UFTR6LR1UPM SQL Server cluster Node 1

WIN-BS4T5CUJCA2 SQL Server cluster Node 2

Mycluster win server failover cluster virtual IP

CLUSTER2008R2 SQL Server cluster virtual IP

MYCLUSTER-DTC SQL Server cluster DTC virtual IP

In this is just a simple description of the installation process, if you want to formally use the need to follow up the specific situation to be modified and configured appropriately.

Four, virtual iSCSI storage configuration.

Installation process I will not talk, file download link: Http:// Password: v3gs

It is good to install the appropriate version according to your system.

Specific installation configuration steps see another blog post iSCSI emulated disk installation

Five, domain controller installation

To configure a failover cluster for win server, you need to install the AD domain first. Here is an article that has a good description of Portal: The role of domain controllers in the domain. The installation of the domain controller is still relatively simple, but if you want to use the rights management, you need to study well. A cluster can only be managed by a domain controller, and a node cannot set up a cluster. After SQL Server 2008, the Cluster service is not supported on the same device as the domain controller. (That is, if you have a domain controller installed, you will not be able to install the SQL Server Cluster service on this computer.) )

Installation process View Another blog post simple installation steps for a domain controller

Vi. cluster configuration

1, add the failover cluster function, select Good after the next point, in the choice of installation is good. All two nodes are joined to the domain, and the failover cluster is also installed.

650) this.width=650; "src=" Http:// "title=" 1.png " Width= "height=" 395 "border=" 0 "hspace=" 0 "vspace=" 0 "style=" width:700px;height:395px; "alt=" Wkiom1cnxo3b1f9maaisdj9ogk4051.png "/>

2, after the failover cluster is installed, open failover Cluster Manager, the first step to do is to verify the configuration, this step is to verify whether your cluster nodes meet the requirements of the cluster.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:464px; "title=" 2.jpg "width=" "height=" 464 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqv--r5urmaaqk_z2zyz8282.jpg "/>

3. One of the hosts that is not selected in is my domain controller.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:461px; "title=" 3.jpg "width=" "height=" 461 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqwkuykhxcaaqmhcei8ac118.jpg "/>

4, the host name in the domain before joining the best prior modification, otherwise it is difficult to remember. I do not change this without modification in the maintenance of the back of the time difficult to remember.

650) this.width=650; "src=" "style=" float: none; "title=" 4.jpg "alt=" Wkiom1cqv_pcxmmwaae7s7oifpy106.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 5.jpg "alt=" Wkiol1cqwkzsq633aafe2670w-s799.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 6.jpg "alt=" Wkiom1cqv_xgrjrhaahn1mqensa422.jpg "/>

5, after the test you have to query the next report, to see if the content can not meet the needs, according to the prompts to adjust accordingly.

650) this.width=650; "src=" "style=" float: none; "title=" 7.jpg "alt=" Wkiom1cqv_atzrbuaafydtvii_m407.jpg "/>

6. After the configuration verification is complete, start creating the cluster.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:380px; "title=" 8.jpg "width=" "height=" 380 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" wkiom1cqv_ Jw3knlaaplnxgu1b0753.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:526px; "title=" 9.jpg "width=" "height=" 526 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqwlpjehzkaaoi8ajuoqi808.jpg "/>

7. Add the appropriate nodes to the cluster.

650) this.width=650; "src=" "style=" float: none; "title=" 10.jpg "alt=" Wkiol1cqwltbdc14aaek59xplti407.jpg "/>

8, the cluster name, according to their own needs to fill out the cluster name, and then enter the virtual IP cluster.

650) this.width=650; "src=" "style=" float: none; "title=" 11.jpg "alt=" Wkiol1cqwlwze1mnaagktlioxcs142.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 12.jpg "alt=" Wkiom1cqv_2xcdfraae5q-4pccy952.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 13.jpg "alt=" Wkiol1cqwlejhhhwaaffefihqje065.jpg "/>

9. A cluster is created. Cluster usage and configuration I'm not going to say much, I installed it with a use, familiar with the next configuration.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:496px; "title=" 14.jpg "width=" "height=" 496 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqwalx6xxpaavzb-e6ozo070.jpg "/>

Here's a place where you need to set up a heartbeat line of cluster network traffic to disable it for him, right? You have to experiment, unplug the external cable, unplug the heart line. All sorts of ways to try to get the cluster to transfer normally, you will understand.

650) this.width=650; "src=" "title=" network. jpg "alt=" Wkiol1crntxdqzmlaangwunqzcm154.jpg "/>

10, the cluster is created, before installing the SQL Sever cluster, we need to install an application called Ms DTC (distributed Thing Coordinator). What do you use this for? Why do you want to install this application?

With the popularization of network, the application of distributed database is more and more common. Data that is logically a whole in a distributed database is stored on multiple servers. A large commercial bank may store the customer's credit card consumption information and cheque consumption information on different servers, but the user's deposit account only one, when the user in any form of consumption, the computer must be stored on different servers at the same time to update information.

To better coordinate and handle this distributed transaction, SQL Sever 2000 uses MS DTC. MS DTC is a transaction manager that allows a client's application to operate on a data source that is distributed across multiple servers in a single transaction. MS DTC implements distributed transactions by means of two-stage submissions, and updates to multiple servers are either all successfully executed or not executed at all, effectively guaranteeing data consistency and integrity.

OK, understand what MS DTC is after we started installing this cluster application.

650) this.width=650; "src=" "style=" float: none; "title=" 15.jpg "alt=" Wkiol1cqwluzkqohaac94w_qslk048.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 16.jpg "alt=" Wkiol1cqwlyjs1pnaagbbhdpwku308.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 17.jpg "alt=" Wkiol1cqwl2g2v2-aahmidoyszc032.jpg "/>

11, the name is automatically generated, can be changed to change, according to individual needs. Of course, there is also a virtual IP address to configure.

650) this.width=650; "src=" "style=" float: none; "title=" 18.jpg "alt=" Wkiol1cqwl6dgglcaagwtas0ucq969.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 19.jpg "alt=" Wkiom1cqwaas1efvaae0jabb0tg315.jpg "/>

650) this.width=650; "src=" "style=" float: none; "title=" 20.jpg "alt=" Wkiom1cqwafrmotbaafwpz-wcyo203.jpg "/>

12, after the cluster and DTC installation is complete, I can test whether the two IP can pass.

650) this.width=650; "src=" "style=" float: none; "title=" 21.jpg "alt=" Wkiom1cqwamhp3znaaklpz4-qns649.jpg "/>

OK, we're going to start installing the database now, I'm going to install SQL 2008 here

13, the first installed node select failover cluster installation, only install this before the cluster node can be added.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 1.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqygez8xqdaaj9hoptad0264.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:519px; "title=" 2.jpg "width=" "height=" 519 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqyshqetm2aaj8wdpm6f8043.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:530px; "title=" 3.jpg "width=" "height=" 530 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqyskc2aalaahotplim58851.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:538px; "title=" 4.jpg "width=" "height=" 538 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqyssrmxqnaamjgajzfrm804.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 5.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqysxrekwaaage_qgkjra317.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:526px; "title=" 6.jpg "width=" "height=" 526 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" wkiom1cqyg_ Trc-laaobdjfzjka909.jpg "/>

14, this feature can be installed according to the needs of choice, generally select the Database engine services (replication and full-text search), client tool connection, management tool options. Of course, if you don't know what the requirements are, you can select them all. Functional directory can also be modified, it is recommended not to install the same disk with the system disk.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:515px; "title=" 7.jpg "width=" "height=" 515 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqysnspqweaak8rdn-nr4118.jpg "/>

15, the Network name needs you to fill in, this is the name of the database cluster, there are two instances of the default instance and named instance. A computer can have only one default instance and multiple named instances.

Note: I failed to install the image when I cut it. The cluster name of the following diagram becomes CLUSER2008R2, because I reinstall it, and the installation process is the same anyway. The cause of the error is explained later.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:530px; "title=" 8.jpg "width=" "height=" 530 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyhkqkpq9aamd1nx-bj0493.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:534px; "title=" 9.jpg "width=" "height=" 534 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyhsqeqtbaai1uy01nnu446.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:519px; "title=" 10.jpg "width=" "height=" 519 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqys6zg1a8aalwg947oiw071.jpg "/>

16, there is a need for an available cluster disk, meaning that in your win server cluster to have a piece of available storage, so far I have used a total of three disks, the win server cluster is using an arbitration disk, MS DTC a disk, now the database a disk, This disk is used to save the database data for the cluster, not to store the software.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:519px; "title=" 11.jpg "width=" "height=" 519 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyhfh9xnyaak1ppyw5ds513.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:519px; "title=" 12.jpg "width=" "height=" 519 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyhnj4hptaahx6zl17vc129.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:526px; "title=" 13.jpg "width=" "height=" 526 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyhrivgvnaajgo_xivqk586.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:526px; "title=" 14.jpg "width=" "height=" 526 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyhzwr0mnaaokhzxj0mg012.jpg "/>

16, the data stored in the cluster disk.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:519px; "title=" 15.1.jpg "width=" "height=" 519 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyh7gholraalczqtlnuy835.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:530px; "title=" 15.jpg "width=" "height=" 530 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyicjymxhaalpc7hqqzu718.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:526px; "title=" 16.jpg "width=" "height=" 526 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyihyommqaajylklg3zs885.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 17.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqytzsxs4caalt22jml7e453.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 18.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyiwig-r7aalu005eaeu356.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 19.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1cqyieafdqnaamhb-_36zs664.jpg "/>

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 20.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1cqyugqhc67aamp7a9hxka261.jpg "/>

17, after the database cluster installation is complete, we can go to the domain controller server to view, will find in the take and the application will have the SQL Server cluster name. We can see that both are online. This diagram database cluster name is not the same as the above, because I installed an error before, after reinstalling the database cluster, and then the name is not good.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:378px; "title=" 21.jpg "width=" "height=" 378 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1crkomtwurkaahjnu1mccw734.jpg "/>

Now start installing the cluster nodes. This installation is much simpler. Select Add node.

18, here I do not step by, just cut a few different places.

650) this.width=650; "src=" Http:// "title=" 222222.jpg "width=" height= "522" border= "0" hspace= "0" vspace= "0" style= "width:700px;height:522px;" alt= " Wkiol1crkzcrqbqiaaj2bwauduq771.jpg "/>

19, when the detection is over, he will appear this option, directly choose the next step is good.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 22.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1crkoqczlskaahldfqfk1q953.jpg "/>

20. A little attention is needed here, because the option to use the same account for all SQL Server services is grayed out, and you have to manually enter the password in both the SQL Server Agent and SQL Server password fields.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:526px; "title=" 23.1.jpg "width=" "height=" 526 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiol1crkaazkyfgaakymdwjypk593.jpg "/>

21, the previous picture only so there will be error message is because I did not enter the password in the direct click on the next step.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:522px; "title=" 23.jpg "width=" "height=" 522 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" Wkiom1crko3c71vaaaifs5sg4va128.jpg "/>

22, and then wait for the installation to complete. This completes the SQL cluster installation.

650) this.width=650; "src=" Http:// "style=" width : 700px;height:519px; "title=" 24.jpg "width=" "height=" 519 "border=" 0 "hspace=" 0 "vspace=" 0 "alt=" wkiom1crko_ Yaw8taajgrts5jlw686.jpg "/>

After loading we will verify that the application is migrated properly.

The first easy way to do this is to migrate the app to a different node. When you can build a simple website to test whether failover is possible.

650) this.width=650; "src=" Http:// "title=" authentication. jpg "alt=" Wkiol1crodbqmfx8aaksi31ryii269.jpg "/>

Below are the errors and workarounds that I have seen during the installation process.

Error 1,

650) this.width=650; "src=" Http:// "title=" Qq20160416092735.jpg "alt=" Wkiol1crlbesgzfwaacni6mn1tc596.jpg "/>


Method 1.

Resolve the X86 issue with the "options"-"Processor type" option in the SQL SERVER installation Center. My system is 64 bits.

Method 2.

You cannot invoke invoke or BeginInvoke on a control until the window handle is created.

The reason is that the VC 2010 of a service program Mscorsvw.exe process invoke invoke caused by the end of this process, can be.

Method 3.

Method 4.

After the error occurs, locate the registry "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager" and place it under the " PendingFileRenameOperations "value is deleted.

Then run the installation again.

Error 2,

An error occurred while setting the private property "RequireKerberos" of the resource "SQL Network Name (SQLCluster)" to the value "1"

This error occurs because the SQL Server 2008 installation package does not have an integrated SP1 patch that is causing the installation to fail. The network has a solution like this:

Anyway, I haven't understood how to solve it for half a day. Finally I replaced the installation package and installed Serl server R2. Then solve the problem.

Error 3,

You may be prompted to not have available storage when installing MS DTC or other clusters, but in fact you see available storage in the cluster because your disk does not have a drive letter assigned to the cluster disk.

650) this.width=650; "src=" Http:// "title=" No storage available. jpg "alt=" wkiom1crl03jsr4eaaef0zpiple069.jpg "/>

Another is if your system is installed with the WIN server R2 database installed after 08, then you need to hit the system SP1 patch.

In addition, there are some other problems, relatively better to solve.

This article is from the "very strong ant" blog, make sure to keep this source

Windows 2008 Clustering with SQL Server 2008 cluster installation Configuration

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.