Network bind order warning during SQL Server installation at failover cluster

Network bind order warning during SQL Server installation at failover cluster

  • Comments 3
  • Likes

 

Installing SQL Server 2008, 2008R2 and 2012 on failover cluster has been significantly changed from SQL Server 2000 and 2005.
Installation is performed separately on each node in order to avoid failures and downtime and much more.

One of improvements is more "in-depth" pre-installation checks.
One of the commonly ignored checks is “Network binding order”.

Network bind order warning


It has been skipped for two reasons. First reason, it’s only warning. The second and more significant reason is because sometimes it is hard to fix it.


The straightforward way to handle this kind of error is to change the network order in network connections.
Follow the KB.

If the following KB won’t solve the issue, we can manually edit “HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Linkage\Bind” based on the result of “wmic nicconfig get description, SettingID” command output and network connections control.
Remember that registry editing can be dangerous and prone to costly mistakes, so please backup your server's registry prior to the manual editing.

We can also use nvspbind utility instead.
It helps us query and modify the NIC and protocol order / usage.


No matter which way you chose to address this issue, the most important thing is not to skip installation warnings unless you are 100% sure you’ll fix it later before the server goes to production.

Comments
  • Nice little utility, and love the last sentence! I know when I roll through an installation pre-check I try to turn all the reds and yellows to green, that way I don't lose sleep later!

  • Way too complicated, here is the easier way: 1.in Network Connections Press the ALT key, click Advanced, and then click Advanced Settings. 3.Under Adapters and Bindings tab -> under Connections, click the connection you want SQL to use and move it up to the top of the list. 4.Under Bindings for , select the protocol that you want SQL to use and move it up to the top.

  • For me, the Microsoft Failover Cluster Virtual adapter was listed first in the registry and not visible in the settings panel. I found this post which may help fix without registry entires: https://blogs.technet.com/b/askcore/archive/2010/04/15/windows-server-2008-failover-clusters-networking-part-4.aspx

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment