How To Fix the Network Binding Warning When Installing SQL Cluster Member

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:

  1. Open a command window as Administrator, and run “wmic nicconfig get description, SettingID > C:\nicconfig.txt
  2. Open the Registry editor, and goto HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Linkage\
  3. 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.
  4. Re-Run the SQL cluster installation, and you’ll see that the network binding validation passes!

This entry was posted in Microsoft SQL and tagged , , , . Bookmark the permalink.

Comments are closed.