Can't install HPC on Win2012R2 cause of Microsoft SQL

Copper Contributor

I tried to install HPC on WinServ2012R2 with DC role.  When it reached the step "Microsoft SQL server 2014 Express"  I got the next error :Снимок экрана от 2017-10-23 14-25-33.png

log:

 

Spoiler
(01) 2017-10-23 13:13:48 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderFile' has been registered(01) 2017-10-23 13:13:48 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderStatus' has been registered(01) 2017-10-23 13:13:48 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'
(01) 2017-10-23 13:13:48 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'
(01) 2017-10-23 13:13:48 Slp: Document 'Microsoft.SQL.Chainer.PackageData.Package.xml' validated with schema 'Microsoft.SQL.Chainer.Package.Package.xsd' has been successfuly loaded into datastore path '/Datastore/Package'
(01) 2017-10-23 13:13:48 Slp: ----------------------------------------------------------------------
(01) 2017-10-23 13:13:48 Slp: Running Action: ReadProductXML
(01) 2017-10-23 13:13:48 Slp: Reading XML resource 'Microsoft.SQL.Chainer.Product.Product.xml'
(01) 2017-10-23 13:13:48 Slp: Document 'Microsoft.SQL.Chainer.Product.Product.xml' validated with schema 'Microsoft.SQL.Chainer.Product.Product.xsd' has been successfuly loaded into datastore path '/Datastore/Product'
(01) 2017-10-23 13:13:48 Slp: Completed Action: ReadProductXML, returned True
(01) 2017-10-23 13:13:48 Slp: ----------------------------------------------------------------------
(01) 2017-10-23 13:13:48 Slp: Running Action: LoadExtensions
(01) 2017-10-23 13:13:48 Slp: Loading extension 'MSI' from file 'C:\Users\Администратор\AppData\Local\Temp\2\sqlserver_f1e9d5ed-1319-44c4-993d-f7555e046ef5\x64\.\Microsoft.SqlServer.Configuration.MsiExtension.dll'
(01) 2017-10-23 13:13:48 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.LoadExtensionsAction" threw an exception during execution.
(01) 2017-10-23 13:13:48 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. ---> Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. ---> System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
(01) 2017-10-23 13:13:48 Slp:    at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
(01) 2017-10-23 13:13:48 Slp:    at System.Reflection.RuntimeModule.GetTypes()
(01) 2017-10-23 13:13:48 Slp:    at System.Reflection.Assembly.GetTypes()
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionAssembly..ctor(Assembly extensionAssembly)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-10-23 13:13:48 Slp:    --- End of inner exception stack trace ---
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.LoadExtensions(XmlElement extensionsElement)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Configuration.BootstrapExtension.LoadExtensionsAction.ExecuteAction(String actionId)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
(01) 2017-10-23 13:13:48 Slp:    --- End of inner exception stack trace ---
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
(01) 2017-10-23 13:13:48 Slp:    at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
(01) 2017-10-23 13:13:49 Slp: Received request to add the following file to Watson reporting: C:\Users\Администратор\AppData\Local\Temp\2\tmp7BB3.tmp(01) 2017-10-23 13:13:49 Slp: The following is an exception stack listing the exceptions in outermost to innermost order(01) 2017-10-23 13:13:49 Slp: Inner exceptions are being indented(01) 2017-10-23 13:13:49 Slp: 
(01) 2017-10-23 13:13:49 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException
(01) 2017-10-23 13:13:49 Slp:     Message: 
(01) 2017-10-23 13:13:49 Slp:         Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
(01) 2017-10-23 13:13:49 Slp:     HResult : 0x84b10001
(01) 2017-10-23 13:13:49 Slp:         FacilityCode : 1201 (4b1)
(01) 2017-10-23 13:13:49 Slp:         ErrorCode : 1 (0001)
(01) 2017-10-23 13:13:49 Slp:     Stack: 
(01) 2017-10-23 13:13:49 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-10-23 13:13:49 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.LoadExtensions(XmlElement extensionsElement)
(01) 2017-10-23 13:13:49 Slp:         at Microsoft.SqlServer.Configuration.BootstrapExtension.LoadExtensionsAction.ExecuteAction(String actionId)
(01) 2017-10-23 13:13:49 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
(01) 2017-10-23 13:13:49 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
(01) 2017-10-23 13:13:49 Slp:         at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
(01) 2017-10-23 13:13:49 Slp:     Inner exception type: System.Reflection.ReflectionTypeLoadException
(01) 2017-10-23 13:13:49 Slp:         Message: 
(01) 2017-10-23 13:13:49 Slp:                 Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
(01) 2017-10-23 13:13:49 Slp:         HResult : 0x80131602
(01) 2017-10-23 13:13:49 Slp:         Stack: 
(01) 2017-10-23 13:13:49 Slp:                 at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
(01) 2017-10-23 13:13:49 Slp:                 at System.Reflection.RuntimeModule.GetTypes()
(01) 2017-10-23 13:13:49 Slp:                 at System.Reflection.Assembly.GetTypes()
(01) 2017-10-23 13:13:49 Slp:                 at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionAssembly..ctor(Assembly extensionAssembly)
(01) 2017-10-23 13:13:49 Slp:                 at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-10-23 13:13:49 Slp: Watson Bucket 1 
 Original Parameter Values 

(01) 2017-10-23 13:13:49 Slp: Parameter 0 : SQL Server 2014@RTM@ 

(01) 2017-10-23 13:13:49 Slp: Parameter 1 : Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension 

(01) 2017-10-23 13:13:49 Slp: Parameter 2 : System.Reflection.RuntimeModule.GetTypes 

(01) 2017-10-23 13:13:49 Slp: Parameter 3 : Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException@1201@1 

(01) 2017-10-23 13:13:49 Slp: Parameter 4 : System.Reflection.ReflectionTypeLoadException@-2146232830 

(01) 2017-10-23 13:13:49 Slp: Parameter 5 : LoadExtensions 

(01) 2017-10-23 13:13:49 Slp: 
 Final Parameter Values 

(01) 2017-10-23 13:13:49 Slp: Parameter 0 : SQL Server 2014@RTM@ 

(01) 2017-10-23 13:13:49 Slp: Parameter 1 : 0xA8410502 

(01) 2017-10-23 13:13:49 Slp: Parameter 2 : 0x28572BA7 

(01) 2017-10-23 13:13:49 Slp: Parameter 3 : 0xDF039760@1201@1 

(01) 2017-10-23 13:13:49 Slp: Parameter 4 : 0xFAF2DA28 

(01) 2017-10-23 13:13:49 Slp: Parameter 5 : LoadExtensions 

(01) 2017-10-23 13:13:49 Slp: The following exception occurred while preparing status logs during Watson failure processing: The input setting 'INSTALLMEDIAPATH' specified is not recognized.
(01) 2017-10-23 13:13:49 Slp: Sco: Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20171023_131347\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_(01) 2017-10-23 13:13:49 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20171023_131347\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_(01) 2017-10-23 13:13:49 Slp: Sco: Unable to open hklm registry key SOFTWARE\Microsoft\MSSQLServer, error Не удается найти указанный файл.

(01) 2017-10-23 13:13:49 Slp: Sco: Unable to open hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server, error Не удается найти указанный файл.

(01) 2017-10-23 13:13:49 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20171023_131347\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_(01) 2017-10-23 13:13:49 Slp: Sco: Unable to open hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer, error Не удается найти указанный файл.

(01) 2017-10-23 13:13:49 Slp: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
(01) 2017-10-23 13:13:49 Slp: Watson bucket for exception based failure has been created(01) 2017-10-23 13:13:49 Slp: 
(01) 2017-10-23 13:13:49 Slp: ----------------------------------------------------------------------
(01) 2017-10-23 13:13:49 Slp: 
(01) 2017-10-23 13:13:49 Slp: Error result: -2068774911
(01) 2017-10-23 13:13:49 Slp: Result facility code: 1201
(01) 2017-10-23 13:13:49 Slp: Result error code: 1
(01) 2017-10-23 13:13:50 Slp: SQM Service: Sqm does not have active session.

