May 27, 2008 at 9:15 am
Hi Guys,
Bit of a random question, I want to setup SQL Server 2005 on single node cluster...just for dev/test so I can test a new encryption product in a cluster environment. No need for failover or HA and I don't need any comments of "why bother" or a "single node cluster is like trying to clap one handed!" I have heard these already. Also I apologise for the "Windows/Cluster" nature of my question, I am a SQL guy trying to get this running, may not be the most appropriate place to post but thought it was worth a try as I use this site regularly and always get excellent responses.
The problem I have is I need to configure it on a server with only internal storage. It has a single physical RAID 5 array with 3 logical Partitions. C:\, D:\ E
The cluster creates ok and the Quorum is placed on a local quorum on the c:\ along with the Windows installation.
I plan on installing SQL and the encryption software on the d:\ and place the data files on the e:\ drive.
Now I am unable to add the local disk array or the logical partitions as a as a physical drive in cluster administrator. So the SQL Server installation cannot see the partitions... Does anyone have anything in terms of documentation that may point me in the right direction? Or if you know that is definitely not possible, and I’ll never achieve it then please put me out of my misery
Gethyn Elliswww.gethynellis.com
May 27, 2008 at 10:27 am
I think you need two nodes to add those things. The other node could be a virtual server, which is what I'd recommend. Or rather, two virtual servers that are clustered. That way you can move them to another machine for testing if needed.
August 22, 2008 at 7:54 pm
Make make local disk available in the cluster manager, you need emulate a directory on you local hard disk as a SAN. an inexpensive way is use iSCSI.
To "present a directory as a SAN": use iSCSI Target software, such as StarWind or Sanme
To "consume SAN": use iSCSI Initiator -- free from Microsoft.
Do not use free MySAN, it does not suppor cluster as people already tested.
Good luck.
October 2, 2008 at 3:26 pm
I have done this very thing. I did it with VMWARE ESX Server trial software. VMWare now offers a free version of esx that might work for you permanently called: ESXi.
Best of luck and yes doing it all with local storage is possible.
Thanks,
Ted
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply