Saturday, February 12, 2011

SQL Cluster Install 'Network binding order' warning

When installing SQL Server 2008 on a cluster you may get a 'Network binding order' warning.

To identify why the setup is reporting this error:
  1. Open your ..\Setup Bootstrap\Log\..\Detail.txt file
  2. Navigate to the 'Network binding order' rule section
Below shows that 'Local Area Connection* 9' was top of the list, when it should have been 'public'

The problem is that sometimes you cannot see the device or cannot get the correct order despite using

So what can you do?
1. Run regedt32
2. Navigate to 'HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Linkage'
3. Right click on 'Bind' and select 'Modify'
4. Move the correct Device (identified in Detail.txt) to the top of the list and that is it.

No comments:

Post a Comment