SQL 2008r2 failover cluster installed. Install completed with failures. SQLserver service will not start

Question

Here is the startup info from application event log:

Faulting application name: sqlservr.exe, version: 2009.100.1600.1, time stamp: 0x4bb6b40b

Faulting module name: unknown, version: 0.0.0.0, time stamp: 0x00000000

Exception code: 0xc0000005

Fault offset: 0x0000000150000000

Faulting process id: 0x2c4

Faulting application start time: 0x01ccf62d5aec89ae

Faulting application path: C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQL2K8CLUSTER\MSSQL\Binn\sqlservr.exe

Faulting module path: unknown

Report Id: 98991492-6220-11e1-817a-00219b95563c

Tried to run a repair from the setup disk and received SQL Server Setup error:

"Object reference not set to an instance of an object.."

Answer 1

Hi Cougar1492,

Regarding to your description and error message, which is general error message. Since there is an Access Violation (0xc0000005) in sql process, there would be errors in ErrorLog also, along with dump. Due to some issue AV is getting generated and thread is getting. Could you post the SQL Server Setup error log for further troubleshooting?

Alternatively you can try to cleaning the cluster up, remove the node and then try s a new installation.

Additional, please refer t these articles as below, which might be helpful
1. Failover Cluster Troubleshooting

2. FIX: Error message when you install SQL Server 2008 or SQL Server 2008 Service Pack 1 on a Windows XP-based computer that has SQL Server 2000 installed: "Object reference not set to an instance of an object."

3. SQL Server 2005 Encounters Exception During Install When System has Odd Number of Processors or Logical Processors Per Core

---

Regards, Amber zhang

Answer 2

Hello,

Just a little add-in to the excellent post of Amber.

I don't think that this thread is in the good forum. I propose that ( with the agreement of Cougar1492 and Amber )  ) a moderator moves it to this forum :

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads 

i think that your thread will interest more people on this new forum.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 3

Amber, I tried installing a new SQL instance with the same results.  Below is portion of install log showing failure to start SQL Service:

