Microsoft KB Archive/923398

= How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Longhorn Server-based computer =

Article ID: 923398

Article Last Modified on 11/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems

-



INTRODUCTION
This article describes how to configure an IPv6 resource for a Microsoft SQL Server 2005 cluster on a Microsoft Windows Longhorn Server-based computer.

Note You must install SQL Server 2005 Service Pack 2 (SP2) to support the IPv6 resource in a Windows Longhorn Server-based cluster.



MORE INFORMATION
When you install SQL Server 2005 on a Windows Longhorn Server-based cluster environment, you can only assign IP address resources in IPv4 format. However, after you install SQL Server 2005 Service Pack 2, you can manually configure an IPv6 resource for the clustered instance of SQL Server.

To configure an IPv6 resource for a clustered instance of SQL Server 2005, follow these steps:
 * 1) Open Cluster Administrator, and then connect to the cluster that you want to configure.
 * 2) In the Actions pane, click Add a resource, point to More resources, and then click Add IPv6 Address.
 * 3) In the right pane, right-click IP Address:  in the Other Resources list, and then click Properties.
 * 4) In the Properties dialog box, click the Network list, and then click the IPv6 address that you want to use.
 * 5) Click the Dependencies tab, and then click Click here to add a dependency.
 * 6) Click the list in the Resource column, and then click the resource that the cluster service must bring online before the IPv6 resource can be brought online. For example, this resource may be the disk resource.
 * 7) Click OK.
 * 8) In the Other Resources list, right-click the IPv6 resource, and then click Bring this resource online.

For more information about IPv6 addresses, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/library/bb878102.aspx

There are three conventional ways to represent IPv6 addresses as text strings:  The preferred form is x:x:x:x:x:x:x:x, where each &quot;x&quot; is a hexadecimal value for one of the eight 16-bit pieces of the address. The following addresses are some examples:  FEDC:BA98:7654:3210:FEDC:BA98:7654:3210 1080:0:0:0:8:800:200C:417A

Note You do not have to write the leading zeros in an individual field. Because of some ways that certain styles of IPv6 addresses are allocated, addresses frequently contain long strings of zero bits. To make writing addresses that contain zero bits easier, you can use a special syntax to compress the zeros. Two colons indicate multiple groups of 16 bits of zeros. The two colons can only appear one time in an address. The two colons can also be used to compress the leading or trailing zeros in an address. The following addresses are some examples:  A unicast address

1080:0:0:0:8:800:200C:417A A multicast address

FF01:0:0:0:0:0:0:101</li> The loopback address

0:0:0:0:0:0:0:1</li> The unspecified addresses

0:0:0:0:0:0:0:0</li></ul>

can be represented as:  A unicast address

1080::8:800:200C:417A</li> A multicast address

FF01::101</li> The loopback address


 * 1</li>

The unspecified addresses


 * </li></ul>

</li> An alternative form is sometimes more convenient when you deal with a mixed environment of IPv4 nodes and IPv6 nodes. The form is x:x:x:x:x:x:d.d.d.d, where each &quot;x&quot; is a hexadecimal value for the six high-order 16-bit pieces of the address. Each &quot;d&quot; is a decimal value for the four low-order 8-bit pieces of the address that is the standard IPv4 representation. The following addresses are some examples:  0:0:0:0:0:0:13.1.68.3

Note This address can also be compressed as follows by using the two-colon method:


 * 13.1.68.3</li>

0:0:0:0:0:FFFF:129.144.52.38

Note This address can also be compressed as follows by using the two-colon method:


 * FFFF:129.144.52.38</li></ul>

</li></ul>

Keywords: kbhowto kbinfo kbexpertiseadvanced kbsql2005setup KB923398

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.