Then I tried to install Microsoft SQL separatelly, but get the next error:Снимок экрана от 2017-10-24 10-37-17.png

log:

Spoiler
verall summary:
  Final result:                  Ошибка: дополнительные сведения см. ниже
  Exit code (Decimal):           -2061893606
  Start time:                    2017-10-24 09:29:16
  End time:                      2017-10-24 09:33:47
  Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for SQLEngine:       Устраните ошибку, пользуясь следующими сведениями, удалите компонент, а затем запустите установку еще раз.
  Next step for Replication:     Устраните ошибку, пользуясь следующими сведениями, удалите компонент, а затем запустите установку еще раз.


Machine Properties:
  Machine name:                  DC1
  Machine processor count:       1  OS version:                    Windows Server 2012  OS service pack:               
  OS region:                     Россия  OS language:                   русский (Россия)  OS architecture:               x64
  Process architecture:          64-разрядная версия  OS clustered:                  Нет

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered  Configured

Package properties:
  Description:                   Microsoft SQL Server 2014 
  ProductName:                   SQL Server 2014
  Type:                          RTM
  Version:                       12
  SPLevel:                       0
  Installation location:         C:\SQLEXPR_x64_RUS\x64\setup\
  Installation edition:          Express

Product Update Status:
  Не обнаружено.

Параметры пользовательского ввода:  ACTION:                        Install  ADDCURRENTUSERASSQLADMIN:      true  AGTSVCACCOUNT:                 NT AUTHORITY\NETWORK SERVICE
  AGTSVCPASSWORD:                *****  AGTSVCSTARTUPTYPE:             Disabled  ASBACKUPDIR:                   Backup  ASCOLLATION:                   Latin1_General_CI_AS  ASCONFIGDIR:                   Config  ASDATADIR:                     Data  ASLOGDIR:                      Log  ASPROVIDERMSOLAP:              1  ASSERVERMODE:                  MULTIDIMENSIONAL
  ASSVCACCOUNT:                  <не заполнено>  ASSVCPASSWORD:                 <не заполнено>  ASSVCSTARTUPTYPE:              Automatic  ASSYSADMINACCOUNTS:            <не заполнено>  ASTEMPDIR:                     Temp  BROWSERSVCSTARTUPTYPE:         Disabled  CLTCTLRNAME:                   <не заполнено>  CLTRESULTDIR:                  <не заполнено>  CLTSTARTUPTYPE:                0  CLTSVCACCOUNT:                 <не заполнено>  CLTSVCPASSWORD:                <не заполнено>  CLTWORKINGDIR:                 <не заполнено>  COMMFABRICENCRYPTION:          0  COMMFABRICNETWORKLEVEL:        0  COMMFABRICPORT:                0  CONFIGURATIONFILE:             
  CTLRSTARTUPTYPE:               0  CTLRSVCACCOUNT:                <не заполнено>  CTLRSVCPASSWORD:               <не заполнено>  CTLRUSERS:                     <не заполнено>  ENABLERANU:                    true  ENU:                           false  ERRORREPORTING:                false  FEATURES:                      SQLENGINE, REPLICATION, SNAC_SDK
  FILESTREAMLEVEL:               0  FILESTREAMSHARENAME:           <не заполнено>  FTSVCACCOUNT:                  <не заполнено>  FTSVCPASSWORD:                 <не заполнено>  HELP:                          false  IACCEPTSQLSERVERLICENSETERMS:  true  INDICATEPROGRESS:              false  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <не заполнено>  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
  INSTANCEID:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\Network Service  ISSVCPASSWORD:                 <не заполнено>  ISSVCSTARTUPTYPE:              Automatic  MATRIXCMBRICKCOMMPORT:         0  MATRIXCMSERVERNAME:            <не заполнено>  MATRIXNAME:                    <не заполнено>  NPENABLED:                     0  PID:                           *****  QUIET:                         false  QUIETSIMPLE:                   false  ROLE:                          AllFeatures_WithDefaults  RSINSTALLMODE:                 DefaultNativeMode  RSSHPINSTALLMODE:              DefaultSharePointMode  RSSVCACCOUNT:                  <не заполнено>  RSSVCPASSWORD:                 <не заполнено>  RSSVCSTARTUPTYPE:              Automatic  SAPWD:                         <не заполнено>  SECURITYMODE:                  <не заполнено>  SQLBACKUPDIR:                  <не заполнено>  SQLCOLLATION:                  Cyrillic_General_CI_AS  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCPASSWORD:                <не заполнено>  SQLSVCSTARTUPTYPE:             Automatic  SQLSYSADMINACCOUNTS:           IDSAO\Администратор  SQLTEMPDBDIR:                  <не заполнено>  SQLTEMPDBLOGDIR:               <не заполнено>  SQLUSERDBDIR:                  <не заполнено>  SQLUSERDBLOGDIR:               <не заполнено>  SQMREPORTING:                  false  TCPENABLED:                    0  UIMODE:                        AutoAdvance
  UpdateEnabled:                 true
  UpdateSource:                  MU
  USEMICROSOFTUPDATE:            false  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20171024_092915\ConfigurationFile.ini

