You receive a warning about the network binding order on the Setup Support Rules page when you install SQL Server 2008 in a failover cluster

Article translations Article translations
Article ID: 955963 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

When you install Microsoft SQL Server 2008 in a failover cluster, you receive a warning message about the network binding order on the Setup Support Rules page.

Note The following warning is displayed even though the binding order is correct:
IsDomainNetworkTopOfBindings
Checks to see if the computer domain server is on the network that is bound to the top of the network order.
The domain network is not the first bound network. This will cause domain operations to run slowly and can cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding order.

CAUSE

This issue may occur when you have a disabled network adapter or a ghosted network adapter on the computer.

Note A network adapter that is enumerated in the Windows registry but that is hidden in Device Manager is called a ghosted network adapter. This issue may occur when you change a network connection's TCP/IP configuration from DHCP to a static IP. This issue may also occur when you have added and removed network adapters multiple times.

RESOLUTION

To resolve this issue, remove disabled or ghosted network adapters. To do this, follow these steps:
  1. At a command prompt, type the following command lines:
    set devmgr_Show_Nonpresent_Devices=1
    start devmgmt.msc
    start ncpa.cpl
    Note Make sure that you press ENTER after each line.
  2. In Device Manager, expand Network adapters.
  3. Compare the list of network adapters in Device Manager to the list of network adapters that are displayed in Network Connections. Network adapters that are present in Device Manager but not in Network Connections are ghosted network adapters.
  4. If there are any disabled network adapters, enable these adapters in Device Manager or in Network Connections.
  5. If there are any ghosted network adapters, remove them in Device Manager.
  6. Start SQL Server setup.
  7. After setup is complete, open Network Connections, and then disable any network adapters that you do not want.

REFERENCES

For more information about how to install SQL Server 2008 in a failover cluster, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn.microsoft.com/en-us/library/ms179530.aspx
To get started with SQL Server 2008 failover clustering, visit the following Microsoft TechNet Web site:
http://technet.microsoft.com/en-us/library/ms189134.aspx

Properties

Article ID: 955963 - Last Review: May 8, 2009 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
Keywords: 
kberrorsandwarnings kbexpertiseadvanced kbprb kbtshoot kbadapters kbclustering KB955963

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com