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

    คำถาม

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




    • ย้ายโดย Papy NormandModerator 1 มีนาคม 2555 16:13 Not related to SQL Server Data Access but it is a problem of setup of a clustered failover (sqlservr.exe not starting ) (From:SQL Server Data Access)
    • แก้ไขโดย Cougar1492 1 มีนาคม 2555 18:18
    28 กุมภาพันธ์ 2555 16:40

ตอบทั้งหมด

  • 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

    1 มีนาคม 2555 7:28
    ผู้ดูแล
  • 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.

    1 มีนาคม 2555 8:26
    ผู้ดูแล
  • 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!

    1 มีนาคม 2555 15:58
  • Papy, it is fine with me to move to the new forum.  How do we accomplish?

    Thanks!

    1 มีนาคม 2555 16:00
  • 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.

    1 มีนาคม 2555 16:09
    ผู้ดูแล
  • 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.

    1 มีนาคม 2555 16:29
    ผู้ดูแล
  • 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!


    • แก้ไขโดย Cougar1492 2 มีนาคม 2555 14:08
    1 มีนาคม 2555 16:36