SQLServer安装完成但失败,数据库引擎,server复制等安装失败的解决办法

安装SQL时,计算机名不能和windows系统登录用户名一致,否则安装就会出现上面提到的权限问题,从而导致安装失败。

安装时候确保防火墙已关闭。

 

这些都没问题后重新安装即可。

上述问题和解决方法是本人安装时候遇到的,已安装成功。

此方法仅代表这个问题的一种解决办法,如有不足敬请谅解。

![图片说明](https://img-ask.csdn.net/upload/202005/22/1590161383_493872.png) 安装到最后总是失败,日志如下,希望能有大佬看看 Overall summary: Final result: 失败: 请查看下面的详细信息 Exit code (Decimal): -2068052614 Start time: 2020-05-22 23:17:31 End time: 2020-05-22 23:17:57 Requested action: Install Machine Properties: Machine name: LAPTOP-I9SCFVLK Machine processor count: 12 OS version: Microsoft Windows 10 家庭中文版 (10.0.17763) OS service pack: OS region: 中国 OS language: 中文(中国) OS architecture: x64 Process architecture: 64 位 OS clustered: 否 Product features discovered: Product Instance Instance ID Feature Language Edition Version Clustered Configured Package properties: Description: Microsoft SQL Server 2019 ProductName: SQL Server 2019 Type: RTM Version: 15 SPLevel: 0 Installation location: D:\SQL2019\Evaluation_CHS\x64\setup\ Installation edition: Evaluation Product Update Status: 用户已选择不包括产品更新。 用户输入设置: ACTION: Install ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT: <空> AGTSVCPASSWORD: <空> AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR: Config ASDATADIR: Data ASLOGDIR: Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: TABULAR ASSVCACCOUNT: <空> ASSVCPASSWORD: <空> ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: <空> ASTELSVCACCT: <空> ASTELSVCPASSWORD: <空> ASTELSVCSTARTUPTYPE: 0 ASTEMPDIR: Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: <空> CLTRESULTDIR: <空> CLTSTARTUPTYPE: 0 CLTSVCACCOUNT: <空> CLTSVCPASSWORD: <空> CLTWORKINGDIR: <空> COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200522_231731\ConfigurationFile.ini CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT: <空> CTLRSVCPASSWORD: <空> CTLRUSERS: <空> ENABLERANU: false ENU: false EXTSVCACCOUNT: <空> EXTSVCPASSWORD: <空> FEATURES: FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: <空> FTSVCACCOUNT: <空> FTSVCPASSWORD: <空> HELP: false IACCEPTPYTHONLICENSETERMS: false IACCEPTROPENLICENSETERMS: false IACCEPTSQLSERVERLICENSETERMS: true IACKNOWLEDGEENTCALLIMITS: false INDICATEPROGRESS: true INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLDATADIR: <空> INSTANCEDIR: D:\Program Files (x86)\SQLserver2019 INSTANCEID: <空> INSTANCENAME: MSSQLSERVER ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service ISMASTERSVCPASSWORD: <空> ISMASTERSVCPORT: 8391 ISMASTERSVCSSLCERTCN: <空> ISMASTERSVCSTARTUPTYPE: Automatic ISMASTERSVCTHUMBPRINT: <空> ISSVCACCOUNT: NT AUTHORITY\Network Service ISSVCPASSWORD: <空> ISSVCSTARTUPTYPE: Automatic ISTELSVCACCT: <空> ISTELSVCPASSWORD: <空> ISTELSVCSTARTUPTYPE: 0 ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service ISWORKERSVCCERT: <空> ISWORKERSVCMASTER: <空> ISWORKERSVCPASSWORD: <空> ISWORKERSVCSTARTUPTYPE: Automatic MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME: <空> MATRIXNAME: <空> MRCACHEDIRECTORY: NPENABLED: 0 PBDMSSVCACCOUNT: <空> PBDMSSVCPASSWORD: <空> PBDMSSVCSTARTUPTYPE: 0 PBENGSVCACCOUNT: <空> PBENGSVCPASSWORD: <空> PBENGSVCSTARTUPTYPE: 0 PBPORTRANGE: <空> PBSCALEOUT: false PID: ***** QUIET: true QUIETSIMPLE: false ROLE: RSINSTALLMODE: DefaultNativeMode RSSVCACCOUNT: <空> RSSVCPASSWORD: <空> RSSVCSTARTUPTYPE: Automatic SAPWD: <空> SECURITYMODE: <空> SQLBACKUPDIR: <空> SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS SQLJAVADIR: <空> SQLMAXDOP: 0 SQLMAXMEMORY: 2147483647 SQLMINMEMORY: 0 SQLSVCACCOUNT: <空> SQLSVCINSTANTFILEINIT: true SQLSVCPASSWORD: <空> SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: LAPTOP-I9SCFVLK\Terryfold SQLTELSVCACCT: <空> SQLTELSVCPASSWORD: <空> SQLTELSVCSTARTUPTYPE: 0 SQLTEMPDBDIR: <空> SQLTEMPDBFILECOUNT: 0 SQLTEMPDBFILEGROWTH: -1 SQLTEMPDBFILESIZE: -1 SQLTEMPDBLOGDIR: <空> SQLTEMPDBLOGFILEGROWTH: -1 SQLTEMPDBLOGFILESIZE: -1 SQLUSERDBDIR: <空> SQLUSERDBLOGDIR: <空> SUPPRESSPAIDEDITIONNOTICE: false SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: false UpdateSource: MU USEMICROSOFTUPDATE: false USESQLRECOMMENDEDMEMORYLIMITS: true X86: false Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200522_231731\ConfigurationFile.ini Rules with failures or warnings: Global rules: 警告 IsFirewallEnabled Windows 防火墙已启用。请确保相应端口已打开,以启用远程访问。若要了解为每项功能打开的端口,请参阅 https://go.microsoft.com/fwlink/?linkid=2094702 中的规则文档。 Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20200522_231731\SystemConfigurationCheck_Report.htm
©️2020 CSDN 皮肤主题: 编程工作室 设计师:CSDN官方博客 返回首页