geek stories and photography misadventures
SQL 2005 Cluster
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.
| Print article | This entry was posted by Joel on May 28, 2008 at 5:48 am, and is filed under Technology rocks!. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |