Sql-Server-2008

任何版本 2008 r2 express edition 的 SQL SERVER 安裝錯誤

  • May 8, 2020

從昨天開始我一直在為這個錯誤而苦苦掙扎，首先我的 SSMS 由於某種原因過期了，我無法讓它工作。我無法解除安裝與 SQL Server 相關的所有軟體及其共享組件，我已成功刪除它，並且在重新安裝 MS Sql server 2008 r2 express 和 SSMS 後，我遇到了同樣的錯誤，您的試用版已過期。

最後，當我按照其中一篇文章的建議使用 CClearner 刪除它時，我通過強​​制 MS SQL SERVER 及其組件搞砸了一切。

現在我無法安裝任何版本的 MS SQL Server，無論是 SQL Server 2008、MS SQL SERVER 2008 Express 還是 MS SQL SERVER 2008 Re Express 版本，我都會收到所有版本的以下消息，如下圖所示\

在此處輸入圖像描述

我不確定該怎麼做，要麼重新安裝 Windows 7，要麼嘗試進一步搜尋我更喜歡的解決方案，因為我的系統上安裝了多個軟體，並且安裝所有軟體需要一天左右的時間。

我將不勝感激有關此的幫助

在文件夾下記錄錯誤報告器C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

摘要.txt

Overall summary:
 Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
 Exit code (Decimal):           -2068643839
 Exit facility code:            1203
 Exit error code:               1
 Exit message:                  Method not found: 'Void Microsoft.SqlServer.Configuration.MsiExtension.PackageInstallProperty.set_FailedPatchedFeatureList(System.Collections.Generic.List`1<System.String>)'.
 Start time:                    2012-11-18 16:32:54
 End time:                      2012-11-18 16:34:07
 Requested action:              Install
 Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121118_163146\Detail.txt
 Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0x6539C9E6%400x375DE77D

Machine Properties:
 Machine name:                  WEBD
 Machine processor count:       4
 OS version:                    Windows Vista
 OS service pack:               Service Pack 1
 OS region:                     United Kingdom
 OS language:                   English (United States)
 OS architecture:               x86
 Process architecture:          32 Bit
 OS clustered:                  No

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

Package properties:
 Description:                   SQL Server Database Services 2008
 SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
 ProductName:                   SQL2008
 Type:                          RTM
 Version:                       10
 SPLevel:                       0
 Installation location:         c:\1ecd7ad03bd0c2d4ee57a72099f430\x86\setup\
 Installation edition:          EXPRESS

User Input Settings:
 ACTION:                        Install
 ADDCURRENTUSERASSQLADMIN:      False
 AGTSVCACCOUNT:                 <empty>
 AGTSVCPASSWORD:                *****
 AGTSVCSTARTUPTYPE:             Manual
 ASBACKUPDIR:                   Backup
 ASCOLLATION:                   Latin1_General_CI_AS
 ASCONFIGDIR:                   Config
 ASDATADIR:                     Data
 ASDOMAINGROUP:                 <empty>
 ASLOGDIR:                      Log
 ASPROVIDERMSOLAP:              1
 ASSVCACCOUNT:                  <empty>
 ASSVCPASSWORD:                 *****
 ASSVCSTARTUPTYPE:              Automatic
 ASSYSADMINACCOUNTS:            <empty>
 ASTEMPDIR:                     Temp
 BROWSERSVCSTARTUPTYPE:         Disabled
 CONFIGURATIONFILE:             
 CUSOURCE:                      
 ENABLERANU:                    False
 ERRORREPORTING:                False
 FEATURES:                      SQLENGINE,REPLICATION,SNAC_SDK
 FILESTREAMLEVEL:               0
 FILESTREAMSHARENAME:           <empty>
 FTSVCACCOUNT:                  <empty>
 FTSVCPASSWORD:                 *****
 HELP:                          False
 INDICATEPROGRESS:              False
 INSTALLSHAREDDIR:              c:\Program Files\Microsoft SQL Server\
 INSTALLSHAREDWOWDIR:           C:\Program Files\Microsoft SQL Server\
 INSTALLSQLDATADIR:             <empty>
 INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
 INSTANCEID:                    <empty>
 INSTANCENAME:                  <empty>
 ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
 ISSVCPASSWORD:                 *****
 ISSVCSTARTUPTYPE:              Automatic
 NPENABLED:                     0
 PCUSOURCE:                     
 PID:                           *****
 QUIET:                         False
 QUIETSIMPLE:                   False
 RSINSTALLMODE:                 FilesOnlyMode
 RSSVCACCOUNT:                  <empty>
 RSSVCPASSWORD:                 *****
 RSSVCSTARTUPTYPE:              Automatic
 SAPWD:                         *****
 SECURITYMODE:                  <empty>
 SQLBACKUPDIR:                  <empty>
 SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
 SQLSVCACCOUNT:                 <empty>
 SQLSVCPASSWORD:                *****
 SQLSVCSTARTUPTYPE:             Automatic
 SQLSYSADMINACCOUNTS:           <empty>
 SQLTEMPDBDIR:                  <empty>
 SQLTEMPDBLOGDIR:               <empty>
 SQLUSERDBDIR:                  <empty>
 SQLUSERDBLOGDIR:               <empty>
 SQMREPORTING:                  False
 TCPENABLED:                    0
 X86:                           False

 Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121118_163146\ConfigurationFile.ini

Detailed results:
 Feature:                       Database Engine Services
 Status:                        Failed: see logs for details
 MSI status:                    Passed
 Configuration status:          Passed

 Feature:                       SQL Client Connectivity SDK
 Status:                        Failed: see logs for details
 MSI status:                    Passed
 Configuration status:          Passed

 Feature:                       SQL Server Replication
 Status:                        Failed: see logs for details
 MSI status:                    Passed
 Configuration status:          Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121118_163146\SystemConfigurationCheck_Report.htm

Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException
   Message: 
       Method not found: 'Void Microsoft.SqlServer.Configuration.MsiExtension.PackageInstallProperty.set_FailedPatchedFeatureList(System.Collections.Generic.List`1<System.String>)'.
   Data: 
     DisableWatson = true
   Stack: 

       Server stack trace:
       at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.HandleActionException(Exception e, TextWriter logging)
       at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.NotifyOnUnhandledException(Exception e)
       at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionEngine.RunActionQueue()
       at Microsoft.SqlServer.Setup.Chainer.Workflow.Workflow.RunWorkflow(HandleInternalException exceptionHandler)
       at Microsoft.SqlServer.Configuration.BootstrapExtension.ExecuteWorkflowAction.ExecuteAction(String actionId)
       at Microsoft.SqlServer.Configuration.NestedWorkflow.ExecuteWorkflow(ServiceContainer context, String sequencesRootPath, ActionKey sequenceId)
       at Microsoft.SqlServer.Configuration.NestedWorkflow.ExecuteWorkflow(ServiceContainer context, String sequenceId)
       at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.<>c__DisplayClass2.<ExecuteAction>b__0()
       at Microsoft.SqlServer.Configuration.WizardFramework.BlockingWorker.ThreadCallBack(MethodInvoker method)
       at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
       at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

       Exception rethrown at [0]:
       at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
       at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
       at Microsoft.SqlServer.Configuration.WizardFramework.BlockingWorker.WorkerCallback.EndInvoke(IAsyncResult result)
       at Microsoft.SqlServer.Configuration.WizardFramework.BlockingWorker.PerformWork(MethodInvoker method)
       at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.ExecuteAction(String actionName)
       at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageLeft(PageChangeReason reason)
       at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value)
       at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.GoNext()
       at Microsoft.SqlServer.Configuration.WizardFramework.NavigationButtons.nextButton_Click(Object sender, EventArgs e)
       at System.Windows.Forms.Control.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnClick(EventArgs e)
       at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
       at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ButtonBase.WndProc(Message& m)
       at System.Windows.Forms.Button.WndProc(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
       at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   Inner exception type: System.MissingMethodException
       Message: 
               Method not found: 'Void Microsoft.SqlServer.Configuration.MsiExtension.PackageInstallProperty.set_FailedPatchedFeatureList(System.Collections.Generic.List`1<System.String>)'.
       Stack: 
               at Microsoft.SqlServer.Configuration.SetupExtension.SetFeatureConfigStateAction.ExecuteAction(String actionId)
               at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
               at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
               at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

我昨天問過的相關問題SQL Server 2008 R2 Management Studio：“評估期已過”

配置：Window 7 32 位，4GB RAM

SQL Server 2008 R2實際上不支持Windows Vista Service Pack 1 。除了我對真正清除系統中的 2008 R2 的多項建議（再次參見此處和此處的說明）之外，我強烈建議您在重試之前安裝Service Pack 2 。如果您要完全重新安裝您的作業系統，您可能會考慮 Windows 7，它的生命週期更長，並且將繼續支持更現代的 SQL Server 版本。

你看過： http ://www.headcrash.us/blog/2010/11/sql-management-studio-express-install-fails-with-exception/

問題： 在現有 SQL Server 2008 或 SQL Server 2008 R2 安裝之上安裝 SQL Server Management Studio 時，安裝程序可能會失敗並出現以下 .NET Framework 異常，即使 .NET Framework 3.5 和 4.0 已安裝在目標機器：

解析度： 解析度

在以下目錄中刪除有問題的 user.config 文件：

C:\[UserAccountName]\AppData\Microsoft_Corporation\
LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\

重新啟動安裝程序並註意將使用 System.Configuration 程序集版本號的更正設置重新創建已刪除的配置文件。

引用自：https://dba.stackexchange.com/questions/28894

相關問答

Sql-Server-2008

設置 SQL Server 2008 R2

  • August 6, 2015
檢視問答
Sql-Server

SQL Server 安裝選擇

  • December 9, 2012
檢視問答
Sql-Server

SQL Server 2008 R2 64位修復錯誤

  • May 3, 2012
檢視問答
Sql-Server

當 ANSI_WARNINGS 關閉時，即使使用 nvarchar，也無法將其插入到我的特殊字元表中

  • August 18, 2022
檢視問答
Sql-Server

為什麼 SERIALIZABLE 級別不會為 SQL Server 中的其他會話鎖定表

  • August 12, 2022
檢視問答
Sql-Server

SQL Server 使用的總記憶體（64 位）

  • March 14, 2022
檢視問答