1/24/09

Windows 2008 and SQL 2008 in Cluster.

Hi everyone

This lab runs very well.

But, I would like to share some problems to set up this lab:

a) You need .NET Framework 3.5 SP1. If SQL Wizar doesnt launch the setup, you cand installed from the SQL DVD. DVD:\x64\Redist\DotNetFrameworks\dotNetFx35setup
b) Same for Windows Installer 4.5. DVD:\x64\Redist\Windows Installer\x64\Instmsi45
c) You need install Powershell as well from Features console.
d) I got a IP duplicate error. Teredo Tunneling Pseudo-Interface got the guilty.
Verifying that there are no duplicate IP addresses between any pair of nodes.Found duplicate IP address . . . . .

Links that I followed to solve the problem.
http://sqlblogcasts.com/blogs/justinl/archive/2008/08/20/windows-2008-cluster-validation-failure.aspx
http://www.networkworld.com/community/node/29037
http://thesource.ofallevil.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.clustering&tid=2b62061f-c050-4a82-be30-9677de59a2bc&cat=en_us_947fd056-7098-4a44-a742-6c6224603cb1&lang=en&cr=us&sloc=&p=1




set devmgr_Show_Nonpersistent_Devices=1

devmgmt.msc

ncpa.cpl

I switched off the teredo Tunneling ghosted NIC.
I uninstalled the teredo tunneling ghosted NIC.
Device manager NICs and ncpa console must show the same devices.


d) I got a warning about binding NICs.

NOTE: You need to push Alt+N in English or Alt+A to show the advanced menu.
You need to enter in the advanced features and change the binding order.





After these problems, the installation was right.


PS: The Windows 2008 cluster was with a witness share resource and the sQL saves in a iSCSI Equallogic Dell SAN.
sAnTos