03-01 10:32:59 Slp: Running Action: SqlEngineDBStartConfigAction_install_configrc_Cpu64
2012-03-01 10:32:59 Slp: Action Data:
2012-03-01 10:32:59 Slp:   Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64
2012-03-01 10:32:59 Slp:   Scenario = install
2012-03-01 10:32:59 Slp:   Timing = ConfigRC
2012-03-01 10:32:59 Slp:   ConfigObjectType = Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig
2012-03-01 10:32:59 Slp:   FeatureName = SQL_Engine_Core_Inst
2012-03-01 10:32:59 Slp:   FeatureCpuType = Cpu64
2012-03-01 10:32:59 Slp:   FeaturePackageId = sql_engine_core_inst
2012-03-01 10:32:59 Slp:   FeatureClusterState = CompleteFailoverCluster
2012-03-01 10:32:59 SQLEngine: --SqlEngineDBStartConfig: Install: SqlEngineDBStartConfig Configuration
2012-03-01 10:32:59 Slp: Sco: Attempting to get account sid for user account bartowk12\sqlserv
2012-03-01 10:32:59 Slp: Sco: Attempting to get sid for user account bartowk12\sqlserv
2012-03-01 10:32:59 Slp: Sco: GetSidForAccount normalized accountName bartowk12\sqlserv parameter to bartowk12\sqlserv
2012-03-01 10:32:59 Slp: Sco: Attempting to get account sid for user account bartowk12
2012-03-01 10:32:59 Slp: Sco: Attempting to get sid for user account bartowk12
2012-03-01 10:32:59 Slp: Sco: GetSidForAccount normalized accountName bartowk12 parameter to bartowk12
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.ActiveNode =
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.IsActiveNodeUpgraded = False
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.Version =
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.IsDefaultInstance = False
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.InstanceId = MSSQL10_50.SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.ReferenceInstanceId = MSSQL10_50.SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.InstanceName = SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: container.SqlServerServiceName = MSSQL$SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --ProductProperties: Retrieving product properties from local node.
2012-03-01 10:32:59 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-03-01 10:32:59 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\Setup
2012-03-01 10:32:59 Slp: Sco: Attempting to get registry value ProductCode
2012-03-01 10:32:59 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-03-01 10:32:59 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\Setup
2012-03-01 10:32:59 Slp: Sco: Attempting to get registry value Language
2012-03-01 10:32:59 SQLEngine: --GroupProperties: Loading group properties from local machine.
2012-03-01 10:32:59 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-03-01 10:32:59 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\Setup
2012-03-01 10:32:59 Slp: Sco: Attempting to get registry value SQLGroup
2012-03-01 10:32:59 Slp: Sco: Attempting to get account from sid S-1-5-80-1870809568-3478570751-754150130-741359161-3589841699
2012-03-01 10:32:59 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2012-03-01 10:32:59 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\Setup
2012-03-01 10:32:59 Slp: Sco: Attempting to get registry value SQLPath
2012-03-01 10:32:59 SQLEngine: --EffectiveProperties: Dumping Effective Properties for new instance.
2012-03-01 10:32:59 SQLEngine: --EffectiveProperties:  InstanceId = MSSQL10_50.SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --EffectiveProperties:  InstanceName = SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --EffectiveProperties:  IsDefaultInstance = False
2012-03-01 10:32:59 SQLEngine: --EffectiveProperties:  SqlServerServiceName = MSSQL$SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --EffectiveProperties:  IsExpressSku = False
2012-03-01 10:32:59 SQLEngine: --EffectiveProperties:  IsWorkgroupSku = False
2012-03-01 10:32:59 SQLEngine: --InstallProperties: Dumping Install Properties
2012-03-01 10:32:59 SQLEngine: --InstallProperties: EnableRanu = False
2012-03-01 10:32:59 SQLEngine: --InstallProperties: SecurityMode =
2012-03-01 10:32:59 SQLEngine: --InstallProperties: LoginMode = 1
2012-03-01 10:32:59 SQLEngine: --InstallProperties: SqlCollation = SQL_Latin1_General_CP1_CI_AS
2012-03-01 10:32:59 SQLEngine: --InstallProperties: SqlAdminAccounts = BARTOWK12\Domain Admins
2012-03-01 10:32:59 SQLEngine: --InstallProperties: SqlServiceStartupType = Manual
2012-03-01 10:32:59 SQLEngine: --InstallProperties: SqlAccount = bartowk12\sqlserv
2012-03-01 10:32:59 SQLEngine: --InstallProperties: SqlDomainGroup =
2012-03-01 10:32:59 SQLEngine: --InstallProperties: AddCurrentUserAsSQLAdmin = False
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: Dumping Registry Properties
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: SqlServiceRelativeRegPath = System\CurrentControlSet\Services\MSSQL$SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: CompleteInstanceRegPathByName = SOFTWARE\Microsoft\Microsoft SQL Server\SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: CompleteInstanceRegPathById = SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: ReferenceInstanceRegPathById = SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: MSSQLServerInstanceRegPath = SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\MSSQLServer
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: ReferenceMSSQLServerInstanceRegPath = SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\MSSQLServer
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: SetupInstanceRegPath = SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\Setup
2012-03-01 10:32:59 SQLEngine: --RegistryProperties: ReferenceSetupInstanceRegPath = SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\Setup
2012-03-01 10:32:59 SQLEngine: --ProductProperties: Dumping Product Properties
2012-03-01 10:32:59 SQLEngine: --ProductProperties: ProductCode = fbd367d1-642f-47cf-b79b-9be48fb34007
2012-03-01 10:32:59 SQLEngine: --ProductProperties: LCID = 1033
2012-03-01 10:32:59 SQLEngine: --GroupProperties: Dumping Group Properties
2012-03-01 10:32:59 SQLEngine: --GroupProperties: SqlEngineGroupSid = S-1-5-80-1870809568-3478570751-754150130-741359161-3589841699
2012-03-01 10:32:59 SQLEngine: --GroupProperties: SqlEngineGroupNameFromSid = NT SERVICE\MSSQL$SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --GroupProperties: SqlEngineGroupNameFromSidNoDomain = MSSQL$SQLCLUSTER
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: Dumping Directory Propreties
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: DataRootDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: SystemDataDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: InstallSqlInstanceDir = C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\MSSQL
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: DefaultDataDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: DefaultLogDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: BackupDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\Backup
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: TempDbDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: TempDbLogDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: ErrorLogDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\Log
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: TemplateDataDirectory = L:\MSSQL10_50.SQLCLUSTER\MSSQL\Template Data
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: SqlInstanceBinnDir = C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\MSSQL\Binn
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: SqlInstanceTemplatesDir = C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLCLUSTER\MSSQL\Binn\Templates
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: MasterDbPath =
2012-03-01 10:32:59 SQLEngine: --PublicBasedDirectoryProperties: MasterLogPath =
2012-03-01 10:32:59 SQLEngine: --SqlEngineDBStartConfig: ConfigRC : SqlEngineDBStartConfig Configuration
2012-03-01 10:32:59 Slp: Sco: Attempting to set directory full path
2012-03-01 10:32:59 Slp: Sco: Attempting to normalize directory path L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 Slp: Sco: Attempting to set directory full path
2012-03-01 10:32:59 Slp: Sco: Attempting to normalize directory path L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 Slp: Sco: Attempting to set directory full path
2012-03-01 10:32:59 Slp: Sco: Attempting to normalize directory path L:\MSSQL10_50.SQLCLUSTER\MSSQL\DATA
2012-03-01 10:32:59 Slp: Sco: Attempting to get account from sid S-1-5-80
2012-03-01 10:32:59 Slp: Sco: Attempting to get account sid for user account NT SERVICE\ClusSvc
2012-03-01 10:32:59 Slp: Sco: Attempting to get sid for user account NT SERVICE\ClusSvc
2012-03-01 10:32:59 Slp: Sco: GetSidForAccount normalized accountName NT SERVICE\ClusSvc parameter to NT SERVICE\ClusSvc
2012-03-01 10:32:59 Slp: Sco: Attempting to get account from sid S-1-5-80
2012-03-01 10:32:59 SQLEngine: : Appending Service Security Principal NT SERVICE\MSSQL$SQLCLUSTER to list of sysadmins.
2012-03-01 10:32:59 Slp: Sco: Attempting to get account from sid S-1-5-80
2012-03-01 10:32:59 Slp: Sco: Attempting to get local system account name
2012-03-01 10:32:59 Slp: Sco: Attempting to get NT account from sid S-1-5-18
2012-03-01 10:32:59 Slp: Sco: Attempting to get account from sid S-1-5-18
2012-03-01 10:32:59 Slp: Sco: Attempting to get account sid for user account NT AUTHORITY\SYSTEM
2012-03-01 10:32:59 Slp: Sco: Attempting to get sid for user account NT AUTHORITY\SYSTEM
2012-03-01 10:32:59 Slp: Sco: GetSidForAccount normalized accountName NT AUTHORITY\SYSTEM parameter to NT AUTHORITY\SYSTEM
2012-03-01 10:32:59 Slp: Sco: Attempting to get account sid for user account NT SERVICE\MSSQL$SQLCLUSTER
2012-03-01 10:32:59 Slp: Sco: Attempting to get sid for user account NT SERVICE\MSSQL$SQLCLUSTER
2012-03-01 10:32:59 Slp: Sco: GetSidForAccount normalized accountName NT SERVICE\MSSQL$SQLCLUSTER parameter to NT SERVICE\MSSQL$SQLCLUSTER
2012-03-01 10:32:59 Slp: Sco: Attempting to get account sid for user account BARTOWK12\Domain Admins
2012-03-01 10:32:59 Slp: Sco: Attempting to get sid for user account BARTOWK12\Domain Admins
2012-03-01 10:32:59 Slp: Sco: GetSidForAccount normalized accountName BARTOWK12\Domain Admins parameter to BARTOWK12\Domain Admins
2012-03-01 10:32:59 SQLEngine: : Checking Engine checkpoint 'StartEngineService'
2012-03-01 10:32:59 SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup -f -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T4010 -T3659 -T3610)...
2012-03-01 10:32:59 Slp: Sco: Attempting to start service MSSQL$SQLCLUSTER
2012-03-01 10:32:59 Slp: Sco: Attempting to open SC Manager
2012-03-01 10:32:59 Slp: Sco: Attempting to open service handle for service MSSQL$SQLCLUSTER
2012-03-01 10:33:15 Slp: Sco: Attempting to close service handle for service MSSQL$SQLCLUSTER
2012-03-01 10:33:15 Slp: Sco: Attempting to close SC Manager
2012-03-01 10:33:15 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2012-03-01 10:33:15 Slp: The service did not respond to the start or control request in a timely fashion.

