SQL Cluster failover cause : Network provider order for BoostFS is reverting after reboot and Solution below

 

This is Faisal Alvi from Microsoft SQL Engine team and I have been told that there is a question about binding order.  SQL has no specific recommendations on network binding order but since traffic to AD domain network is important so if you are getting warning then it is prudent to address it.  As provided by Windows Clustering team already that this warning simply checks that the network adapter configured to access the AD domain network is at the top of the network binding order. If it isn't, performance and availability problems might occurs as the network stack will try to access the AD domain for authentication. Customer needs to check with the vendor why BoosFS is coming at the top after reboot.

+Caution: The network binding rule when installing SQL Server failover clustered instances serves to verify that the network adapter configured to access the Active Directory domain network is at the top of the network binding order. If it isn’t, performance and availability problems might occur as the network stack will try to access the Active Directory domain for authentication. If, for example, the internal/private cluster communication network is at the top of the network binding order, the applications accessing Active Directory can time out because there is no path on the network to go thru Active Directory thru this network adapter.  By default, network binding order is configured in the sequence of how the network adapters were installed and added to the server.

https://docs.microsoft.com/en-us/troubleshoot/sql/install/warning-about-network-binding

Please let me know if there are any further queries.

Comments

Post a Comment

Popular posts from this blog

NetSH collection commands

  create below content on one notepad file file name start-auth.txt set KerbDebugFlags=0x7ffffff set KdcDebugFlags=0x23083 set KpsDebugFlags=0xff set NtlmDebugFlags=0x15003 set NegoExtsDebugFlags=0xFFFF set Pku2uDebugFlags=0xFFFF set SslDebugFlags=0x0000FDFF set DigestDebugFlags=0x000003FF set CredsspDebugFlags=0x0000FFFF set DpapiSrvDebugFlags=0xFF set WebAuthDebugFlags=0xFFFF set IdstoreDebugFlags=0x2FF set IdcommonDebugFlags=0x2FF set LivesspDebugFlags=0x3FF set WlidsvcDebugFlags=0x7 set IdlistenDebugFlags=0x7FFFFFFF set BaseCspDebugFlags=0xFFFFFFFF set VaultDebugFlags=0xFFF set BcryptDebugFlags=0xFFFFFFFF set NcryptDebugFlags=0xFFFFFFFF set CryptspDebugFlags=0xFFFFFFFF set WinHttpDebugFlags=0x7FFFFF set WininetDebugFlags=0x7FFFFF set CloudAPFlags=0xfff set HttpSysDebugFlags=0xFFFFFFFF mkdir .\logs del /f /q .\logs\*.* logman.exe start LsaTrace -p {D0B639E0-E650-4D1D-8F39-1580ADE72784} 0x40141F -o .\logs\LsaTrace__%computername%.etl -ets logman.exe start LsaAudit -p {DAA76F6A...
Read more

Script for Host entry in remote servers

#Host entry script by Suresh ## Input the server list in below path $servers= Get-Content "C:\Users\u-07-adm-ad-08\Desktop\Servers.txt" foreach ($server in $servers) {      $adminpath = Test-Path " \\$Server\admin$ "     If ($adminpath -eq "True")         {          $hostfile = " \\$Server\c$\Windows\System32\drivers\etc\hosts "          Write-Host –NoNewLine "Updating $Server..."          #Add host entries below that need to be added on remote servers          "104.108.176.95  www.identityiq.philips.com " | Out-File $hostfile -encoding ASCII -append          "23.38.37.249  www.egrc.philips.com " | Out-File $hostfile -encoding ASCII -append          Write-Host "Done!"...
Read more