我们有一台 Windows 2012 R2 服务器，并且想要运行 MS SQL Server 2012。
似乎有人不久前尝试过安装，但由于 SQL Server 没有显示在“所有程序”下，因此安装不正确。
我们尝试修复或卸载现有版本并重新安装。但是，由于此错误，修复/安装失败。
异常摘要：以下是异常堆栈，按最外层到最内层的顺序列出异常，内层异常正在缩进
异常类型：
Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException
Message:
'.', hexadecimal value 0x00, is an invalid character. Line 1, position 22777.
HResult : 0x84b10001
FacilityCode : 1201 (4b1)
ErrorCode : 1 (0001)
Data:
HelpLink.EvtType = 0x066FCAFD@0x5539C151
DisableWatson = true
Stack:
at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.LoadXmlDocument(String xml, XmlSchema schema, String namespacePrefix, String namespaceUri, String rootPath)
at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.LoadXmlDocument(XmlDocument doc, XmlSchema schema, String namespacePrefix, String namespaceUri, String rootPath)
at Microsoft.SqlServer.Chainer.Infrastructure.SqlDiscoveryDatastoreInterface.LoadData(IEnumerable`1 machineNames, String discoveryDocRootPath, String clusterDiscoveryDocRootPath)
at Microsoft.SqlServer.Configuration.SetupExtension.RunDiscoveryAction.ExecuteAction(String actionId)
at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)
Inner exception type: System.Xml.XmlException
Message:
'.', hexadecimal value 0x00, is an invalid character. Line 1, position 22777.
HResult : 0x80131940
Stack:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
at System.Xml.XmlTextReaderImpl.ParseNumericCharRefInline(Int32 startPos, Boolean expand, BufferBuilder internalSubsetBuilder, Int32& charCount, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.ParseNumericCharRef(Boolean expand, BufferBuilder internalSubsetBuilder, EntityType& entityType)
at System.Xml.XmlTextReaderImpl.HandleEntityReference(Boolean isInAttributeValue, EntityExpandType expandType, Int32& charRefEndPos)
at System.Xml.XmlTextReaderImpl.ParseAttributeValueSlow(Int32 curPos, Char quoteChar, NodeData attr)
at System.Xml.XmlTextReaderImpl.ParseAttributes()
at System.Xml.XmlTextReaderImpl.ParseElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
at System.Xml.XmlDocument.Load(XmlReader reader)
at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.LoadXmlDocument(String xml, XmlSchema schema, String namespacePrefix, String namespaceUri, String rootPath)
详细日志
(01) 2018-09-05 16:28:04 Slp: at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(TextWriter statusStream, ISequencedAction actionToRun, ServiceContainer context)
(01) 2018-09-05 16:28:04 Slp: Inner exception type: System.Xml.XmlException
(01) 2018-09-05 16:28:04 Slp: Message:
(01) 2018-09-05 16:28:04 Slp: '.', hexadecimal value 0x00, is an invalid character. Line 1, position 22777.
(01) 2018-09-05 16:28:04 Slp: HResult : 0x80131940
(01) 2018-09-05 16:28:04 Slp: Stack:
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.Throw(Exception e)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.ThrowInvalidChar(Int32 pos, Char invChar)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.ParseNumericCharRefInline(Int32 startPos, Boolean expand, BufferBuilder internalSubsetBuilder, Int32& charCount, EntityType& entityType)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.ParseNumericCharRef(Boolean expand, BufferBuilder internalSubsetBuilder, EntityType& entityType)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.HandleEntityReference(Boolean isInAttributeValue, EntityExpandType expandType, Int32& charRefEndPos)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.ParseAttributeValueSlow(Int32 curPos, Char quoteChar, NodeData attr)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.ParseAttributes()
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.ParseElement()
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlTextReaderImpl.ParseElementContent()
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)
(01) 2018-09-05 16:28:04 Slp: at System.Xml.XmlDocument.Load(XmlReader reader)
(01) 2018-09-05 16:28:04 Slp: at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.LoadXmlDocument(String xml, XmlSchema schema, String namespacePrefix, String namespaceUri, String rootPath)
(01) 2018-09-05 16:33:27 Slp: Watson Bucket 2
Original Parameter Values
(01) 2018-09-05 16:33:27 Slp: Parameter 0 : SQL Server 2012@RTM@
(01) 2018-09-05 16:33:27 Slp: Parameter 1 : Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.LoadXmlDocument
(01) 2018-09-05 16:33:27 Slp: Parameter 2 : System.Xml.XmlTextReaderImpl.Throw
(01) 2018-09-05 16:33:27 Slp: Parameter 3 : Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException@1201@1
(01) 2018-09-05 16:33:27 Slp: Parameter 4 : System.Xml.XmlException@-2146232000
(01) 2018-09-05 16:33:27 Slp: Parameter 5 : RunLocalDiscoveryAction
(01) 2018-09-05 16:33:27 Slp:
Final Parameter Values
(01) 2018-09-05 16:33:27 Slp: Parameter 0 : SQL Server 2012@RTM@
(01) 2018-09-05 16:33:27 Slp: Parameter 1 : 0xDBE3EAAC
(01) 2018-09-05 16:33:27 Slp: Parameter 2 : 0x066FCAFD
(01) 2018-09-05 16:33:27 Slp: Parameter 3 : 0xDF039760@1201@1
(01) 2018-09-05 16:33:27 Slp: Parameter 4 : 0x5539C151
(01) 2018-09-05 16:33:27 Slp: Parameter 5 : RunLocalDiscoveryAction
(01) 2018-09-05 16:33:27 Slp: Sco: Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20180905_162751\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_
(01) 2018-09-05 16:33:27 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20180905_162751\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_
(01) 2018-09-05 16:33:28 Slp: Sco: Attempting to write hklm registry key MSSQLServer to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20180905_162751\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_
(01) 2018-09-05 16:33:28 Slp: Sco: Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20180905_162751\Registry_SOFTWARE_Wow6432Node_Microsoft_Microsoft SQL Server.reg_
(01) 2018-09-05 16:33:28 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20180905_162751\Registry_SOFTWARE_Wow6432Node_Microsoft_Windows_CurrentVersion_Uninstall.reg_
(01) 2018-09-05 16:33:28 Slp: Sco: Attempting to write hklm registry key MSSQLServer to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20180905_162751\Registry_SOFTWARE_Wow6432Node_Microsoft_MSSQLServer.reg_
(01) 2018-09-05 16:33:28 Slp: '.', hexadecimal value 0x00, is an invalid character. Line 1, position 22777.
(01) 2018-09-05 16:33:28 Slp: Watson bucket for exception based failure has been created
(01) 2018-09-05 16:33:28 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
(01) 2018-09-05 16:33:28 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\110
(01) 2018-09-05 16:33:28 Slp: Sco: Attempting to get registry value EnableErrorReporting
(01) 2018-09-05 16:33:28 Slp: WER: Successfully read app consent from registry Software\Microsoft\Microsoft SQL Server\110\EnableErrorReporting=0.
(01) 2018-09-05 16:33:28 Slp: WER: Application level consent value '0' was mapped to consent status 'WerConsentDenied'
(01) 2018-09-05 16:33:28 Slp: WER: Result of the submission:: 'WerDisabled'
(01) 2018-09-05 16:33:28 Slp: WER: Submitted 1 of 1 failures to the Watson data repository
(01) 2018-09-05 16:33:29 Slp:
(01) 2018-09-05 16:33:29 Slp: ----------------------------------------------------------------------
(01) 2018-09-05 16:33:29 Slp:
(01) 2018-09-05 16:33:29 Slp: Error result: -2068774911
(01) 2018-09-05 16:33:29 Slp: Result facility code: 1201
(01) 2018-09-05 16:33:29 Slp: Result error code: 1
(01) 2018-09-05 16:33:29 Slp: SQM Service: Sqm does not have active session.
服务器上安装了以下 SQL Server 相关组件：
- SQL Server 2012 的 SQL Server 系统 CLR 类型
- SQL Server 数据工具构建实用程序
- SQL Server Compact 4.0 SP1 x64 简体中文
- SQL Server 2012 T-SQL 语言服务
- SQL 服务器 2012 Transact-SQL ScriptDom
- SQL Server 2012 Transact-SQL 编译器服务
- SQL Server 2012 安装程序（英语）
- SQL Server 2012 本机客户端
- SQL Server 2012 管理对象
- SQL Server 2012 Express 本地数据库
- SQL Server 2012 数据层应用框架
- SQL Server 2012 命令行实用程序
- SQL Server 2012（64 位）
- SQL 服务器 2012
有人能帮我们解决这个问题吗？
答案1
我们尝试删除所有与 MSSQL 相关的组件，但 SQL Server 2012 无法卸载，并出现相同错误。由于版本无关紧要，我们在删除 Program Files 下的注册表项和文件后安装了 SQL Server 2017。2017 已成功安装。再次感谢大家的建议！