• Super article Perry. Thanks for putting time and capture each stuff. I will add it to my briefcase for future reference.

    I had done three cluster installation in last 15 days and had found two issue on all of them.

    1. Cannot Add a second node to an SQL Server 2008 Failover Cluster. Reason SQL Agent is not shown in the resource group. I had to add it manually using

    Cluster restype "SQL Server Agent" /create /DLL:sqagtres.dll

    and change configuration state in this registry key from 2 to 1

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft Microsoft SQL Server\MSSQL10.MSSQLSERVER\ConfigurationState

    2. Even after node 2 is installed I could not add it to cluster in Cluster administrator as services starts and then goes offline. This article from Microsoft had been a great help.

    http://support.microsoft.com/kb/896861

    SQL DBA.