-
Question
-
-
Moved by
Sethu Srinivasan
Thursday, December 13, 2012 9:30 PM
setup (From:Getting started with SQL Server)
-
Moved by
Answers
-
-
Marked as answer by
Maggie Luo
Tuesday, December 25, 2012 5:03 AM
-
Marked as answer by
All replies
-
-
Marked as answer by
Maggie Luo
Tuesday, December 25, 2012 5:03 AM
-
Marked as answer by
-
Would you please upload SQL Server setup logs,
You can check-out below «FAQ» on how to locate and upload setup logs.
FAQ
—-
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided «AS IS» with no warranties, and confers no rights. Please remember to click
«Mark as Answer» and «Vote as Helpful»
on posts that help you.
This can be beneficial to other community members reading the thread.
-
hey guys
this problem is because you are trying to install any component of sql 2012 on a ReFS formatted drive
install on an NTFS drive or format the target drive to NTFS and all works fine.
Not sure if Microsoft is going to update the installer to support its own ReFS format. time will tell
cheers
Ant
I am receiving the 0x84BB0001 Error after attempting to install a new instance of SQL Server 2012. This is happening after an uninstall of a previous version of SQL Server 2012. I have pasted the log file below. Any help is greatly appreciated.
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068119551
Exit facility code: 1211
Exit error code: 1
Exit message: The system cannot find the file specified.
Start time: 2014-07-29 11:59:09
End time: 2014-07-29 12:09:12
Requested action: Install
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0x37D77D9E%400xDC80C325&EvtType=0x37D77D9E%400xDC80C325
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for Replication: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for SSMS: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for SNAC: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for SNAC_SDK: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for LocalDB: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for Writer: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for Browser: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Machine Properties:
Machine name: MAPCOM444
Machine processor count: 4
OS version: Windows 7
OS service pack: Service Pack 1
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
Package properties:
Description: Microsoft SQL Server 2012 Service Pack 1
ProductName: SQL Server 2012
Type: RTM
Version: 11
SPLevel: 0
Installation location: c:a95a4ef80214055fe53dx64setup
Installation edition: Express
Product Update Status:
None discovered.
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: true
AGTSVCACCOUNT: NT AUTHORITYNETWORK SERVICE
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Disabled
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:
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: true
ENU: true
ERRORREPORTING: false
FEATURES: SQLENGINE, REPLICATION, SSMS, SNAC_SDK, LOCALDB
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTSQLSERVERLICENSETERMS: false
INDICATEPROGRESS: false
INSTALLSHAREDDIR: c:Program FilesMicrosoft SQL Server
INSTALLSHAREDWOWDIR: c:Program Files (x86)Microsoft SQL Server
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:Program FilesMicrosoft SQL Server
INSTANCEID: SQLEXPRESS
INSTANCENAME: SQLEXPRESS
ISSVCACCOUNT: NT AUTHORITYNetwork Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
NPENABLED: 0
PID: *****
QUIET: false
QUIETSIMPLE: false
ROLE: AllFeatures_WithDefaults
RSINSTALLMODE: DefaultNativeMode
RSSHPINSTALLMODE: DefaultSharePointMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: NT ServiceMSSQL$SQLEXPRESS
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: <empty>
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: false
TCPENABLED: 0
UIMODE: AutoAdvance
UpdateEnabled: true
UpdateSource: MU
X86: false
Configuration file: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140729_114734ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Server Replication
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: Management Tools - Basic
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Client Connectivity
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Client Connectivity SDK
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: LocalDB
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Writer
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Browser
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140729_114734SystemConfigurationCheck_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.Configuration.Sco.ScoException
Message:
The system cannot find the file specified.
HResult : 0x84bb0001
FacilityCode : 1211 (4bb)
ErrorCode : 1 (0001)
Data:
WatsonData = SQLBrowser
DisableRetry = true
HelpLink.EvtType = 0x37D77D9E@0xDC80C325
DisableWatson = true
Stack:
at Microsoft.SqlServer.Configuration.Sco.Service.GetStartAccount()
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPublicConfig.CalculateUserNamePassword()
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPublicConfig.Calculate()
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.CalculateSettings(IEnumerable`1 settingIds)
at Microsoft.SqlServer.Configuration.Settings.Calculate()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.ConfigurationController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizard.ServicesController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageEntered(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardTabbedPageHost.PageEntered(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value)
at Microsoft.SqlServer.Configuration.InstallWizardFramework.ConfigurationController.OnPageNavigationRequest(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.InstallWizard.DiskUsageController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageEntered(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value)
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.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.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Inner exception type: System.ComponentModel.Win32Exception
Message:
The system cannot find the file specified.
HResult : 0x80004005
Error : 2
Stack:
at Microsoft.SqlServer.Configuration.Sco.Service.QueryServiceConfig()
at Microsoft.SqlServer.Configuration.Sco.Service.GetStartAccount()
asked Jul 29, 2014 at 17:20
I was able to get past the error by changing the instance name. The old instance name from the uninstalled version was SQLEXPRESS, I changed this to SQLEXPRESS2012 and the installation proceeded.
answered Jul 29, 2014 at 17:53
ghoston3rdghoston3rd
1292 gold badges5 silver badges14 bronze badges
Have you tried deleting the contents in the folder?
C:/Users/[UserName]/AppData/Local/Microsoft_Corporation.
installation again as a repair, hope this will work.
answered Jul 29, 2014 at 18:03
1
Troubleshooter note: SQL Installation fails with exitcode 0x84BB0001 on a ReFS formatted partition.
So I tried to install SQL the other day for a new ConfigMgr environment, but I kept getting an error during the first seconds of the installation with 0x84BB0001 as the exit code. With some quick investigation into the log files I found this
%Temp%SqlSetup_Local.log:
C:Program FilesMicrosoft SQL Server110Setup BootstrapLogSummary.txt:
Shows that the installation has difficulties installing on a ReFS formatted partition
Disk Manager Shows that D: is formatted with ReFS (I blame my PowerShell Script :)):
Now the quick and easy way of fixing this is to reformat the partition to NTFS. And this is what I did in this case. But Microsoft has introduced support for ReFS for various versions of SQL in Cumulative Updates but not for SQL 2012. “There are some features of NTFS that aren’t supported by ReFS, specifically named streams, object IDs, short names, compression, file-level encryption (EFS), user data transactions, sparse, hard-links, extended attributes, and quotas. SQL Server databases uses named streams and sparse files in several functions, for example DBCC CHECKDB. This means you should not use ReFS with SQL Server. Stick with NTFS. Ref; http://windowsitpro.com/sql-server-2012/using-refs-sql-server
FIX: “Requested value ReFS was not found” error when you install SQL Server 2014 on a local drive that is ReFS formatted: https://support.microsoft.com/en-us/kb/3017266
Changing it back to NTFS fixed to issue for me. 🙂 Happy troubleshooting!
Share This Story, Choose Your Platform!
Microsoft Enterprise Client Management Evangelist with: 10+ years experience within Microsoft System Management Solutions
Extensive experience across Private and Public Sector
Passion for Community Driven work, volunteering within Microsoft technology
Great belief that sharing experience within fellow peers is key to creating a sustainable society
Strong commitment to System Center User Group Norway as co-founder and current leader
I am a technology enthusiast working as a consultant for the consultant company CTGlobal. I have always been passionate about IT and have the last 10 + years worked with Management and Automation within Microsoft technology. Back in 2005/6 I started working with System Management Server (SMS) 2003 and have been working with Enterprise Client Management ever since, where i today focus on helping customers design and implement solutions based on System Center Configuration Manager and/or Enterprise Mobility Suite from Microsoft. Other parts of my work consists of speaking and presenting at different events and seminars, doing research and blog about solutions I find and products I work with. I truly believe in a strong community where knowledge and know-how is essential. Creating creative arenas where it is possible for peers to spread the word about new technologies and solutions is key and as an act on this I co-founded System Center User Group Norway (www.scug.no). SCUG is an initiative where we discuss, preach and present new technologies and solutions in the System Center Space from Microsoft. This is a free arena for everybody to join that is interested in/or enthusiastic about Microsoft Cloud Platform (Enterprise Client Management or Cloud and Datacenter).
Specialties:
System Center Configuration Manager (SCCM2007-SCCM2012), Enterprise Mobility and Intune, Windows and Windows server deployment.
Beslægtede indlæg
Page load link
databasesqlsql-server
I am receiving the 0x84BB0001 Error after attempting to install a new instance of SQL Server 2012. This is happening after an uninstall of a previous version of SQL Server 2012. I have pasted the log file below. Any help is greatly appreciated.
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068119551
Exit facility code: 1211
Exit error code: 1
Exit message: The system cannot find the file specified.
Start time: 2014-07-29 11:59:09
End time: 2014-07-29 12:09:12
Requested action: Install
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0x37D77D9E%400xDC80C325&EvtType=0x37D77D9E%400xDC80C325
Setup completed with required actions for features.
Troubleshooting information for those features:
Next step for SQLEngine: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for Replication: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for SSMS: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for SNAC: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for SNAC_SDK: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for LocalDB: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for Writer: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Next step for Browser: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Machine Properties:
Machine name: MAPCOM444
Machine processor count: 4
OS version: Windows 7
OS service pack: Service Pack 1
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
Package properties:
Description: Microsoft SQL Server 2012 Service Pack 1
ProductName: SQL Server 2012
Type: RTM
Version: 11
SPLevel: 0
Installation location: c:a95a4ef80214055fe53dx64setup
Installation edition: Express
Product Update Status:
None discovered.
User Input Settings:
ACTION: Install
ADDCURRENTUSERASSQLADMIN: true
AGTSVCACCOUNT: NT AUTHORITYNETWORK SERVICE
AGTSVCPASSWORD: *****
AGTSVCSTARTUPTYPE: Disabled
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:
CTLRSTARTUPTYPE: 0
CTLRSVCACCOUNT: <empty>
CTLRSVCPASSWORD: <empty>
CTLRUSERS: <empty>
ENABLERANU: true
ENU: true
ERRORREPORTING: false
FEATURES: SQLENGINE, REPLICATION, SSMS, SNAC_SDK, LOCALDB
FILESTREAMLEVEL: 0
FILESTREAMSHARENAME: <empty>
FTSVCACCOUNT: <empty>
FTSVCPASSWORD: <empty>
HELP: false
IACCEPTSQLSERVERLICENSETERMS: false
INDICATEPROGRESS: false
INSTALLSHAREDDIR: c:Program FilesMicrosoft SQL Server
INSTALLSHAREDWOWDIR: c:Program Files (x86)Microsoft SQL Server
INSTALLSQLDATADIR: <empty>
INSTANCEDIR: C:Program FilesMicrosoft SQL Server
INSTANCEID: SQLEXPRESS
INSTANCENAME: SQLEXPRESS
ISSVCACCOUNT: NT AUTHORITYNetwork Service
ISSVCPASSWORD: <empty>
ISSVCSTARTUPTYPE: Automatic
MATRIXCMBRICKCOMMPORT: 0
MATRIXCMSERVERNAME: <empty>
MATRIXNAME: <empty>
NPENABLED: 0
PID: *****
QUIET: false
QUIETSIMPLE: false
ROLE: AllFeatures_WithDefaults
RSINSTALLMODE: DefaultNativeMode
RSSHPINSTALLMODE: DefaultSharePointMode
RSSVCACCOUNT: <empty>
RSSVCPASSWORD: <empty>
RSSVCSTARTUPTYPE: Automatic
SAPWD: <empty>
SECURITYMODE: <empty>
SQLBACKUPDIR: <empty>
SQLCOLLATION: SQL_Latin1_General_CP1_CI_AS
SQLSVCACCOUNT: NT ServiceMSSQL$SQLEXPRESS
SQLSVCPASSWORD: <empty>
SQLSVCSTARTUPTYPE: Automatic
SQLSYSADMINACCOUNTS: <empty>
SQLTEMPDBDIR: <empty>
SQLTEMPDBLOGDIR: <empty>
SQLUSERDBDIR: <empty>
SQLUSERDBLOGDIR: <empty>
SQMREPORTING: false
TCPENABLED: 0
UIMODE: AutoAdvance
UpdateEnabled: true
UpdateSource: MU
X86: false
Configuration file: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140729_114734ConfigurationFile.ini
Detailed results:
Feature: Database Engine Services
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Server Replication
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: Management Tools - Basic
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Client Connectivity
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Client Connectivity SDK
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: LocalDB
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Writer
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Feature: SQL Browser
Status: Failed: see logs for details
Reason for failure: Setup was canceled for the feature.
Next Step: SQL Server Setup was canceled before completing the operation. Try the setup process again.
Rules with failures:
Global rules:
Scenario specific rules:
Rules report file: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20140729_114734SystemConfigurationCheck_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.Configuration.Sco.ScoException
Message:
The system cannot find the file specified.
HResult : 0x84bb0001
FacilityCode : 1211 (4bb)
ErrorCode : 1 (0001)
Data:
WatsonData = SQLBrowser
DisableRetry = true
HelpLink.EvtType = 0x37D77D9E@0xDC80C325
DisableWatson = true
Stack:
at Microsoft.SqlServer.Configuration.Sco.Service.GetStartAccount()
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPublicConfig.CalculateUserNamePassword()
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPublicConfig.Calculate()
at Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.CalculateSettings(IEnumerable`1 settingIds)
at Microsoft.SqlServer.Configuration.Settings.Calculate()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.ConfigurationController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizard.ServicesController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageEntered(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardTabbedPageHost.PageEntered(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value)
at Microsoft.SqlServer.Configuration.InstallWizardFramework.ConfigurationController.OnPageNavigationRequest(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.InstallWizard.DiskUsageController.LoadData()
at Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageEntered(PageChangeReason reason)
at Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value)
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.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.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Inner exception type: System.ComponentModel.Win32Exception
Message:
The system cannot find the file specified.
HResult : 0x80004005
Error : 2
Stack:
at Microsoft.SqlServer.Configuration.Sco.Service.QueryServiceConfig()
at Microsoft.SqlServer.Configuration.Sco.Service.GetStartAccount()
Related Question
- Sql – How to return only the Date from a SQL Server DateTime datatype
- Sql-server – How to check if a column exists in a SQL Server table
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Sql-server – LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- Sql – How to do an UPDATE statement with JOIN in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
- Sql – Find all tables containing column with specified name – MS SQL Server
- Sql – How to delete using INNER JOIN with SQL Server
Как решить | Исправить сообщения об ошибках установки SQL Server 2008?
Я пытаюсь установить выпуск SQL Server 2012 Developer на свой ноутбук, на котором он работал раньше. На моем ноутбуке было мало места на диске, и мне пришлось удалить его ранее. Он больше не работает и в последний момент не работает, что приводит к несанкционированной ошибке. Я использовал монитор процесса, чтобы посмотреть на проблему, и вижу, что он пытается получить доступ к разделу реестра. «HKEY_LOCAL_MACHINE SYSTEM CurrentControlSet Services FltMgr» но получает в доступе отказано. Я пробовал несколько попыток предоставить всем полный доступ к этому разделу реестра, но это не сработало. Я прочитал несколько статей, прежде чем размещать его здесь, и поэтому, пожалуйста, не думайте, что я пришел сюда, чтобы быстро получить ответ без надлежащего расследования, хотя я бы хотел, чтобы его быстро разобрали. Есть идеи, пожалуйста?
ОС: Windows 10 Home Edition
Хотя установка не удалась, я вижу службу Windows «SQL Server (MSSQLSERVER)», которая не запускается. В средстве просмотра событий отображается следующая ошибка. initerrlog: не удалось открыть файл журнала ошибок ». Ошибка операционной системы = 3 (система не может найти указанный путь.).
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:sqlserverx64setup 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 ServiceSQLSERVERAGENT AGTSVCPASSWORD: ***** AGTSVCSTARTUPTYPE: Manual ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR: Config ASDATADIR: Data ASLOGDIR: Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: MULTIDIMENSIONAL ASSVCACCOUNT: ASSVCPASSWORD: ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: ASTEMPDIR: Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: CLTRESULTDIR: CLTSTARTUPTYPE: 0 CLTSVCACCOUNT: CLTSVCPASSWORD: CLTWORKINGDIR: COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20161114_145357ConfigurationFile.ini CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT: CTLRSVCPASSWORD: CTLRUSERS: ENABLERANU: false ENU: true ERRORREPORTING: false FEATURES: SQLENGINE, REPLICATION, SSMS, ADV_SSMS FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: FTSVCACCOUNT: FTSVCPASSWORD: HELP: false IACCEPTSQLSERVERLICENSETERMS: true INDICATEPROGRESS: false INSTALLSHAREDDIR: C:Program FilesMicrosoft SQL Server INSTALLSHAREDWOWDIR: C:Program Files (x86)Microsoft SQL Server INSTALLSQLDATADIR: INSTANCEDIR: d:Program FilesMicrosoft SQL Server INSTANCEID: MSSQLSERVER INSTANCENAME: MSSQLSERVER ISSVCACCOUNT: NT AUTHORITYNetwork Service ISSVCPASSWORD: ISSVCSTARTUPTYPE: Automatic MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME: MATRIXNAME: NPENABLED: 0 PID: ***** QUIET: false QUIETSIMPLE: false ROLE: RSINSTALLMODE: DefaultNativeMode RSSHPINSTALLMODE: DefaultSharePointMode RSSVCACCOUNT: RSSVCPASSWORD: RSSVCSTARTUPTYPE: Automatic SAPWD: ***** SECURITYMODE: SQL SQLBACKUPDIR: SQLCOLLATION: Latin1_General_CI_AS SQLSVCACCOUNT: NT ServiceMSSQLSERVER SQLSVCPASSWORD: SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: BUILTINAdministrators SQLTEMPDBDIR: SQLTEMPDBLOGDIR: SQLUSERDBDIR: SQLUSERDBLOGDIR: SQMREPORTING: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: true UpdateSource: Slipstream X86: false Configuration file: C:Program FilesMicrosoft SQL Server110Setup BootstrapLog20161114_145357ConfigurationFile.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 FilesMicrosoft SQL Server110Setup BootstrapLog20161114_145357SystemConfigurationCheck_Report.htm
Прочитав еще много статей и сообщений в Интернете, я не смог заставить его работать ни с одним из этих вариантов. Я видел похожие комментарии от других людей, которых тоже не удовлетворили эти ответы. Следовательно, я могу определенно сказать, что где-то существует внутренняя проблема, которая причиняет вам много боли, если у вас изначально была поврежденная или плохая установка SQL Server Developer / Express. На данный момент я удовлетворен следующим и подумал о том, чтобы опубликовать его здесь, если это кому-то поможет. Немного странно, что после изменения пути установки SQL Server в другую папку (в моем случае я изменил ее на «D: SQL Microsoft SQL Server») ядро базы данных устанавливается без каких-либо проблем..
Несколько моментов, которые следует запомнить, если вы столкнетесь с подобной проблемой: 1. Если вы увидите «несанкционированную операцию» или аналогичную ошибку во время установки, запустите инструмент ProcessMonitor (Sysinternal / Microsoft) и проверьте трассировку после фильтрации для Процесс установки SQL Server Engine. Несанкционированная операция при установке SQL Server 2012 Express / Developer 2. Я видел, что учетная запись службы, которую использует «агент SQL Server» и «ядро базы данных SQL Server», вероятно, создается на лету, и у нее может не быть достаточных прав доступа для реестр. Я не очень уверен в этом, однако стоит взглянуть на изменение его на другую учетную запись (скажем, LocalService), если ничего не помогает.
- В среде разработки вы можете попробовать дать полное разрешение соответствующему разделу реестра. В моем случае он принадлежал учетной записи «Система» и не мог легко предоставлять разрешения. Я перезагрузил Windows 10 в безопасном режиме и дал необходимые разрешения, а затем перезагрузился в нормальный режим.
Разрешения реестра, учетные записи пользователей
Tweet
Share
Link
Plus
Send
Send
Pin