Detailed results:
  Feature:                       Службы компонента Database Engine
  Status:                        Ошибка. Дополнительные сведения см. в журнале.
  Reason for failure:            Произошла ошибка во время процесса установки компонента.
  Next Step:                     Устраните ошибку, пользуясь следующими сведениями, удалите компонент, а затем запустите установку еще раз.
  Component name:                Экземпляры служб компонента SQL Server Database Engine
  Component error code:          0x851A001A
  Error description:             Ошибка при ожидании дескриптора восстановления компонента Database Engine. Возможные причины см. в журнале ошибок SQL Server.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

  Feature:                       Репликация SQL Server
  Status:                        Ошибка. Дополнительные сведения см. в журнале.
  Reason for failure:            Возникла ошибка для одной из зависимостей компонента, вызвавшая сбой процесса его установки.
  Next Step:                     Устраните ошибку, пользуясь следующими сведениями, удалите компонент, а затем запустите установку еще раз.
  Component name:                Экземпляры служб компонента SQL Server Database Engine
  Component error code:          0x851A001A
  Error description:             Ошибка при ожидании дескриптора восстановления компонента Database Engine. Возможные причины см. в журнале ошибок SQL Server.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&Evtsrc=setup.rll&EvtID=50000&ProdVer=12.0.2000.8&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026

  Feature:                       Браузер SQL
  Status:                        Завершено

  Feature:                       Модуль записи SQL
  Status:                        Завершено

  Feature:                       Средства связи клиента SQL
  Status:                        Завершено

  Feature:                       Пакет SDK средств связи клиента SQL
  Status:                        Завершено

  Feature:                       Файлы поддержки программы установки
  Status:                        Завершено

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20171024_092915\SystemConfigurationCheck_Report.htm

In russian microsoft comunity said that cause may be in permissions for priveleges:

SeBackupPrivilege
SeDebugPrivilege
SeSecurityPrivilege

(But I tried to install SQL on Adminstator (domain and local)) Ok i set up Default Domain Controllers Policy"->Computer Configuration->Policies->Windows Settings->Security Settings->Local Policies->User Rights Assignments.

 

But nothing changes.

I checked "whoami /all" and saw that the privileges still disabled.

Снимок экрана от 2017-10-25 10-30-43.png

 

In total I can't  to install HPC, cant to install SQL. I tried to install SQL on pure Win2012R2 and got the errors. Please, people, explain what else iIneed to do(check).

P.S. (Win2012R2 installed in Hyper-v VM)

0 Replies