I am losing access to LUNs clustered via win2k8 r2 when either SP reboots.
I have applied MR4 SP2 and whenever I reboot an SP the SQL server service goes offline and my disks go offline and do not failover to the other SP.
There is a single NIC in each cluster host and they are pathed to SPA and SPB. Powerpath and MPIO are not installed.
should I expect to lose access when an SP reboots?
Have you done registry changes to tolerate the disconnects during failover? I think it's mentioned in the document.
Excerpt from the doc:
Task 4: Set registry values
Incorrectly modifying the Registry can cause serious system-wide problems that can
require you to reinstall the system. Use the Windows Registry Editor at your own risk.
1.On the host, run the Windows Registry Editor (regedit.exe).
2.Go to HKEY_LOCAL_MACHINE\SYSTEM\.
3.Right-click CurrentControlSet, and search for the MaxRequestHoldTime key and modify its value from 60 to 600 (decimal) or from 3c to 258 (hexadecimal).
Verify that the path to the parameter is in the CurrentControlSet. If is it not, search for
the parameter again. If you make changes to ControlSets other than the top level
current set, those changes will not affect the system.