During the SQL 2012 Setup there is a warning that my binding order is not correct. It looks ok but it is not. there are a couple of KB items on technet. this is on Windows 8 server
Why this is appearing did I make a mistake ? lets see mm my lan nic is on top. this looks ok so why this error. lets look at the SQL log
Ok here it is the SQL setup log file is it wrong ? local area connection* 11 is on top ? what is this ? lets lookit up .
NetworkBindingFacet: Looking up network binding order.
(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘Local Area Connection* 11’ Device: ‘\Device\{2E9E3899-BB35-4E91-98D4-BF56F4ADE4F6}’ Domain: ” Adapter Id: ‘{2E9E3899-BB35-4E91-98D4-BF56F4ADE4F6}’
(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘LAN’ Device: ‘\Device\{734667C2-FCC9-4874-B3E0-EDC3BA72F6AB}’ Domain: ‘mvp.local’ Adapter Id: ‘{734667C2-FCC9-4874-B3E0-EDC3BA72F6AB}’
(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘ISCSI’ Device: ‘\Device\{1F016AE2-DD00-4B0F-B80B-57173AF2F36E}’ Domain: ” Adapter Id: ‘{1F016AE2-DD00-4B0F-B80B-57173AF2F36E}’
(05) 2012-03-18 14:03:04 Slp: NetworkBindingFacet: Network: ‘Cluster’ Device: ‘\Device\{BA1F99C0-0D58-44AA-85E0-ADFB1EF2C422}’ Domain: ” Adapter Id: ‘{BA1F99C0-0D58-44AA-85E0-ADFB1EF2C422}’
I know what it is it is the hidden cluster adapter which needed to be moved in the binding order, and that had to be done in the registry.
I opened up regedit and drilled down to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Linkage and opened up the Bind value:
\Device\{2E9E3899-BB35-4E91-98D4-BF56F4ADE4F6}
\Device\{734667C2-FCC9-4874-B3E0-EDC3BA72F6AB}
Flip the registry keys and you are ready to go.
This is hard to find eh yes but you can use powershell
wmic nicconfig get Description,SettingID
More info about this is on MSDN
http://msdn.microsoft.com/en-us/library/ms189910(v=sql.110).aspx
changing-the-network-binding-order-in-windows-server-2008
and it you want to change this by powershell the get-itemproperty is the way.
Get-ItemProperty Registry::HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Linkage\bind\*
After the NIC binding order change the SQL setup marked all as passed.
Samples :
Get-Item -Path Registry::HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Linkage\bind\* | Select-Object -ExpandProperty Property
Get-WmiObject -Class Win32_NetworkAdapterConfiguration -Filter "IPenabled = $true" | select Description, IPAddress, index, SettingID
gwmi Win32_NetworkAdapterConfiguration | where-object {$_.IPEnabled -eq "True"} | ft Description, SettingID -auto
Share this:
Robert Smit MVP Blog 
great…it worked
Hi there, just became aware of your blog through Google,
and found that it is really informative.
I’m going to watch out for brussels. I’ll appreciate if you continue this in future.
Many people will be benefited from your writing.
Cheers!
I do not write many remarks, but i did a few searching and
wound up here How to: Change the Network Binding order for SQL 2012 Windows Server 8 Failover Cluster (Setup)
| The Windows Server Cluster Failover Blog. And I do have 2 questions
for you if you do not mind. Is it just me or does it look like a few of the comments look as if they are written by brain dead
people? 😛 And, if you are writing at other sites, I’d like to keep up with anything fresh you have to post. Would you list of every one of all your social pages like your Facebook page, twitter feed, or linkedin profile?
thanks master