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_MACHINESYSTEMCurrentControlSetservicesTcpipLinkage 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::HKLMSYSTEMCurrentControlSetServicesTcpipLinkagebind*
After the NIC binding order change the SQL setup marked all as passed.
Samples :
Get-Item -Path Registry::HKLMSYSTEMCurrentControlSetServicesTcpipLinkagebind* | 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
