So last weekend I was working on my latest book, SQL Server 2008 Management and Administration and was finalizing the SQL Server 2008 chapter on Failover Clustering and ran into a few issues.
So, basically when installing SQL Server 2008 failover clustering on Windows Server 2008, you need to first run the Windows Server 2008 cluster verification tool in order to ensure that the cluster is configured correctly and all the components, drivers and hardware is supported. If this process fails, you cannot proceed and with an installation supported with Microsoft. So I was getting this erroneous error during the unique IP Address and subnet test, which was preventing me from moving forward. The error consisted of: Found duplicate IP Address fe80::100:7f:fffe%10 on node one Local Area Connection 9 and node two Local Area Connection 9.Apparently, this local area connection 9 was not your typical adapter and was associated with the Teredo Tunneling Pseudo-Interface. So this network connection has nothing to do with the public and heartbeat network adapters associated with building the cluster and were preventing me from proceeding forward with the installation.Anyhow, the workaround provided from Microsoft in order to address this issue was to disable the Teredo Tunneling Pseduo-Interface, Once I did that, the verification test passed and I was able to move forward and install Windows Server 2008 failover clustering and then configure my SQL Server 2008 Cluster.
The steps for disabling the Teredo Tunneling Pseduo-Interface are as follows: In Device Manager, show hidden devices, and disable the teredo driver (shows up as ‘6TO4 Adapter’ and rerun validation or from the command line or run’Netsh interface teredo set state disabled’
Cheers
~Ross Mistry
Author – SQL Server 2008 Management & Administration
