問題描述
我正在嘗試在我以前運行過的筆記本電腦上安裝 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 安裝程序試圖執行未經授權的操作的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網!