question

Marcus-9726 avatar image
0 Votes"
Marcus-9726 asked CandyLuo-MSFT commented

Network Binding Order Warning SQL Server 2012 on Windows Server 2008 SP2

I'm installing a SQL Server 2012 cluster on two node Windows Server 2008 SP2 with single network adapter and single subnet only. I can see there's warning about "Network Binding Order" and I did follow some articles on the internet to change the binding. However, from the Manage Network Connections there under Advanced Settings I can only see one network adapter there where I'm unable to change the order. As follow:

84387-image.png



May I know is there any impact on this if I don't do anything to resolve the warning? Or is there anyway for me to resolve this warning as the article below seems not able to resolve my issue since I got only 1 network adapter on each nodes.

https://docs.microsoft.com/en-us/troubleshoot/sql/install/warning-about-network-binding

Thank you.

sql-server-generalwindows-server
image.png (154.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CandyLuo-MSFT avatar image
0 Votes"
CandyLuo-MSFT answered CandyLuo-MSFT commented

Hi ,

If you have only one network adapter in Advanced Settings and you still see the warning about Network Binding Order. This may occur when you have a ghosted network adapter on the computer or the Microsoft Failover Cluster Virtual Adapter is bound before the domain network. These adapters are not show in the GUI, but can be found in the registry and other places like the ipconfig /all command.

The following article talking about how to fix Annoying Network Binding Order Error, you could have a look:

SQL SERVER – Fixing Annoying Network Binding Order Error

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

Best Regards,
Candy


If the Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Candy,

May I know on which particular registry path store the ghosted network adapter settings? Is it this one?

HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Linkage\Bind

0 Votes 0 ·

Yes, just make sure the GUID of your network NIC is at the top of the list.

Note: Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs.

0 Votes 0 ·

Hi Candy,

I'll check on this and update you the results.

Thank you

0 Votes 0 ·
Show more comments