Microsoft SQL Server 2012 安装程序试图执行未经授权的操作 [英] Microsoft SQL Server 2012 Setup Attempted to perform an unauthorized operation
问题描述
我正在尝试在我以前运行过的笔记本电脑上安装 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.
- 在开发环境中，您可以尝试给有问题的注册表项.就我而言，它归系统"帐户所有，无法轻松授予权限.我将 Windows 10 重新启动到安全模式并授予所需权限，然后重新启动回正常模式.
这篇关于Microsoft SQL Server 2012 安装程序试图执行未经授权的操作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
