none
SQL Server 2008 r2 failed on Windows Server 2012

    Question

  • 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.

    Sunday, December 16, 2012 5:11 PM

Answers

All replies

  • Hi,

    What’s the detailed Version of your SQL 2008 R2? 32 bit SQL Server 2008 R2 can’t 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


    Lawrence

    TechNet Community Support

    Monday, December 17, 2012 7:54 AM
    Moderator
  • 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

    Monday, December 17, 2012 8:25 PM
  • 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? Didn’t 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?


    Lawrence

    TechNet Community Support

    Tuesday, December 18, 2012 6:39 AM
    Moderator
  • 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 :/

    Tuesday, December 18, 2012 8:25 PM
  • 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?

    Saturday, January 5, 2013 10:20 AM
  • 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>


    Monday, January 7, 2013 5:51 AM
  • 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!

    Monday, April 1, 2013 2:03 AM
  • Thanks bro, you saved me!!!
    Monday, May 27, 2013 4:58 PM
  • Hi

    I’ve 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


    LW


    • Proposed as answer by Gierasimov Monday, August 5, 2013 10:05 AM
    • Edited by Gierasimov Monday, August 5, 2013 10:34 AM
    Monday, August 5, 2013 10:05 AM
  • 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.

    Wednesday, February 19, 2014 12:57 AM
  • 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!
    • Proposed as answer by Pratik Sampat Wednesday, November 4, 2015 5:40 PM
    Tuesday, April 22, 2014 10:18 AM
  • Copy  C:\Windows\Cluster\Clusres.dll TO C:\Windows\system32 and rename the file to W03a2409.dll

    resolved the issue.

    Friday, December 19, 2014 9:25 AM
  • 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!!!!!!!!!!!!!!!!!
    Thursday, January 29, 2015 7:31 PM
  • NICE JOB!!!

    J. Cass Howorth Mobile Tech Support

    Friday, May 15, 2015 8:34 PM
  • This has solved the hotfix check error. 

    Thanks


    Thank you -Mushtaq

    Friday, June 19, 2015 9:02 PM
  • Worked like a charm.
    Wednesday, February 24, 2016 3:38 PM
  • Gracias, esto solucionó el error del Windows server 2003 filestream hotfix check, además hice el slipstream y ejecute el instalador con la siguiente linea de comandos:

    setup.exe /CUSource=E:\SQLServer2008_FullSP1\PCU /SkipRules=Cluster_VerifyForErrors /Action=InstallFailoverCluster

    Friday, December 16, 2016 3:37 PM