iSCSI on a SQL Cluster

Firstly I would like to point out that iSCSI is not the best option for any SQL Cluster however sometimes we have to work with what we have got. If you ever need to reconfigure your iSCSI storage settings the place to go is the iSCSI initiator.

One thing I learned recently is to do with the favorite targets tab. When you go to add a new target, even if you completely remove the old target if it is listed under favorite targets it will try to reconnect when you restart the machine. This can be confusing as even though you may have thought you removed a target – connections will keep showing up trying to connect to it.

Here is a shot of the favorites tab.


The good thing is you can’t go to far wrong with the iSCSI initiator, even if you completely remove everything and re-add the target things should be ok. To refresh your volumes and devices you should also go to that tab and select autoconfigure (after changing favorites to refresh them).

PS make sure you remove all resources from the node you are working on before doing this…

Make sure you select the multipath option if you are using MPIO.

Good luck!

Rob StGeorge
Senior SQL Server Database Administrator residing in Auckland, NZ

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.