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

Marcus Wong Theen Nam 1,091 Reputation points
2021-04-05T07:45:54.583+00:00

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://learn.microsoft.com/en-us/troubleshoot/sql/install/warning-about-network-binding

Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,481 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,928 questions
0 comments No comments
{count} votes

Accepted answer
  1. Candy Luo 12,646 Reputation points Microsoft Vendor
    2021-04-06T03:04:31.437+00:00

    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.


0 additional answers

Sort by: Most helpful