Wednesday, April 21, 2010

Some tips about SQL 2008 setup errors - NetworkBindingorder Rebootrequiredcheck Firewall Warning

Error 1:

Rule "Windows Firewall" generated a warning.

The Windows Firewall is enabled. Make sure the appropriate ports are open to enable remote access. See the rules documentation at http://go.microsoft.com/fwlink/?LinkId=94001 for information about ports to open for each feature.

Solution:
Firewall might be turned ON or SQL Server ports are not enabled in Firewall.

To disable firewall, run the VB script with contents:

Set objFirewall = CreateObject("HNetCfg.FwMgr")
Set objPolicy = objFirewall.LocalPolicy.CurrentProfile
WScript.Echo "The property HNetCfg.FwMgr.LocalPolicy.CurrentProfile.FirewallEnabled = " & objPolicy.FirewallEnabled

To allow ports used by SQL Server, refer http://technet.microsoft.com/en-us/library/cc646023.aspx

Error 2:
Network binding order

You might get Network Binding order warning. This rule is enumerating the Multi string key HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Linkage\Bind to locate the first adapter listed.
The associated domain name for this adapter is determined from HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\DNSRegisteredAdapters\
{ADAPTER_GUID}\PrimaryDomainName
If this matches the value of the current users "HKCU\Volatile Environment\USERDNSDOMAIN", the rule is considered successful.

Error 3:
Reboot Computer: "Reboot required check" fails
There are many suggesstions over internet to delete "Pendingfilerenameoperations" but I would suggesst don't do that since they are the files which need to be replaced upon reboot. But uou can skip the RebootRequiredCheck rule by using the /SkipRules parameter in the command prompt while launching SQL 2008 setup.
For example, type the following command.

Setup.exe /SkipRules=RebootRequiredCheck /Action=Install

Reply back with your comments if you still have issues.