SQL Server with Mr. Denny

Aug 1 2011   2:00PM GMT

SQL Server won’t start due to LUNs being unavailable

Denny Cherry Denny Cherry Profile: Denny Cherry

This question came up on ServerFault a while back and a wanted to expand on the solution more.  The basic problem that the person was having was that the iSCSI disks were taking a long time to come online which was causing the SQL Server to crash when the server was rebooted.

The solution that I came up with was to change the SQL Server service to make it depending on the disk drivers to ensure that the disk drivers were online before the SQL Server attempted to start.  Fortunately this is a pretty quick registry change which can fix the problem.

To fix this, open the registry editor (regedt32) and navigate to HKEY_Local_Machine\system\CurrentControlSet\Services\MSSQLSERVER\ and find the DependOnService key (if it isn’t there for some reason, create it just as shown with a type of REG_MULTI_SZ).  Edit the DependOnService key and set the value to “Disk”.  Click OK, close the registry editor and restart the server.

Once the key has been set the SQL Server will no longer start up until after the disk drivers have been started.

This will work for all version of SQL Server that are installed on a version of Windows which has the registry (so probably SQL Server 6.5 and up).

As this is a registry change, don’t be making this change on all your servers.  Only tweak the registry if you know what you are doing.  If you kill your system by editing the registry it’s your fault, not mine.  I don’t want to hear about it if you delete a bunch of keys by accident, on purpose, because you didn’t read this correctly, etc.

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: