June 17, 2010 at 7:34 am
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
June 19, 2010 at 8:19 am
again more info please, can you post the setup log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
June 19, 2010 at 12:20 pm
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
June 21, 2010 at 7:27 am
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/
June 21, 2010 at 2:54 pm
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!!!
December 15, 2010 at 11:50 am
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
December 15, 2010 at 12:09 pm
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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply