SQL Server 2012 R2升级到SQL Server 2016无法正常启动数据库服务解决方案

Action required:
Use the following information to resolve the error, and then try the setup process again.Feature failure reason:
An error occurred during the setup process of the feature.Error details:
§ Error installing SQL Server Database Engine Services Instance Features
The service did not respond to the start or control request in a timely fashion.
Error code: 0x80004005
Visit http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1711.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325 to get help on troubleshooting.
Warning details:
§ Missing or unspecified settings that were configured to default values:
Service SID support has been enabled on the service.

Windows cannot access the file for one of the following reasons: there is a problem with the network connection, the disk that the file is stored on, or the storage drivers installed on this computer; or the disk is missing. Windows closed the program SQL Server Windows NT - Bit because of this error.Program: SQL Server Windows NT - Bit
File: The error value is listed in the Additional Data section.
User Action
. Open the file again. This situation might be a temporary problem that corrects itself when the program runs again.
. If the file still cannot be accessed and
- It is on the network, your network administrator should verify that there is not a problem with the network and that the server can be contacted.
- It is on a removable disk, for example, a floppy disk or CD-ROM, verify that the disk is fully inserted into the computer.
. Check and repair the file system by running CHKDSK. To run CHKDSK, click Start, click Run, type CMD, and then click OK. At the command prompt, type CHKDSK /F, and then press ENTER.
. If the problem persists, restore the file from a backup copy.
. Determine whether other files on the same disk can be opened. If not, the disk might be damaged. If it is a hard disk, contact your administrator or computer hardware vendor for further assistance.Additional Data
Error value:
Disk type:

Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -
Start time: -- ::
End time: -- ::
Requested action: RepairSetup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: Use the following information to resolve the error, and then try the setup process again.
Next step for FullText: Use the following information to resolve the error, and then try the setup process again.
Next step for AS: Use the following information to resolve the error, and then try the setup process again.Machine Properties:
Machine name: SQL
Machine processor count:
OS version: Microsoft Windows Server Datacenter (6.2.)
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: Bit
OS clustered: NoProduct features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
SQL Server MSSQL2 MSSQL11.MSSQL2 Database Engine Services Enterprise Edition 11.2.5058.0 No Yes
SQL Server MSSQL2 MSSQL11.MSSQL2 Full-Text and Semantic Extractions for Search Enterprise Edition 11.2.5058.0 No Yes
SQL Server SSMS Enterprise Edition 11.2.5058.0 No Yes
SQL Server Adv_SSMS Enterprise Edition 11.2.5058.0 No Yes
SQL Server MSSQLSERVER MSSQL13.MSSQLSERVER Database Engine Services Enterprise Edition 13.0.1601.5 No Yes
SQL Server MSSQLSERVER MSSQL13.MSSQLSERVER Full-Text and Semantic Extractions for Search Enterprise Edition 13.0.1601.5 No Yes
SQL Server MSSQLSERVER MSAS13.MSSQLSERVER Analysis Services Enterprise Edition 13.0.1601.5 No Yes
SQL Server MSSQLSERVER MSRS13.MSSQLSERVER Reporting Services - Native Enterprise Edition 13.0.1601.5 No Yes Package properties:
Description: Microsoft SQL Server
ProductName: SQL Server
Type: RTM
Version:
SPLevel:
Installation location: I:\x64\setup\
Installation edition: EnterpriseUser Input Settings:
ACTION: Repair
AGTDOMAINGROUP: <empty>
AGTSVCACCOUNT: NT Service\SQLSERVERAGENT
AGTSVCPASSWORD: <empty>
AGTSVCSTARTUPTYPE: Manual
ASCONFIGDIR: Config
ASSVCACCOUNT: NT Service\MSSQLServerOLAPService
ASSVCPASSWORD: <empty>
ASTELSVCACCT: NT Service\SSASTELEMETRY
ASTELSVCPASSWORD: <empty>
ASTELSVCSTARTUPTYPE: Automatic
CLTSTARTUPTYPE:
CLTSVCACCOUNT: <empty>
CLTSVCPASSWORD: <empty>
CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\\Setup Bootstrap\Log\20180723_092704\ConfigurationFile.ini
CTLRSTARTUPTYPE:
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
ENU: true
EXTSVCACCOUNT: <empty>
EXTSVCPASSWORD: <empty>
FAILOVERCLUSTERGROUP: <empty>
FAILOVERCLUSTERNETWORKNAME: <empty>
FTSVCACCOUNT: NT Service\MSSQLFDLauncher
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTROPENLICENSETERMS: false
INDICATEPROGRESS: false
INSTANCENAME: MSSQLSERVER
ISSVCACCOUNT: NT AUTHORITY\Network Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
ISTELSVCACCT: <empty>
ISTELSVCPASSWORD: <empty>
ISTELSVCSTARTUPTYPE:
MRCACHEDIRECTORY:
QUIET: false
QUIETSIMPLE: false
SQLSVCACCOUNT: NT Service\MSSQLSERVER
SQLSVCPASSWORD: <empty>
SQLTELSVCACCT: NT Service\SQLTELEMETRY
SQLTELSVCPASSWORD: <empty>
SQLTELSVCSTARTUPTYPE: Automatic
SUPPRESSPRIVACYSTATEMENTNOTICE: false
UIMODE: Normal
X86: false Configuration file: C:\Program Files\Microsoft SQL Server\\Setup Bootstrap\Log\20180723_092704\ConfigurationFile.iniDetailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x80004005
Error description: The service did not respond to the start or control request in a timely fashion.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1711.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325 Feature: Full-Text and Semantic Extractions for Search
Status: Failed: see logs for details
Reason for failure: An error occurred for a dependency of the feature causing the setup process for the feature to fail.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x80004005
Error description: The service did not respond to the start or control request in a timely fashion.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1711.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325 Feature: Reporting Services - Native
Status: Passed Feature: Analysis Services
Status: Failed: see logs for details
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, and then try the setup process again.
Component name: SQL Server Analysis Services
Component error code: 0x84BB0001
Error description: The service did not respond to the start or control request in a timely fashion.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=13.0.1711.0&EvtType=0xDC112D1C%400xDC80C325&EvtType=0xDC112D1C%400xDC80C325 Feature: SQL Browser
Status: Passed Feature: SQL Writer
Status: Passed Feature: SQL Client Connectivity
Status: Passed Feature: SQL Client Connectivity SDK
Status: Passed Feature: Setup Support Files
Status: PassedRules with failures:Global rules:There are no scenario-specific rules.Rules report file: C:\Program Files\Microsoft SQL Server\\Setup Bootstrap\Log\20180723_092704\SystemConfigurationCheck_Report.htmThe following warnings were encountered while configuring settings on your SQL Server. These resources / settings were missing or invalid so default values were used in recreating the missing resources. Please review to make sure they don’t require further customization for your applications:Service SID support has been enabled on the service.

() -- :: Slp: The configuration failure category of current exception is ConfigurationFailure
() -- :: Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigRC and scenario ConfigRC.
() -- :: Slp: System.ComponentModel.Win32Exception (0x80004005): The service did not respond to the start or control request in a timely fashion.
() -- :: Slp: at Microsoft.SqlServer.Configuration.Sco.Service.StartService(String[] startParams)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(String[] parameters, Boolean withFailpoint)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.UpgradeSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean fShutdown)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Upgrade_ConfigRC(Version fromVersion, EffectiveProperties properties, Boolean shutdownRightAway)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.RepairFailedUpgrade(ConfigActionTiming timing, Dictionary` actionData)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Repair(ConfigActionTiming timing, Dictionary` actionData, PublicConfigurationBase spcb)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary` actionData, PublicConfigurationBase spcbCurrent)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary` actionData, PublicConfigurationBase spcbCurrent)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
() -- :: Slp: The following is an exception stack listing the exceptions in outermost to innermost order
() -- :: Slp: Inner exceptions are being indented
() -- :: Slp:
() -- :: Slp: Exception type: System.ComponentModel.Win32Exception
() -- :: Slp: Message:
() -- :: Slp: The service did not respond to the start or control request in a timely fashion.
() -- :: Slp:
() -- :: Slp: HResult : 0x80004005
() -- :: Slp: Error :
() -- :: Slp: Data:
() -- :: Slp: SQL.Setup.FailureCategory = ConfigurationFailure
() -- :: Slp: WatsonConfigActionData = REPAIR@CONFIGRC@SQL_ENGINE_CORE_INST
() -- :: Slp: WatsonExceptionFeatureIdsActionData = System.String[]
() -- :: Slp: Stack:
() -- :: Slp: at Microsoft.SqlServer.Configuration.Sco.Service.StartService(String[] startParams)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StartSqlServer(String[] parameters, Boolean withFailpoint)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.UpgradeSQLServerSystemDatabases(EffectiveProperties properties, Boolean isConfiguringTemplateDBs, Boolean fShutdown)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Upgrade_ConfigRC(Version fromVersion, EffectiveProperties properties, Boolean shutdownRightAway)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.RepairFailedUpgrade(ConfigActionTiming timing, Dictionary` actionData)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineDBStartConfig.Repair(ConfigActionTiming timing, Dictionary` actionData, PublicConfigurationBase spcb)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary` actionData, PublicConfigurationBase spcbCurrent)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary` actionData, PublicConfigurationBase spcbCurrent)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
() -- :: Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
() -- :: Slp: Watson Bucket
Original Parameter Values

sqlservr.exe -m

!analyze -v

*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************Unable to load image C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn\sqldk.dll, Win32 error 0n2
*** WARNING: Unable to verify timestamp for sqldk.dll
GetUrlPageData2 (WinHttp) failed: .KEY_VALUES_STRING: STACKHASH_ANALYSIS: TIMELINE_ANALYSIS: Timeline: !analyze.Start
Name: <blank>
Time: --23T06::.719Z
Diff: mSecTimeline: Dump.Current
Name: <blank>
Time: --23T05::.0Z
Diff: mSecTimeline: Process.Start
Name: <blank>
Time: --23T05::.0Z
Diff: mSecTimeline: OS.Boot
Name: <blank>
Time: --23T02::.0Z
Diff: mSecDUMP_CLASS: DUMP_QUALIFIER: CONTEXT: (.ecxr)
rax= rbx=00000000000000c4 rcx=00000000ffffffff
rdx= rsi=000000000000009d rdi=000007faeafbce48
rip=000007fb0bd831f3 rsp=0000001803fef100 rbp=
r8= r9= r10=
r11=000007faeb398310 r12=000007faeab52ab0 r13=
r14=000007faeab50000 r15=
iopl= nv up ei pl zr na po nc
cs= ss=002b ds=002b es=002b fs= gs=002b efl=
msvcr120!log10+0x313:
000007fb`0bd831f3 c5e173d034 vpsrlq xmm3,xmm0,34h
Resetting default scopeFAULTING_IP:
msvcr120!log10+ [f:\dd\vctools\crt\fpw32\tran\amd64\log10.asm @ ]
000007fb`0bd831f3 c5e173d034 vpsrlq xmm3,xmm0,34hEXCEPTION_RECORD: (.exr -)
ExceptionAddress: 000007fb0bd831f3 (msvcr120!log10+0x0000000000000313)
ExceptionCode: c000001d (Illegal instruction)
ExceptionFlags:
NumberParameters: DEFAULT_BUCKET_ID: ILLEGAL_INSTRUCTIONERROR_CODE: (NTSTATUS) 0xc000001d - {EXCEPTION} Illegal Instruction An attempt was made to execute an illegal instruction.EXCEPTION_CODE: (NTSTATUS) 0xc000001d - {EXCEPTION} Illegal Instruction An attempt was made to execute an illegal instruction.EXCEPTION_CODE_STR: c000001dWATSON_BKT_PROCSTAMP: 5724ae45WATSON_BKT_PROCVER: 2015.130.1601.5WATSON_BKT_MODULE: msvcr120.dllWATSON_BKT_MODSTAMP: 56bc00d3WATSON_BKT_MODOFFSET: 931f3WATSON_BKT_MODVER: 12.0.40649.5MODULE_VER_PRODUCT: Microsoft? Visual Studio? BUILD_VERSION_STRING: 6.2.9200.16384 (win8_rtm.-)MODLIST_WITH_TSCHKSUM_HASH: c6a5860b5b55160212c48b9276e6eba3de41b840MODLIST_SHA1_HASH: 8ff0cba4b013ab435c80aab51efa92ac767733beNTGLOBALFLAG: PROCESS_BAM_CURRENT_THROTTLED: PROCESS_BAM_PREVIOUS_THROTTLED: APPLICATION_VERIFIER_FLAGS: PRODUCT_TYPE: SUITE_MASK: DUMP_FLAGS: d96DUMP_TYPE: PROCESS_NAME: unknownANALYSIS_SESSION_HOST: JUNCHU-XPSANALYSIS_SESSION_TIME: -- ::15.0719ANALYSIS_VERSION: 10.0.17712.1000 amd64freTHREAD_ATTRIBUTES:
OS_LOCALE: ENUBUGCHECK_STR: ILLEGAL_INSTRUCTIONPRIMARY_PROBLEM_CLASS: ILLEGAL_INSTRUCTIONPROBLEM_CLASSES: ID: [0n321]
Type: [@APPLICATION_FAULT_STRING]
Class: Primary
Scope: DEFAULT_BUCKET_ID (Failure Bucket ID prefix)
BUCKET_ID
Name: Omit
Data: Add
String: [ILLEGAL_INSTRUCTION]
PID: [Unspecified]
TID: [Unspecified]
Frame: []LAST_CONTROL_TRANSFER: from 000007faeabdb342 to 000007fb0bd831f3STACK_TEXT:
`03fef100 000007fa`eabdb342 : `000000dd 000007fa`ea7e2679 `7c0b2ebe 000007fb`1906c113 : msvcr120!log10+0x313
`03fef160 000007fb`0bd1276b : `000000c4 ` `0000009d 000007fb`1905a57e : sqltses!InitializeRoundArrays+0x42
`03fef250 000007fa`eab869d6 : ` `03fef8d0 `03fef8d0 000007fa`ea698920 : msvcr120!_initterm+0x3f
`03fef280 000007fa`eab52b72 : ` `03fef670 ` 000007fa`eab52ab0 : sqltses!CRT_INIT+0x1df
`03fef2c0 000007fb`1905b9be : 000007fa`eab50000 `03fef8d0 ` `041551e0 : sqltses!DllMainCRTStartup+0xb6
`03fef300 000007fb`1907b3fc : `04154f10 000007fa`eab50000 `04154e90 `04154df0 : ntdll!LdrpCallInitRoutine+0x3e
`03fef350 000007fb`1907a88b : `04154f10 `04154f01 `03fef400 000007fb`190c9dd0 : ntdll!LdrpInitializeNode+0x192
`03fef450 000007fb`1907e74e : ` ` `03fef4d0 000007fb`1906aa52 : ntdll!LdrpInitializeGraph+0x6f
`03fef490 000007fb`1907e74e : ` `041523b0 `03fef510 ` : ntdll!LdrpInitializeGraph+0x8d
`03fef4d0 000007fb` : ` ` `03fef550 ` : ntdll!LdrpInitializeGraph+0x8d
`03fef510 000007fb` : `03fef8d0 000007fb`19083ce3 ` 000007f7`7d8b8000 : ntdll!LdrpInitializeProcess+0x1a1b
`03fef810 000007fb`1906c1ae : `03fef8d0 ` 000007f7`7d8b8000 ` : ntdll!_LdrpInitialize+0x1565e
`03fef880 ` : ` ` ` ` : ntdll!LdrInitializeThunk+0xeFAILED_INSTRUCTION_ADDRESS:
msvcr120!log10+ [f:\dd\vctools\crt\fpw32\tran\amd64\log10.asm @ ]
000007fb`0bd831f3 c5e173d034 vpsrlq xmm3,xmm0,34hTHREAD_SHA1_HASH_MOD_FUNC: 4bb6d88aecf5843ccdb8c6a0528c256becdc603eTHREAD_SHA1_HASH_MOD_FUNC_OFFSET: 1732d2863928a4e53da11554f7406e3cc67c47ddTHREAD_SHA1_HASH_MOD: b5fd421a131c6f1c77c4a87353281934f433e4d5FOLLOWUP_IP:
msvcr120!log10+ [f:\dd\vctools\crt\fpw32\tran\amd64\log10.asm @ ]
000007fb`0bd831f3 c5e173d034 vpsrlq xmm3,xmm0,34hFAULT_INSTR_CODE: d073e1c5FAULTING_SOURCE_LINE: f:\dd\vctools\crt\fpw32\tran\amd64\log10.asmFAULTING_SOURCE_FILE: f:\dd\vctools\crt\fpw32\tran\amd64\log10.asmFAULTING_SOURCE_LINE_NUMBER: FAULTING_SOURCE_CODE:
No source found for 'f:\dd\vctools\crt\fpw32\tran\amd64\log10.asm'SYMBOL_STACK_INDEX: SYMBOL_NAME: msvcr120!log10+FOLLOWUP_NAME: MachineOwnerMODULE_NAME: msvcr120IMAGE_NAME: msvcr120.dllDEBUG_FLR_IMAGE_TIMESTAMP: 56bc00d3STACK_COMMAND: dt ntdll!LdrpLastDllInitializer BaseDllName ; dt ntdll!LdrpFailureData ; ~0s ; .ecxr ; kbFAILURE_BUCKET_ID: ILLEGAL_INSTRUCTION_c000001d_msvcr120.dll!log10BUCKET_ID: ILLEGAL_INSTRUCTION_BAD_IP_msvcr120!log10+FAILURE_EXCEPTION_CODE: c000001dFAILURE_IMAGE_NAME: msvcr120.dllBUCKET_ID_IMAGE_STR: msvcr120.dllFAILURE_MODULE_NAME: msvcr120BUCKET_ID_MODULE_STR: msvcr120FAILURE_FUNCTION_NAME: log10BUCKET_ID_FUNCTION_STR: log10BUCKET_ID_OFFSET: BUCKET_ID_MODTIMEDATESTAMP: 56bc00d3BUCKET_ID_MODCHECKSUM: f6c2bBUCKET_ID_MODVER_STR: 12.0.40649.5BUCKET_ID_PREFIX_STR: ILLEGAL_INSTRUCTION_BAD_IP_FAILURE_PROBLEM_CLASS: ILLEGAL_INSTRUCTIONFAILURE_SYMBOL_NAME: msvcr120.dll!log10WATSON_STAGEONE_URL: http://watson.microsoft.com/StageOne/unknown/2015.130.1601.5/5724ae45/msvcr120.dll/12.0.40649.5/56bc00d3/c000001d/000931f3.htm?Retriage=1TARGET_TIME: --23T05::.000ZOSBUILD: OSSERVICEPACK: SERVICEPACK_NUMBER: OS_REVISION: OSPLATFORM_TYPE: x64OSNAME: Windows OSEDITION: Windows Server TerminalServer DataCenter SingleUserTSUSER_LCID: OSBUILD_TIMESTAMP: -- ::BUILDDATESTAMP_STR: -BUILDLAB_STR: win8_rtmBUILDOSVER_STR: 6.2.9200.16384ANALYSIS_SESSION_ELAPSED_TIME: 591bANALYSIS_SOURCE: UMFAILURE_ID_HASH_STRING: um:illegal_instruction_c000001d_msvcr120.dll!log10FAILURE_ID_HASH: {5866d3bb-feda-328f-6d8f-83f8512752ce}Followup: MachineOwner
---------