Windows Server 2012 R2 essentials に SQLServer 2012 をインストール時、データベース エンジンの復旧ハンドルの待機に失敗となる

• 質問

• 

  

  0

  サインインして投票

  掲題の通りインストールエラーが発生する為、対応策を教えて下さい。
  
  インストール時のオプションは触らず、デフォルトのまま実施しています。
  
  Windous認証、混合モードどちらで試しても同じエラーとなります。
  
  また、SQLServer2014に変えても同じ状況です。
  
  
  ドメインコントローラーにSQLServerをインストールするのは推奨されないようですが、それを踏まえて実施しております。
  
  下記の情報を参考にして、サービスアカウントの変更を行っても改善されませんでした。
  
  https://social.technet.microsoft.com/Forums/windowsserver/ja-JP/5ac724a6-a316-4e5b-b88c-f1748eb34644/sqlserver2012?forum=winserver8
  
  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8f4d5cf8-4ab8-4a37-81df-7c294f994515/sql-server-2012-install-error-851a001a?forum=sqlsetupandupgrade
  
  エラー内容は下記となります。
  
  ------------------------------------------------------
  
  
    Feature:                       データベース エンジン サービス
    Status:                        失敗しました: 詳細についてはログを参照してください
    Reason for failure:            機能のセットアップ処理中にエラーが発生しました。
    Next Step:                     以下の情報を使用してエラーを解決し、この機能をアンインストールしてから、セットアップ処理を再実行してください。
    Component name:                SQL Server データベース エンジン サービス インスタンス機能
    Component error code:          0x851A001A
    Error description:             データベース エンジンの復旧ハンドルの待機に失敗しました。考えられる原因については、SQL Server エラー ログを参照してください。
  
  
  ------------------------------------------------------
  
  
  エラーログ(ERROR.LOG)の内容
  
  ------------------------------------------------------
  
  
  2015-03-04 20:59:50.30 Server      Microsoft SQL Server 2014 - 12.0.2000.8 (X64)
   Feb 20 2014 20:04:26
   Copyright (c) Microsoft Corporation
   Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
  
  2015-03-04 20:59:50.30 Server      UTC adjustment: 9:00
  2015-03-04 20:59:50.30 Server      (c) Microsoft Corporation.
  2015-03-04 20:59:50.30 Server      All rights reserved.
  2015-03-04 20:59:50.30 Server      Server process ID is 8692.
  2015-03-04 20:59:50.31 Server      System Manufacturer: 'ASUSTeK COMPUTER INC.', System Model: 'P9D-I Series'.
  2015-03-04 20:59:50.31 Server      Authentication mode is WINDOWS-ONLY.
  2015-03-04 20:59:50.31 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
  2015-03-04 20:59:50.31 Server      The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
  2015-03-04 20:59:50.31 Server      Registry startup parameters:
    -d C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\master.mdf
    -e C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log\ERRORLOG
    -l C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
  2015-03-04 20:59:50.31 Server      Command Line Startup Parameters:
    -s "SQLEXPRESS"
    -m "SqlSetup"
    -Q
    -q "Japanese_CI_AS"
    -T 4022
    -T 4010
    -T 3659
    -T 3610
    -T 8015
    -d "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\master.mdf"
    -l "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
  2015-03-04 20:59:50.74 Server      SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
  2015-03-04 20:59:50.74 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
  2015-03-04 20:59:50.74 Server      Detected 8153 MB of RAM. This is an informational message; no user action is required.
  2015-03-04 20:59:50.74 Server      Using conventional memory in the memory manager.
  2015-03-04 20:59:50.87 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
  2015-03-04 20:59:50.92 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
  2015-03-04 20:59:50.95 Server      Query Store settings initialized with enabled = 1,
  2015-03-04 20:59:50.96 Server      The maximum number of dedicated administrator connections for this instance is '1'
  2015-03-04 20:59:50.96 Server      Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
  2015-03-04 20:59:50.98 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
  2015-03-04 20:59:51.01 Server      Database Mirroring Transport is disabled in the endpoint configuration.
  2015-03-04 20:59:51.01 Server      Software Usage Metrics is disabled.
  2015-03-04 20:59:51.01 spid7s      Warning ******************
  2015-03-04 20:59:51.01 spid7s      SQL Server started in single-user mode. This an informational message only. No user action is required.
  2015-03-04 20:59:51.01 spid7s      Starting up database 'master'.
  2015-03-04 20:59:51.08 spid7s      The tail of the log for database master is being rewritten to match the new sector size of 4096 bytes.  1024 bytes at offset 347136 in file C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf will be written.
  2015-03-04 20:59:51.11 Server      CLR version v4.0.30319 loaded.
  2015-03-04 20:59:51.40 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
  2015-03-04 20:59:53.69 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
  2015-03-04 20:59:53.71 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
  2015-03-04 20:59:53.88 spid7s      SQL Trace ID 1 was started by login "sa".
  2015-03-04 20:59:53.95 spid7s      Server name is '********\SQLEXPRESS'. This is an informational message only. No user action is required.
  2015-03-04 20:59:53.97 spid7s      Starting up database 'msdb'.
  2015-03-04 20:59:53.98 spid11s     Starting up database 'mssqlsystemresource'.
  2015-03-04 20:59:54.00 spid14s     Password policy update was successful.
  2015-03-04 20:59:54.01 spid11s     The resource database build version is 12.00.2000. This is an informational message only. No user action is required.
  2015-03-04 20:59:54.05 spid7s      The tail of the log for database msdb is being rewritten to match the new sector size of 4096 bytes.  3584 bytes at offset 49664 in file C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\MSDBLog.ldf will be written.
  2015-03-04 20:59:54.30 spid11s     Starting up database 'model'.
  2015-03-04 20:59:54.46 spid11s     The tail of the log for database model is being rewritten to match the new sector size of 4096 bytes.  3584 bytes at offset 57856 in file C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\modellog.ldf will be written.
  2015-03-04 20:59:54.86 spid11s     Clearing tempdb database.
  2015-03-04 20:59:56.19 spid14s     Error: 17190, Severity: 16, State: 1.
  2015-03-04 20:59:56.19 spid14s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
  2015-03-04 20:59:56.19 spid14s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
  2015-03-04 20:59:56.23 spid14s     Error: 17182, Severity: 16, State: 1.
  2015-03-04 20:59:56.23 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
  2015-03-04 20:59:56.23 spid14s     Error: 17182, Severity: 16, State: 1.
  2015-03-04 20:59:56.23 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.
  2015-03-04 20:59:56.23 spid14s     Error: 17826, Severity: 18, State: 3.
  2015-03-04 20:59:56.23 spid14s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
  2015-03-04 20:59:56.23 spid14s     Error: 17120, Severity: 16, State: 1.
  2015-03-04 20:59:56.23 spid14s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
  
  ------------------------------------------------------
  
  
  2015-03-04 20:59:58.94 Server      Microsoft SQL Server 2014 - 12.0.2000.8 (X64)
   Feb 20 2014 20:04:26
   Copyright (c) Microsoft Corporation
   Express Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )
  
  2015-03-04 20:59:58.94 Server      UTC adjustment: 9:00
  2015-03-04 20:59:58.94 Server      (c) Microsoft Corporation.
  2015-03-04 20:59:58.94 Server      All rights reserved.
  2015-03-04 20:59:58.94 Server      Server process ID is 8792.
  2015-03-04 20:59:58.94 Server      System Manufacturer: 'ASUSTeK COMPUTER INC.', System Model: 'P9D-I Series'.
  2015-03-04 20:59:58.94 Server      Authentication mode is WINDOWS-ONLY.
  2015-03-04 20:59:58.94 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log\ERRORLOG'.
  2015-03-04 20:59:58.94 Server      The service account is 'NT Service\MSSQL$SQLEXPRESS'. This is an informational message; no user action is required.
  2015-03-04 20:59:58.94 Server      Registry startup parameters:
    -d C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\master.mdf
    -e C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Log\ERRORLOG
    -l C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\mastlog.ldf
  2015-03-04 20:59:58.94 Server      Command Line Startup Parameters:
    -s "SQLEXPRESS"
    -m "SqlSetup"
    -Q
    -q "Japanese_CI_AS"
    -T 4022
    -T 4010
    -T 3659
    -T 3610
    -T 8015
    -d "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\master.mdf"
    -l "C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\Template Data\mastlog.ldf"
  2015-03-04 20:59:59.34 Server      SQL Server detected 1 sockets with 4 cores per socket and 4 logical processors per socket, 4 total logical processors; using 4 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
  2015-03-04 20:59:59.40 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
  2015-03-04 20:59:59.40 Server      Detected 8153 MB of RAM. This is an informational message; no user action is required.
  2015-03-04 20:59:59.40 Server      Using conventional memory in the memory manager.
  2015-03-04 20:59:59.48 Server      Default collation: SQL_Latin1_General_CP1_CI_AS (us_english 1033)
  2015-03-04 20:59:59.50 Server      Perfmon counters for resource governor pools and groups failed to initialize and are disabled.
  2015-03-04 20:59:59.51 Server      Query Store settings initialized with enabled = 1,
  2015-03-04 20:59:59.51 Server      The maximum number of dedicated administrator connections for this instance is '1'
  2015-03-04 20:59:59.51 Server      This instance of SQL Server last reported using a process ID of 8692 at 2015/03/04 20:59:50 (local) 2015/03/04 11:59:50 (UTC). This is an informational message only; no user action is required.
  2015-03-04 20:59:59.51 Server      Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
  2015-03-04 20:59:59.52 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
  2015-03-04 20:59:59.55 Server      Database Mirroring Transport is disabled in the endpoint configuration.
  2015-03-04 20:59:59.55 Server      Software Usage Metrics is disabled.
  2015-03-04 20:59:59.55 spid7s      Warning ******************
  2015-03-04 20:59:59.55 spid7s      SQL Server started in single-user mode. This an informational message only. No user action is required.
  2015-03-04 20:59:59.56 spid7s      Starting up database 'master'.
  2015-03-04 20:59:59.64 spid7s      11 transactions rolled forward in database 'master' (1:0). This is an informational message only. No user action is required.
  2015-03-04 20:59:59.64 Server      CLR version v4.0.30319 loaded.
  2015-03-04 20:59:59.76 spid7s      0 transactions rolled back in database 'master' (1:0). This is an informational message only. No user action is required.
  2015-03-04 20:59:59.76 spid7s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
  2015-03-04 20:59:59.76 Server      Common language runtime (CLR) functionality initialized using CLR version v4.0.30319 from C:\Windows\Microsoft.NET\Framework64\v4.0.30319\.
  2015-03-04 20:59:59.97 spid7s      Service Master Key could not be decrypted using one of its encryptions. See sys.key_encryptions for details.
  2015-03-04 21:00:00.04 spid7s      SQL Server Audit is starting the audits. This is an informational message. No user action is required.
  2015-03-04 21:00:00.05 spid7s      SQL Server Audit has started the audits. This is an informational message. No user action is required.
  2015-03-04 21:00:00.22 spid7s      SQL Trace ID 1 was started by login "sa".
  2015-03-04 21:00:00.22 spid7s      Server name is '******\SQLEXPRESS'. This is an informational message only. No user action is required.
  2015-03-04 21:00:00.24 spid7s      Starting up database 'msdb'.
  2015-03-04 21:00:00.24 spid11s     Starting up database 'mssqlsystemresource'.
  2015-03-04 21:00:00.25 spid11s     The resource database build version is 12.00.2000. This is an informational message only. No user action is required.
  2015-03-04 21:00:00.28 spid7s      1 transactions rolled forward in database 'msdb' (4:0). This is an informational message only. No user action is required.
  2015-03-04 21:00:00.33 spid11s     Starting up database 'model'.
  2015-03-04 21:00:00.34 spid7s      0 transactions rolled back in database 'msdb' (4:0). This is an informational message only. No user action is required.
  2015-03-04 21:00:00.48 spid11s     Clearing tempdb database.
  2015-03-04 21:00:01.72 spid11s     Starting up database 'tempdb'.
  2015-03-04 21:00:02.08 spid7s      Warning ******************
  2015-03-04 21:00:02.08 spid7s      Attempting to change default collation to Japanese_CI_AS.
  2015-03-04 21:00:02.42 spid14s     Error: 17190, Severity: 16, State: 1.
  2015-03-04 21:00:02.42 spid14s     Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
  2015-03-04 21:00:02.42 spid14s     Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
  2015-03-04 21:00:02.42 spid14s     Error: 17182, Severity: 16, State: 1.
  2015-03-04 21:00:02.42 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
  2015-03-04 21:00:02.42 spid14s     Error: 17182, Severity: 16, State: 1.
  2015-03-04 21:00:02.42 spid14s     TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.
  2015-03-04 21:00:02.42 spid14s     Error: 17826, Severity: 18, State: 3.
  2015-03-04 21:00:02.42 spid14s     Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
  2015-03-04 21:00:02.42 spid14s     Error: 17120, Severity: 16, State: 1.
  2015-03-04 21:00:02.42 spid14s     SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
  ------------------------------------------------------
  
  サーバー名はマスクしてあります。
  

  2015年3月5日 0:40

  返信

  |

  引用