I am trying to install SQL Server 2016 on an EC2 instance running Windows Server 2012 r2 and getting a strange error. The following is from the Detail.txt file. I am able to install this on a vagrant box running the same OS. I thought it was a .Net issue at first, but the EC2 instance and my vagrant box have .Net 4.7.0253. I haven't been able to find much information on this error other than people running into a similar issue with a corrupt installer which shouldn't be my case here since it works locally.
Any ideas?
(01) 2017-12-21 15:32:14 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderFile' has been registered
(01) 2017-12-21 15:32:14 Slp: Log provider 'Microsoft.SqlServer.Chainer.Infrastructure.LogProviderStatus' has been registered
(01) 2017-12-21 15:32:14 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'
(01) 2017-12-21 15:32:14 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'
(01) 2017-12-21 15:32:14 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-12-21 15:32:14 Slp: ----------------------------------------------------------------------
(01) 2017-12-21 15:32:14 Slp: Running Action: ReadProductXML
(01) 2017-12-21 15:32:14 Slp: Reading XML resource 'Microsoft.SQL.Chainer.Product.Product.xml'
(01) 2017-12-21 15:32:14 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-12-21 15:32:14 Slp: Completed Action: ReadProductXML, returned True
(01) 2017-12-21 15:32:14 Slp: ----------------------------------------------------------------------
(01) 2017-12-21 15:32:14 Slp: Running Action: LoadExtensions
(01) 2017-12-21 15:32:14 Slp: Loading extension 'MSI' from file 'C:\Users\user\AppData\Local\Temp\SQL-Server-2016\x64\.\Microsoft.SqlServer.Configuration.MsiExtension.dll'
(01) 2017-12-21 15:32:14 Slp: Error: Action "Microsoft.SqlServer.Configuration.BootstrapExtension.LoadExtensionsAction" threw an exception during execution.
(01) 2017-12-21 15:32:14 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-12-21 15:32:14 Slp: at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
(01) 2017-12-21 15:32:14 Slp: at System.Reflection.Assembly.GetTypes()
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionAssembly..ctor(Assembly extensionAssembly)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path, Assembly assembly)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-12-21 15:32:14 Slp: --- End of inner exception stack trace ---
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.LoadExtensions(XmlElement extensionsElement)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Configuration.BootstrapExtension.LoadExtensionsAction.ExecuteAction(String actionId)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
(01) 2017-12-21 15:32:14 Slp: --- End of inner exception stack trace ---
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionWithRetryHelper(WorkflowObject metaDb, ActionKey action, ActionMetadata actionMetadata, TextWriter statusStream)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
(01) 2017-12-21 15:32:14 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)
(01) 2017-12-21 15:32:15 Slp: Received request to add the following file to Watson reporting: C:\Users\user\AppData\Local\Temp\tmpF56C.tmp
(01) 2017-12-21 15:32:15 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2017-12-21 15:32:15 Slp: Inner exceptions are being indented
(01) 2017-12-21 15:32:15 Slp:
(01) 2017-12-21 15:32:15 Slp: Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException
(01) 2017-12-21 15:32:15 Slp: Message:
(01) 2017-12-21 15:32:15 Slp: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
(01) 2017-12-21 15:32:15 Slp: HResult : 0x84b10001
(01) 2017-12-21 15:32:15 Slp: FacilityCode : 1201 (4b1)
(01) 2017-12-21 15:32:15 Slp: ErrorCode : 1 (0001)
(01) 2017-12-21 15:32:15 Slp: Stack:
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.LoadExtensions(XmlElement extensionsElement)
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Configuration.BootstrapExtension.LoadExtensionsAction.ExecuteAction(String actionId)
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClasse.<ExecuteActionWithRetryHelper>b__b()
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)
(01) 2017-12-21 15:32:15 Slp: Inner exception type: System.Reflection.ReflectionTypeLoadException
(01) 2017-12-21 15:32:15 Slp: Message:
(01) 2017-12-21 15:32:15 Slp: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
(01) 2017-12-21 15:32:15 Slp: HResult : 0x80131602
(01) 2017-12-21 15:32:15 Slp: Stack:
(01) 2017-12-21 15:32:15 Slp: at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
(01) 2017-12-21 15:32:15 Slp: at System.Reflection.Assembly.GetTypes()
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionAssembly..ctor(Assembly extensionAssembly)
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path, Assembly assembly)
(01) 2017-12-21 15:32:15 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension(String extensionId, String name, String path)
(01) 2017-12-21 15:32:15 Slp: Watson Bucket 1
Original Parameter Values
(01) 2017-12-21 15:32:15 Slp: Parameter 0 : SQL Server 2016@RTM@
(01) 2017-12-21 15:32:15 Slp: Parameter 1 : Microsoft.SqlServer.Chainer.Infrastructure.ExtensionService.RegisterExtension
(01) 2017-12-21 15:32:15 Slp: Parameter 2 : System.Reflection.RuntimeModule.GetTypes
(01) 2017-12-21 15:32:15 Slp: Parameter 3 : Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException@1201@1
(01) 2017-12-21 15:32:15 Slp: Parameter 4 : System.Reflection.ReflectionTypeLoadException@-2146232830
(01) 2017-12-21 15:32:15 Slp: Parameter 5 : LoadExtensions
(01) 2017-12-21 15:32:15 Slp:
Final Parameter Values
(01) 2017-12-21 15:32:15 Slp: Parameter 0 : SQL Server 2016@RTM@
(01) 2017-12-21 15:32:15 Slp: Parameter 1 : 0xA8410502
(01) 2017-12-21 15:32:15 Slp: Parameter 2 : 0x28572BA7
(01) 2017-12-21 15:32:15 Slp: Parameter 3 : 0xDF039760@1201@1
(01) 2017-12-21 15:32:15 Slp: Parameter 4 : 0xFAF2DA28
(01) 2017-12-21 15:32:15 Slp: Parameter 5 : LoadExtensions
(01) 2017-12-21 15:32:15 Slp: The following exception occurred while preparing status logs during Watson failure processing: The input setting 'INSTALLMEDIAPATH' specified is not recognized.
(01) 2017-12-21 15:32:15 Slp: Sco: Unable to open hklm registry key SOFTWARE\Microsoft\Microsoft SQL Server, error The system cannot find the file specified.
(01) 2017-12-21 15:32:15 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20171221_153212\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
(01) 2017-12-21 15:32:15 Slp: Sco: Unable to open hklm registry key SOFTWARE\Microsoft\MSSQLServer, error The system cannot find the file specified.
(01) 2017-12-21 15:32:15 Slp: Sco: Unable to open hklm registry key SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server, error The system cannot find the file specified.
(01) 2017-12-21 15:32:15 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20171221_153212\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
(01) 2017-12-21 15:32:15 Slp: Sco: Unable to open hklm registry key SOFTWARE\Wow6432Node\Microsoft\MSSQLServer, error The system cannot find the file specified.
(01) 2017-12-21 15:32:15 Slp: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
(01) 2017-12-21 15:32:15 Slp: Watson bucket for exception based failure has been created
(01) 2017-12-21 15:32:15 Slp:
(01) 2017-12-21 15:32:15 Slp: ----------------------------------------------------------------------
(01) 2017-12-21 15:32:15 Slp:
(01) 2017-12-21 15:32:15 Slp: Error result: -2068774911
(01) 2017-12-21 15:32:15 Slp: Result facility code: 1201
(01) 2017-12-21 15:32:15 Slp: Result error code: 1
(01) 2017-12-21 15:32:15 Slp: SetupTelemetry: Closing Telemetry Session
(01) 2017-12-21 15:32:15 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2017-12-21 15:32:15 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\SQMClient
(01) 2017-12-21 15:32:15 Slp: Sco: Attempting to get registry value MachineId
(01) 2017-12-21 15:32:15 Slp: SetupTelemetry: Telemetry does not have active session.
User contributions licensed under CC BY-SA 3.0