This is a quick note on how to resolve a weird error with Microsoft SQL 2008R2 cluster member installation. It kept complaining that my network binding order was wrong. I had already gone to the advanced network settings, and placed my domain connected NIC at the top of the list, but it still kept complaining. I finally resolved the issue by going through the following link: http://blogs.msdn.com/b/sqlserverfaq/archive/2009/10/08/receive-a-warning-about-the-network-binding-order-on-the-setup-support-rules-page-when-install-sql-server-2008-in-a-failover-cluster.aspx
I’ll go ahead and simply document what I did:
- Open a command window as Administrator, and run “wmic nicconfig get description, SettingID > C:\nicconfig.txt“
- Open the Registry editor, and goto HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Linkage\
- Compare the adapter ID’s. In my case, the Failover Cluster Adapter was listed first, so I simply moved it underneath my domain connected adapter.
- Re-Run the SQL cluster installation, and you’ll see that the network binding validation passes!