SQL Server 2008 r2 failed on Windows Server 2012

Hi All

I have a Windows 2012 Server and i want to install cluster SQL 2008 R2

I validate my configration without any error and i create my cluster windows without any problem,

I create also DTC role and every thing is running and online but,

when i want to install sql server failover cluster that message appear

  •  Cluster Service verification Failed
  • Cluster shared disk available check failed

I try to install sql with command line but the same problem.

December 16th, 2012 5:11pm

Hi,

Whats the detailed Version of your SQL 2008 R2? 32 bit SQL Server 2008 R2 cant be installed on X 64 OS.

How you configured shared storage for the cluster?

When planning to consolidate multiple stand-alone servers to SQL Server failover cluster instances, we recommend, as part of the planning process, that you verify that the cluster node hardware configuration is sufficient to support the number of instances of SQL Server to be hosted.

Refer to following articles to make sure your hardware is available for a SQL cluster. Also check event log to find related error logs and post it for further troubleshooting.

Installing a SQL Server 2008 R2 Failover Cluster
http://technet.microsoft.com/en-us/library/ms179410(v=sql.105).aspx
Before Installing Failover Clustering (SQL Server 2008 R2)
http://technet.microsoft.com/en-us/library/ms189910(v=sql.105).aspx

For more information please refer to following MS articles:

Before Installing Failover Clustering (SQL Server 2012)
http://msdn.microsoft.com/en-us/library/ms189910.aspx
Create a New SQL Server Failover Cluster (Setup)(SQL Server 2012)
http://technet.microsoft.com/en-us/library/ms179530(v=sql.110).aspx

Free Windows Admin Tool Kit Click here and download it now
December 17th, 2012 7:54am

thanks for your answer,

I Fix this issues but i have another problem  in final phase of istallation SQL Node 1

Windows Server 2003 FILESTREAM Hotfix Check      failed

I download that hotfix and when I want to install that message appear

 no enough storage is available to procces this command

December 17th, 2012 8:25pm

Hi,

How you fixed the cluster installation issue? Please post your solution, which may very useful for other community members facing similar problems.

> Windows Server 2003 FILESTREAM Hotfix Check      failed

What did you mean Windows Server 2003? Didnt you install SQL server 2008 on a Windows Server 2012 OS?

Where did you download the hotfix, which MS KB? Is that hotfix apply to Windows Server 2012?

Free Windows Admin Tool Kit Click here and download it now
December 18th, 2012 6:39am

Hi,

Massages and their Solutions 

  •  Cluster Service verification Failed :

                  -  Install tha feature type in power shell that command add-windowsfeature RSAT-Clustering-AutomationServer

  • Cluster shared disk available check failed

                 -   I add a new disk and make it disk available without add to shared disk

For Windows Server 2003 FILESTREAM Hotfix Check      failed  I don't have a solution

Yes I want to install SQL 2008 R2 in Windows 2012 server

but the preview error message appear

you see that :/

December 18th, 2012 8:25pm

Hi

did you find any solution to fix the Windows Server 2003 FILESTREAM Hotfix Check      error?

I am also facing the same issue.

anyone to help?

Free Windows Admin Tool Kit Click here and download it now
January 5th, 2013 10:20am

Hello TriGax and John,<o:p></o:p>

SQL 2008 R2 SP1 fixes the issue. <o:p></o:p>

Best solution is to slipstream SP1 into SQL server 2008 R2. Following link provides a
simplest way to slipstream SP1.<o:p></o:p>

http://blogs.msdn.com/b/petersad/archive/2011/07/13/how-to-slipstream-sql-server-2008-r2-and-a-sql-server-2008-r2-service-pack-1-sp1.aspx<o:p></o:p>

Hope this will help you to proceed with your installation.<o:p></o:p>


January 7th, 2013 5:51am

Refer to Videos Installing a SQL Server 2008 R2 Failover Cluster

- http://www.mediafire.com/?dg615npogz7x45z

- http://www.mediafire.com/?6n6etb541tisw40

- http://www.mediafire.com/?qnoda4v5ll2i2bs

- http://www.mediafire.com/?ea5ne52054j3dyr

- http://www.mediafire.com/?6eggg7qrotgip2c

- http://www.mediafire.com/?45gnw6izon4y0c9

- http://www.mediafire.com/?rd2y8suzju4t323

- http://www.mediafire.com/?nc90m8wjb6xnw4m

- http://www.mediafire.com/?eg2dusb52pd5na2

- http://www.mediafire.com/?tixdf4qdu7k4dn5

pass:1111aaaa!

Free Windows Admin Tool Kit Click here and download it now
April 1st, 2013 2:03am

Thanks bro, you saved me!!!
May 27th, 2013 4:58pm

Hi

Ive had similar issues installing SQL 2008 R2 on Windows Server 2012 two node cluster.

First issue that prevented me from advancing in setup was:

Rule "Microsoft Cluster Service (MSCS) cluster verification errors" failed. Since I knew my WCS was OK, I used a quickie: /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster as detailed here:

http://social.technet.microsoft.com/Forums/windowsserver/en-US/9cb1308d-edd0-44e5-a10e-dfb9f10a1ef3/sql-server-2008-r2-failed-on-windows-server-2012

The I ran into another verification rule problem - Windows Server 2003 FILESTREAM Hotfix Check      failed.

Steps I took to resolve and install successfully:

  1. Copy SQL 2008 R2 installation DVD to (for example) B:\SOURCE\SQL2008R2
  2. Download and extract Service Pack 1 for SQL 2008 R2 (for example B:\SP1)
  3. Run setup with parameters:

B:\SOURCE\SQL2008R2>setup.exe /CUSource=B: \SP1 /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster

Free Windows Admin Tool Kit Click here and download it now
August 5th, 2013 10:05am

Follow the below steps:

Copy  C:\Windows\Cluster\Clusres.dll TO C:\Windows\system32 and rename the file to W03a2409.dll

This might resolve the issue.

  • Proposed as answer by MVP Friday, August 22, 2014 11:32 AM
February 19th, 2014 12:57am

Follow the below steps:

Copy  C:\Windows\Cluster\Clusres.dll TO C:\Windows\system32 and rename the file to W03a2409.dll

This might resolve the issue.

This literally saved my life! I have had so many issues with installing SQL Server 2008 R2 on WS 2012. It just seems like an endless pit of errors. But It's just for testing. Thanks for your help!
Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2014 10:18am

Copy  C:\Windows\Cluster\Clusres.dll TO C:\Windows\system32 and rename the file to W03a2409.dll

resolved the issue.

December 19th, 2014 9:25am

Follow the below steps:

Copy  C:\Windows\Cluster\Clusres.dll TO C:\Windows\system32 and rename the file to W03a2409.dll

This might resolve the issue.

Thanks!!!!!!!!!!!!!!!!!
Free Windows Admin Tool Kit Click here and download it now
January 29th, 2015 7:31pm

NICE JOB!!!
May 15th, 2015 4:38pm

This has solved the hotfix check error. 

Thanks

Free Windows Admin Tool Kit Click here and download it now
June 19th, 2015 5:06pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics