Joel Francisco

Yesterday morning, I went to Emirates Transport HQ in Deira near the Airport and configured their SQL 2005 Cluster. It was a piece of cake (considering that they could have done this themselves), thanks to Brad McGehee for his nice article and his tutorials. Other articles and useful SQL Server information can be found in www.sql-server-performance.com. Also thanks to Google for giving me the correct path to righteousness!

Here is the direct link of the article for the steps on
How to Cluster SQL Server 2005: http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx 

Be sure you know how to correctly establish a Windows Cluster! Here is the direct link of the article for the steps on
How to Cluster Windows Server 2003:
http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx

Note: When using cables to connect private network cards of the clusters (it happens when the network guys are lazy to connect it to the switch or it just doesn't have available ports), be sure to use straight network cables. I don't know the theory about it but ahmm…the cluster failover didnt work when we used a cross cable. Hope this helps.