Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am attempting to setup a couple of virtual machines in my lab for testing failover clustering on SQL Server 2008 and Windows Server 2008.

One of the hosts I have is not capable of running a 64 bit virtual machine, however the other host is. Sure enough, I installed the 64 bit machine (host A) first without realizing host B cannot run a 64 bit VM.

Can I run failover clustering with one node on x64 and another node on x86? Or do I have to re-install the OS on host A to be 32-bit?

share|improve this question

3 Answers 3

up vote 5 down vote accepted

Windows Server 2008 (no R2) did ship a 32-bit variant of the OS (last one MS shipped that way). So you can cluster it. You can install a 32-bit FCI on a 32-bit node. You cannot install a 32-bit FCI on a 64-bit node. So no, what you want is not possible. If you need a 32-bit FCI, install it on a 32-bit OS.

share|improve this answer
    
I marked your answer correct, but see my answer on how to use x64 and x86 in a single cluster. –  Max Vernon Nov 19 '13 at 18:12

It appears the answer is a resounding "NO" since Failover Clustering isn't available on Windows Server 2008 x86 at all.

Time to find another VT-capable machine.

http://technet.microsoft.com/en-us/library/cc771404.aspx#BKMK_Software_Requirements

share|improve this answer

I have successfully created a SQL Server 2012 Failover Cluster for test purposes using Windows Server 2008 (not R2!).

The environment consists of two physical servers running VMWare virtualization software. VM1 has Windows Server 2008 SP1 x64 with 3GB ram. VM2 has Windows Server 2008 SP1 x86 with 3GB ram. Shared storage is provided by a third physical server running Windows Storage Server 2008 using the Microsoft iSCSI Target. The iSCSI target software is configured to allow access to both VM1 and VM2. Three iSCSI Targets were created, QuorumDisk, MSDTCDisk, and SQLDataDisk.

All machines are member servers in Active Directory, named AD.

I created a security account for SQL Server, named AD\SQLCluster. AD\SQLCluster has been given the Read servicePrincipalName and Write servicePrincipalName. Both machine accounts, AD\VM1 and AD\VM2, have been given Kerberos Delegation rights through Active Directory Users and Computers. Since my DC is running Windows Server 2003 with SP2 I needed to use the ADSIEdit.exe tool to modify the servicePrincipalName rights for AD\SQLCreator, which is available in the Support Tools for Windows Server 2003.

AD\VM1 and AD\VM2 were connected through Microsoft iSCSI Initiator software to the storage server, and then configured into a Windows Server Failover Cluster using the Cluster Administrator. MSDTC was configured as a Failover Application on both AD/VM1 and AD/VM2 to provide clustered DTC services for SQL Server.

I installed SQL Server 2012 SP1 x86 onto AD\VM2, using the following setup command-line:

D:\> Setup /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster

This allows SQL Server setup to bypass the Windows Failover Cluster Verification. This results in a setup that is typically unsupported by Microsoft. In my case, this was necessary since VM1 is x64 and VM2 is x86, which is unsupported.

I installed SQL Server 2012 SP1 x64 onto AD\VM1 using the following setup command-line:

D:\> Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.