SQL 2008 Cluster Resource Cannot come online - HELP!

  • I am installing a SQL Server 2008 instance on Windows 2008 Cluster x64 bit. It got all the way to the end of installation and then error:

    Cluster resource 'SQL Server' could not be brought online...the resource failed to come online.

    PLEASE HELP!!!

    Description:

    SQL Server 2008 R2 Setup has encountered an error.

    Problem signature:

    Problem Event Name: SQL100Exception

    Problem Signature 01: SQL Server 2008 R2@RTM@

    Problem Signature 02: 0xC9090D30

    Problem Signature 03: 0xF2CBEAFB

    Problem Signature 04: 0x1C2074D8@1216@1

    Problem Signature 05: 0xD91D4D44

    Problem Signature 06: SqlEngineConfigAction_install_startup

    Problem Signature 07: 0x26DE8310

    Problem Signature 08: Unknown

    Problem Signature 09: Unknown

    Problem Signature 10: Unknown

    OS Version: 6.1.7600.2.0.0.274.10

    Locale ID: 1033

    Additional information about the problem:

    LCID: 1033

  • again more info please, can you post the setup log

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Is there anything useful in the SQL error log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • An educuated guess is that a dependant resource is not configured properly.

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • Just wanted to follow-up to follow-uppers....thanks for your replies. 3rd times a charm after 2 rebuilds. Not sure if it made the difference, but I instructed the sysadmins to make sure the network binding order was correct. Cluster validation passed all the way, and sql went thru (FINALLY!!)

    Wasn't sure about the instance name vs. instance id - got confused on that.... Thx again

    Oh, I thought I was at the Star Wars convention, but glad to see fellow sql guys online 🙂 ...May the force be with you!!!

  • I'm having the same issue and that is -

    Detailed results:

    Feature: Database Engine Services

    Status: Failed: see logs for details

    MSI status: Passed

    Configuration status: Failed: see details below

    Configuration error code: 0x1C2074D8@1216@1

    Configuration error description: The cluster resource 'SQL Server' could not be brought online. Error: The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)

    Configuration log: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20101215_104053\Detail.txt

    I ALSO RECEIVED THE NETWORK BINDING ORDER WARNING...BUT CONTINED WITH THE INSTALL. MY WINDOWS ADMIN PERFORMED THE STEPS IN THIS KB (http://support.microsoft.com/kb/955963)

    HOWEVER, IT DIDN'T SEEM TO HELP.

    ANY IDEAS??

    Thanks!

    KU

  • the network binding error is common on Windows 2008. You need to go into the registry and find the key as follows

    HKEY LOCAL MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Linkage

    Check the values for the Bind entry. Compare these against the real adapters in

    HKEY LOCAL MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Parameters\Interfaces

    For the Bind entry you should find you just need to bump the top entry down to the bottom and that should be fine!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply