Microsoft SQL Server 2012 安装程序试图执行未经授权的操作

2021-09-25 00:00:00 windows sql-server unauthorized

我正在尝试在我以前运行过的笔记本电脑上安装 SQL Server 2012 开发人员版.我的笔记本电脑磁盘空间不足，我不得不提前卸载它.它不再起作用并且在最后一刻失败给我一个未经授权的错误.我使用进程监视器查看问题，可以看到它正在尝试访问注册表项HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\FltMgr"，但得到访问被拒绝.我尝试了多次尝试授予对该注册表项上的所有人的完全访问权限，但它不起作用.我在这里发布之前已经阅读了几篇文章，所以请不要认为我来这里是为了在没有适当调查的情况下快速得到答案，尽管我很想尽快把它整理好.请问有什么想法吗?

I am trying to install SQL Server 2012 Developer edition on my laptop which had it working previously. My laptop was running low on disk space and I had to uninstall it earlier. It no longer works and fails at the last moment giving me an unauthorized error. I used process monitor to look at the problem and can see that it is attempting to gain access to the registry key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\FltMgr" but gets an access denied. I have tried several attempts to grant Full access to everyone on that registry key but it does not work. I have read several articles before posting it here and so please do not think that I have come here to get an answer quickly without proper investigation although I would love to get it sorted quickly. Any ideas please?

操作系统:Windows 10 家庭版

虽然安装失败，但是可以看到windows服务SQL Server (MSSQLSERVER)"没有启动.事件查看器中显示以下错误.initerrlog: 无法打开错误日志文件 ''.操作系统错误 = 3(系统找不到指定的路径.).

Although the installation failed, I can see the windows service "SQL Server (MSSQLSERVER)" which does not start. The following error is shown in the event viewer. initerrlog: Could not open error log file ''. Operating system error = 3(The system cannot find the path specified.).

Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068119551
  Start time:                    2016-11-14 14:55:15
  End time:                      2016-11-14 15:24:10
  Requested action:              Install

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for SQLEngine:       Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
  Next step for Replication:     Use the following information to resolve the error, uninstall this feature, and then run the setup process again.


Machine Properties:
  Machine name:                  DESKTOP-9VOUAM4
  Machine processor count:       8
  OS version:                    Future Windows Version
  OS service pack:               
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

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

Package properties:
  Description:                   Microsoft SQL Server 2012 
  ProductName:                   SQL Server 2012
  Type:                          RTM
  Version:                       11
  Installation location:         D:\sqlserver\x64\setup\
  Installation edition:          Developer

  Slipstream:                    True
  SP Level                       2

Product Update Status:
  Success: KB 2958429

Product Updates Selected for Installation:
  Title:                         Service Pack 2
  Knowledge Based Article:       KB 2958429
  Version:                       11.2.5058.0
  Architecture:                  x64
  Language:                      1033

  Update Source:                 Slipstream


User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      false
  AGTSVCACCOUNT:                 NT Service\SQLSERVERAGENT
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Manual
  ASBACKUPDIR:                   Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   Config
  ASDATADIR:                     Data
  ASLOGDIR:                      Log
  ASPROVIDERMSOLAP:              1
  ASSERVERMODE:                  MULTIDIMENSIONAL
  ASSVCACCOUNT:                  <empty>
  ASSVCPASSWORD:                 <empty>
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            <empty>
  ASTEMPDIR:                     Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CLTCTLRNAME:                   <empty>
  CLTRESULTDIR:                  <empty>
  CLTSTARTUPTYPE:                0
  CLTSVCACCOUNT:                 <empty>
  CLTSVCPASSWORD:                <empty>
  CLTWORKINGDIR:                 <empty>
  COMMFABRICENCRYPTION:          0
  COMMFABRICNETWORKLEVEL:        0
  COMMFABRICPORT:                0
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20161114_145357\ConfigurationFile.ini
  CTLRSTARTUPTYPE:               0
  CTLRSVCACCOUNT:                <empty>
  CTLRSVCPASSWORD:               <empty>
  CTLRUSERS:                     <empty>
  ENABLERANU:                    false
  ENU:                           true
  ERRORREPORTING:                false
  FEATURES:                      SQLENGINE, REPLICATION, SSMS, ADV_SSMS
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 <empty>
  HELP:                          false
  IACCEPTSQLSERVERLICENSETERMS:  true
  INDICATEPROGRESS:              false
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <empty>
  INSTANCEDIR:                   d:\Program Files\Microsoft SQL Server\
  INSTANCEID:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT AUTHORITY\Network Service
  ISSVCPASSWORD:                 <empty>
  ISSVCSTARTUPTYPE:              Automatic
  MATRIXCMBRICKCOMMPORT:         0
  MATRIXCMSERVERNAME:            <empty>
  MATRIXNAME:                    <empty>
  NPENABLED:                     0
  PID:                           *****
  QUIET:                         false
  QUIETSIMPLE:                   false
  ROLE:                          <empty>
  RSINSTALLMODE:                 DefaultNativeMode
  RSSHPINSTALLMODE:              DefaultSharePointMode
  RSSVCACCOUNT:                  <empty>
  RSSVCPASSWORD:                 <empty>
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         *****
  SECURITYMODE:                  SQL
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  Latin1_General_CI_AS
  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCPASSWORD:                <empty>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           BUILTIN\Administrators
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBLOGDIR:               <empty>
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  false
  TCPENABLED:                    0
  UIMODE:                        Normal
  UpdateEnabled:                 true
  UpdateSource:                  Slipstream
  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20161114_145357\ConfigurationFile.ini

Detailed results:
  Feature:                       Management Tools - Complete
  Status:                        Passed

  Feature:                       Management Tools - Basic
  Status:                        Passed

  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, uninstall this feature, and then run the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84BB0001
  Error description:             Attempted to perform an unauthorized operation.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387

  Feature:                       SQL Server Replication
  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, uninstall this feature, and then run the setup process again.
  Component name:                SQL Server Database Engine Services Instance Features
  Component error code:          0x84BB0001
  Error description:             Attempted to perform an unauthorized operation.
  Error help link:               http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.5058.0&EvtType=0x48BB60BC%400xBB814387&EvtType=0x48BB60BC%400xBB814387

  Feature:                       SQL Browser
  Status:                        Passed

  Feature:                       SQL Writer
  Status:                        Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20161114_145357\SystemConfigurationCheck_Report.htm

推荐答案

在阅读了更多在线文章和帖子后，我无法使用这些选项中的任何一个.我也看到其他人对这些答案不满意的类似评论.因此，我可以肯定地说，如果您首先安装了损坏或错误的 SQL Server Developer/Express，那么某处存在一个固有的问题，会给您带来很大的痛苦.目前，我对以下内容感到满意，并考虑将其张贴在这里，以防它对某人有所帮助.将 SQL Server 安装路径更改为其他文件夹(在我的情况下，我将其更改为D:\SQL\Microsoft SQL Server")后，数据库引擎安装没有任何问题，这有点奇怪.

After reading through many more articles and posts online, I could not get it working with any of those options. I have seen similar comments from other people who were not satisfied with those answers either. Hence I can definitely say that there is an inherent problem somewhere causing you a lot of pain if you were to have a corrupt or bad SQL Server Developer/Express installation in the first place. For now, I am satisfied with the following and thought of posting it here in case it helps someone. Its a bit weird that after changing the SQL Server installation path to a different folder (in my case I changed it to "D:\SQL\Microsoft SQL Server") the Database engine installs without any issues.

如果您遇到类似问题，请记住以下几点:1. 如果您在安装过程中看到未经授权的操作"或类似错误，请运行 ProcessMonitor (Sysinternal/Microsoft) 工具并在过滤 SQL Server Engine 安装程序进程后检查跟踪.安装SQL Server 2012 Express/Developer时未经授权的操作2. 我看到SQL Server 代理"和SQL Server 数据库引擎"使用的服务帐户可能是动态创建的，这可能没有足够的注册表访问权限.我对这个不是很确定，但是如果没有任何帮助，值得一看将其更改为其他帐户(例如 LocalService).

Couple of points to remember if you were to encounter a similar issue: 1. If you were to see an "unauthorized operation" or similar error during installation, please run the tool ProcessMonitor (Sysinternal/Microsoft) and inspect the trace after filtering for the SQL Server Engine installer process. Unauthorized operation while installing SQL Server 2012 Express/Developer 2. I have seen that the service account that the "SQL Server Agent" and the "SQL Server Database engine" uses is probably created on the fly and this may not have enough access rights to the registry. I am not very sure on this one, however its worth a look at changing it to some other account (say LocalService) if nothing helps.

  1. 在开发环境中，您可以尝试给有问题的注册表项.就我而言，它归系统"帐户所有，无法轻松授予权限.我将 Windows 10 重新启动到安全模式并授予所需权限，然后重新启动回正常模式.

注册表权限、用户帐户

相关文章