2012-03-01 10:33:15 Slp: The configuration failure category of current exception is ConfigurationFailure
2012-03-01 10:33:15 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
2012-03-01 10:33:15 Slp: System.ComponentModel.Win32Exception: The service did not respond to the start or control request in a timely fashion.

Thanks for your help!

Answer 4

Papy, it is fine with me to move to the new forum.  How do we accomplish?

Thanks!

Answer 5

Hello,

Sorry, only moderators and the owner of a forum can do a move and it is one of the most current tasks of moderators.

I will do the move in a while.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 6

Hello,

Move done. I hope that you will a full and quick answer to your problem.

I have noticed in the install logfile that the problem is on the level of the start of the SQL Server service for the named instance SQLCLUSTER. ( problem to obtain/open an handle for the MSSQL$SQLCLUSTER service maybe, but it is out of my knowledges )

The SQL Server is a 2008 RTM but maybe Cougar1492 could tell us what is the exact edition of the SQL Server ( i suppose a Developer or an Entreprise ). 

Cougar1492, please, could you tell us the version and full edition of the operating system on which you are trying to install your SQL Server ?

Thanks beforehand and good luck

Have a nice day 

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 7

Hi,

SQL version: SW_DVD9_SQL_Svr_Enterprise_Edtn_2008_R2_English_MLF_X16-29540

OS: Windows Server 2008 R2 Enterprise Service Pack 1

Thanks!