June 14, 2016 at 8:49 am
I just attempted installing SQL 2016 RTM and the install rebooted the server. After the reboot SQL of course is not working at all due to the install not completing; so, it's hosed up. It appears that msiexec requested a restart due to SSIS (see below). Has anyone had this issue? This is a new Win 2012-R2 VM and a new SQL 2016 install.
From the Win App Error Log: Windows Installer requires a system restart. Product Name: SQL Server 2016 Integration Services. Product Version: 13.0.1601.5. Product Language: 1033. Manufacturer: Microsoft Corporation. Type of System Restart: 1. Reason for Restart: 1.
p.s. we need a SQL 2016 Forum please
June 14, 2016 at 8:56 am
SQL 2016 forum is available, post the same there.
Regards
Durai Nagarajan
June 14, 2016 at 9:14 am
Moving to SQL 2016 Admin.
Haven't seen this or seen a report. What does the setup log note?
June 14, 2016 at 9:30 am
Looks like .net caused it:
(01) 2016-06-14 10:14:24 Slp: Running Action: InitializeMsiAction
(01) 2016-06-14 10:14:24 Slp: Attempting to pause the 32 bit ngen queue for x64
(01) 2016-06-14 10:14:24 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2016-06-14 10:14:24 Slp: Sco: Attempting to open registry subkey
(01) 2016-06-14 10:14:24 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
(01) 2016-06-14 10:14:24 Slp: Sco: Attempting to get registry value InstallPath
(01) 2016-06-14 10:14:24 Slp: ngen command to be used from .Net Framework Directory: C:\Windows\Microsoft.NET\Framework\v4.0.30319(01) 2016-06-14 10:14:24 Slp: Running: C:\Windows\Microsoft.NET\Framework\v4.0.30319gen.exe queue pause
(16) 2016-06-14 10:14:25 Slp: Microsoft (R) CLR Native Image Generator - Version 4.0.30319.33440
(16) 2016-06-14 10:14:25 Slp: Copyright (c) Microsoft Corporation. All rights reserved.
(16) 2016-06-14 10:14:25 Slp:
(16) 2016-06-14 10:14:25 Slp: The .NET Runtime Optimization Service is started and paused.
(01) 2016-06-14 10:14:25 Slp: Process returned 0
(01) 2016-06-14 10:14:25 Slp: Attempting to pause the 64 bit ngen queue
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to open registry subkey
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to get registry value InstallPath
(01) 2016-06-14 10:14:25 Slp: ngen command to be used from .Net Framework Directory: C:\Windows\Microsoft.NET\Framework\v4.0.30319(01) 2016-06-14 10:14:25 Slp: Running: C:\Windows\Microsoft.NET\Framework\v4.0.30319gen.exe queue pause
(07) 2016-06-14 10:14:25 Slp: Microsoft (R) CLR Native Image Generator - Version 4.0.30319.33440
(07) 2016-06-14 10:14:25 Slp: Copyright (c) Microsoft Corporation. All rights reserved.
(07) 2016-06-14 10:14:25 Slp:
(07) 2016-06-14 10:14:25 Slp: The .NET Runtime Optimization Service is started and paused.
(01) 2016-06-14 10:14:25 Slp: Process returned 0
(01) 2016-06-14 10:14:25 Slp: Completed Action: InitializeMsiAction, returned True
(01) 2016-06-14 10:14:25 Slp: ----------------------------------------------------------------------
(01) 2016-06-14 10:14:25 Slp: Running Action: MsiTimingAction
(01) 2016-06-14 10:14:25 Slp: ----------------------------------------------------------------------
(01) 2016-06-14 10:14:25 Slp: Running Action: Install_MsMpi_Cpu64_Action
(01) 2016-06-14 10:14:25 Slp: Sco: File 'C:\Downloads\SQL 2016 Developer Ed RTM x64 - for Slipstream\x64\setup\x64\MSMpiSetup.exe' does not exist
(01) 2016-06-14 10:14:25 Slp: Checkpoint: PREINSTALL_MSMPI_CPU64_ACTION
(01) 2016-06-14 10:14:25 Slp: Sco: Waiting for service 'msiserver' to accept the stop request.
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to open SC Manager
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to open service handle for service msiserver
(01) 2016-06-14 10:14:25 Slp: Invoking QueryServiceStatus Win32 API
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to close service handle for service msiserver
(01) 2016-06-14 10:14:25 Slp: Sco: Attempting to close SC Manager
(01) 2016-06-14 10:14:25 Slp: Running: C:\Downloads\SQL 2016 Developer Ed RTM x64 - for Slipstream\x64\setup\MSMpiSetup.exe -unattend -force -appendlog -verbose -log "C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160614_094521\MsMpi_Cpu64_1.log"
(01) 2016-06-14 10:14:29 Slp: Process returned 0
(01) 2016-06-14 10:14:29 Slp: Checkpoint: INSTALL_MSMPI_CPU64_ACTION
(01) 2016-06-14 10:14:29 Slp: Completed Action: Install_MsMpi_Cpu64_Action, returned True
(01) 2016-06-14 10:14:29 Slp: Attempting to pause the 32 bit ngen queue for x64
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to open registry subkey
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to get registry value InstallPath
(01) 2016-06-14 10:14:29 Slp: ngen command to be used from .Net Framework Directory: C:\Windows\Microsoft.NET\Framework\v4.0.30319(01) 2016-06-14 10:14:29 Slp: Running: C:\Windows\Microsoft.NET\Framework\v4.0.30319gen.exe queue pause
(03) 2016-06-14 10:14:29 Slp: Microsoft (R) CLR Native Image Generator - Version 4.0.30319.33440
(03) 2016-06-14 10:14:29 Slp: Copyright (c) Microsoft Corporation. All rights reserved.
(03) 2016-06-14 10:14:29 Slp:
(03) 2016-06-14 10:14:29 Slp: The .NET Runtime Optimization Service is started and paused.
(01) 2016-06-14 10:14:29 Slp: Process returned 0
(01) 2016-06-14 10:14:29 Slp: Attempting to pause the 64 bit ngen queue
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to open registry subkey
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\NET Framework Setup\NDP\v4\Full
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to get registry value InstallPath
(01) 2016-06-14 10:14:29 Slp: ngen command to be used from .Net Framework Directory: C:\Windows\Microsoft.NET\Framework\v4.0.30319(01) 2016-06-14 10:14:29 Slp: Running: C:\Windows\Microsoft.NET\Framework\v4.0.30319gen.exe queue pause
(06) 2016-06-14 10:14:29 Slp: Microsoft (R) CLR Native Image Generator - Version 4.0.30319.33440
(06) 2016-06-14 10:14:29 Slp: Copyright (c) Microsoft Corporation. All rights reserved.
(06) 2016-06-14 10:14:29 Slp:
(06) 2016-06-14 10:14:29 Slp: The .NET Runtime Optimization Service is started and paused.
(01) 2016-06-14 10:14:29 Slp: Process returned 0
(01) 2016-06-14 10:14:29 Slp: ----------------------------------------------------------------------
(01) 2016-06-14 10:14:29 Slp: Running Action: Install_DotNet46_Cpu64_Action
(01) 2016-06-14 10:14:29 Slp: Sco: File 'C:\Downloads\SQL 2016 Developer Ed RTM x64 - for Slipstream\redist\DotNetFrameworks\x64\dotNetFx46-x86-x64-AllOS.exe' does not exist
(01) 2016-06-14 10:14:29 Slp: Checkpoint: PREINSTALL_DOTNET46_CPU64_ACTION
(01) 2016-06-14 10:14:29 Slp: Sco: Waiting for service 'msiserver' to accept the stop request.
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to open SC Manager
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to open service handle for service msiserver
(01) 2016-06-14 10:14:29 Slp: Invoking QueryServiceStatus Win32 API
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to close service handle for service msiserver
(01) 2016-06-14 10:14:29 Slp: Sco: Attempting to close SC Manager
(01) 2016-06-14 10:14:29 Slp: Running: C:\Downloads\SQL 2016 Developer Ed RTM x64 - for Slipstream\redist\DotNetFrameworks\dotNetFx46-x86-x64-AllOS.exe /chainingpackage SQL_Server /norestart /q /log "C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\20160614_094521\DotNet46_Cpu64_1.log" /CEIPconsent
(01) 2016-06-14 10:17:02 Slp: Process returned 3010
(01) 2016-06-14 10:17:02 Slp: .NET 4.0 installation succeeded but reboot is required.
(01) 2016-06-14 10:17:02 Slp: Sco: Attempting to stop service msiserver
(01) 2016-06-14 10:17:02 Slp: Sco: Waiting for service 'msiserver' to accept the stop request.
June 28, 2016 at 1:00 pm
The MS resolution to this issue in case anyone else has this issue is as follows:
Resolution: We were able to resolve this for you by completing these steps:
• Turn off UAC during the setup
• Check local security policies / User Right Assignments / Privileges needs to be assigned to the SQL Setup account:
Act as Part of the Operating System
Lock Pages In Memory
Log on as a Batch Job
Log on as a Service
Replace a Process Level Token
Manage auditing and security log
Bypass Traverse Checking
Debug programs
• Reboot the server
• Uninstall the failed features
• Repair the instance
• Add new features and for OLAP initially have the service account start under the setup user account.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply