NAS support for 2008 failover clustering

Question

I'm trying to build a SQL cluster with:
2 x DL380 g4s
MSA 500

When I try to create a failover Cluster it doesn't recognise my (NAS) MSA 500 as a clusterable resourse. I read a blurb about server 2008 not supporting NAS. Is this true?

Answer 1

Hi,

SQL Server only provides support for network-based files that use trace flag 1807 for non-failover clustered installations of SQL Server.
Failover clustered installations of SQL Server do not work with network-based files because SQL Server Server require that storage devices be recognized and registered by the Microsoft Cluster Service (MSCS) Cluster Administrator. 

So I think what you reckon is right.

---

Thanks, Leks

Answer 2

Does your NAS support ISCSI?  If so you should be able to configure an ISCSI target as a cluster resource.  If it doesn't support ISCSI you can get ISCSI target software to use a server to act as an ISCSI interface to your nas.... There's a product called starwind that will do this...  I think Microsoft also has a storage server that can do this, but I'm not really sure.   I've never used or wanted to use either...

Answer 3

What Lekss mentioned is correct. Here is the support policy reference: http://support.microsoft.com/?kbid=304261

---

This posting is provided "AS IS" with no warranties, and confers no rights. My Blog: Troubleshooting SQL

Answer 4

Thanks for the help. Looks like I'll be needing a hardware upgrade to go Server 2008 clustering.