question

IratxeDeOsa-4972 avatar image
0 Votes"
IratxeDeOsa-4972 asked ·

I couldn´t install sql-server 2019 . It seems I have problems with the register keys

I couldn´t install sql-server 2019 EXPRESS (01) 2021-02-28 08:44:01 Slp: El sistema no puede encontrar el archivo especificado. (01) 2021-02-28 08:44:01 Slp: Watson bucket for exception based failure has been created (01) 2021-02-28 08:44:01 Slp: WER: Application level consent value 'True' was mapped to consent status 'WerConsentApproved' (01) 2021-02-28 08:44:03 Slp: WER: Result of the submission:: 'WerReportUploaded' (01) 2021-02-28 08:44:03 Slp: WER: Submitted 1 of 1 failures to the Watson data repository (01) 2021-02-28 08:44:03 Slp: SetupTelemetry: Writing Telemetry to Datastore (01) 2021-02-28 08:44:08 Slp: (01) 2021-02-28 08:44:08 Slp: ---------------------------------------------------------------------- (01) 2021-02-28 08:44:08 Slp: (01) 2021-02-28 08:44:08 Slp: Resultado de error: -2068119551 (01) 2021-02-28 08:44:08 Slp: Código de componente del resultado: 1211 (01) 2021-02-28 08:44:08 Slp: Código de error del resultado: 1 (01) 2021-02-28 08:44:08 Slp: SetupTelemetry: Closing Telemetry Session (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\SQMClient (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to get registry value MachineId (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150 (01) 2021-02-28 08:44:08 Slp: SetupTelemetry: Not creating telemetry audit log. Value 'UserRequestedLocalAuditDirectory' doesn't exist in 'HKLM\Software\Microsoft\Microsoft SQL Server\150' (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150 (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to get registry value CustomerFeedback (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to get registry value EnableErrorReporting (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names (01) 2021-02-28 08:44:08 Slp: SetupTelemetry: Telemetry has an active session with 17 events. (01) 2021-02-28 08:44:01 Slp: El sistema no puede encontrar el archivo especificado. (01) 2021-02-28 08:44:01 Slp: Watson bucket for exception based failure has been created (01) 2021-02-28 08:44:01 Slp: WER: Application level consent value 'True' was mapped to consent status 'WerConsentApproved' (01) 2021-02-28 08:44:03 Slp: WER: Result of the submission:: 'WerReportUploaded' (01) 2021-02-28 08:44:03 Slp: WER: Submitted 1 of 1 failures to the Watson data repository (01) 2021-02-28 08:44:03 Slp: SetupTelemetry: Writing Telemetry to Datastore (01) 2021-02-28 08:44:08 Slp: (01) 2021-02-28 08:44:08 Slp: ---------------------------------------------------------------------- (01) 2021-02-28 08:44:08 Slp: (01) 2021-02-28 08:44:08 Slp: Resultado de error: -2068119551 (01) 2021-02-28 08:44:08 Slp: Código de componente del resultado: 1211 (01) 2021-02-28 08:44:08 Slp: Código de error del resultado: 1 (01) 2021-02-28 08:44:08 Slp: SetupTelemetry: Closing Telemetry Session (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\SQMClient (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to get registry value MachineId (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150 (01) 2021-02-28 08:44:08 Slp: SetupTelemetry: Not creating telemetry audit log. Value 'UserRequestedLocalAuditDirectory' doesn't exist in 'HKLM\Software\Microsoft\Microsoft SQL Server\150' (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\150 (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to get registry value CustomerFeedback (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to get registry value EnableErrorReporting (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine (01) 2021-02-28 08:44:08 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\Instance Names (01) 2021-02-28 08:44:08 Slp: SetupTelemetry: Telemetry has an active session with 17 events. Overall summary: Final result: Error: vea los detalles a continuación Exit code (Decimal): -2068119551 Exit facility code: 1211 Exit error code: 1 Exit message: El sistema no puede encontrar el archivo especificado. Start time: 2021-02-28 08:42:40 End time: 2021-02-28 08:44:03 Requested action: Install Exception help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x37D77D9E%400xDC80C325&EvtType=0x37D77D9E%400xDC80C325 Setup completed with required actions for features. Troubleshooting information for those features: Next step for SQLEngine: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Next step for ComponentUpdate: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Next step for SNAC: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Next step for SNAC_SDK: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Next step for Writer: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Next step for Browser: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Machine Properties: Machine name: DESKTOP-VAGDKCC Machine processor count: 4 OS version: Microsoft Windows 10 Pro (10.0.19042) OS service pack: OS region: España OS language: español (España, alfabetización internacional) OS architecture: x64 Process architecture: 64 bits OS clustered: No 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: C:\SQL2019\Developer_ESN\x64\setup\ Installation edition: Express Product Update Status: No se detectó ninguna. Configuración de entrada de usuario: ACTION: Install ADDCURRENTUSERASSQLADMIN: false AGTSVCACCOUNT: NT AUTHORITY\Servicio de red AGTSVCPASSWORD: AGTSVCSTARTUPTYPE: Disabled ASBACKUPDIR: Backup ASCOLLATION: Latin1_General_CI_AS ASCONFIGDIR: Config ASDATADIR: Data ASLOGDIR: Log ASPROVIDERMSOLAP: 1 ASSERVERMODE: TABULAR ASSVCACCOUNT: <vacío> ASSVCPASSWORD: <vacío> ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: <vacío> ASTELSVCACCT: <vacío> ASTELSVCPASSWORD: <vacío> ASTELSVCSTARTUPTYPE: 0 ASTEMPDIR: Temp BROWSERSVCSTARTUPTYPE: Disabled CLTCTLRNAME: <vacío> CLTRESULTDIR: <vacío> CLTSTARTUPTYPE: 0 CLTSVCACCOUNT: <vacío> CLTSVCPASSWORD: <vacío> CLTWORKINGDIR: <vacío> COMMFABRICENCRYPTION: 0 COMMFABRICNETWORKLEVEL: 0 COMMFABRICPORT: 0 CONFIGURATIONFILE: CTLRSTARTUPTYPE: 0 CTLRSVCACCOUNT: <vacío> CTLRSVCPASSWORD: <vacío> CTLRUSERS: <vacío> ENABLERANU: true ENU: false EXTSVCACCOUNT: <vacío> EXTSVCPASSWORD: <vacío> FEATURES: SQLENGINE FILESTREAMLEVEL: 0 FILESTREAMSHARENAME: <vacío> FTSVCACCOUNT: <vacío> FTSVCPASSWORD: <vacío> HELP: false IACCEPTPYTHONLICENSETERMS: false IACCEPTROPENLICENSETERMS: false IACCEPTSQLSERVERLICENSETERMS: true IACKNOWLEDGEENTCALLIMITS: false INDICATEPROGRESS: false INSTALLSHAREDDIR: C:\Program Files\Microsoft SQL Server\ INSTALLSHAREDWOWDIR: C:\Program Files (x86)\Microsoft SQL Server\ INSTALLSQLDATADIR: <vacío> INSTANCEDIR: C:\Program Files\Microsoft SQL Server\ INSTANCEID: SQLEXPRESS INSTANCENAME: SQLEXPRESS ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service ISMASTERSVCPASSWORD: <vacío> ISMASTERSVCPORT: 8391 ISMASTERSVCSSLCERTCN: <vacío> ISMASTERSVCSTARTUPTYPE: Automatic ISMASTERSVCTHUMBPRINT: <vacío> ISSVCACCOUNT: NT AUTHORITY\Network Service ISSVCPASSWORD: <vacío> ISSVCSTARTUPTYPE: Automatic ISTELSVCACCT: <vacío> ISTELSVCPASSWORD: <vacío> ISTELSVCSTARTUPTYPE: 0 ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service ISWORKERSVCCERT: <vacío> ISWORKERSVCMASTER: <vacío> ISWORKERSVCPASSWORD: <vacío> ISWORKERSVCSTARTUPTYPE: Automatic MATRIXCMBRICKCOMMPORT: 0 MATRIXCMSERVERNAME: <vacío> MATRIXNAME: <vacío> MRCACHEDIRECTORY: NPENABLED: 0 PBDMSSVCACCOUNT: <vacío> PBDMSSVCPASSWORD: <vacío> PBDMSSVCSTARTUPTYPE: 0 PBENGSVCACCOUNT: <vacío> PBENGSVCPASSWORD: <vacío> PBENGSVCSTARTUPTYPE: 0 PBPORTRANGE: <vacío> PBSCALEOUT: false PID: QUIET: false QUIETSIMPLE: false ROLE: RSINSTALLMODE: DefaultNativeMode RSSVCACCOUNT: <vacío> RSSVCPASSWORD: <vacío> RSSVCSTARTUPTYPE: Automatic SAPWD: <vacío> SECURITYMODE: <vacío> SQLBACKUPDIR: <vacío> SQLCOLLATION: Modern_Spanish_CI_AS SQLJAVADIR: <vacío> SQLMAXDOP: 0 SQLMAXMEMORY: 2147483647 SQLMINMEMORY: 0 SQLSVCACCOUNT: NT Service\MSSQL$SQLEXPRESS SQLSVCINSTANTFILEINIT: false SQLSVCPASSWORD: <vacío> SQLSVCSTARTUPTYPE: Automatic SQLSYSADMINACCOUNTS: <vacío> SQLTELSVCACCT: NT Service\SQLTELEMETRY$SQLEXPRESS SQLTELSVCPASSWORD: <vacío> SQLTELSVCSTARTUPTYPE: Automatic SQLTEMPDBDIR: <vacío> SQLTEMPDBFILECOUNT: 1 SQLTEMPDBFILEGROWTH: 64 SQLTEMPDBFILESIZE: 8 SQLTEMPDBLOGDIR: <vacío> SQLTEMPDBLOGFILEGROWTH: 64 SQLTEMPDBLOGFILESIZE: 8 SQLUSERDBDIR: <vacío> SQLUSERDBLOGDIR: <vacío> SUPPRESSPAIDEDITIONNOTICE: false SUPPRESSPRIVACYSTATEMENTNOTICE: false TCPENABLED: 0 UIMODE: Normal UpdateEnabled: true UpdateSource: MU USEMICROSOFTUPDATE: false USESQLRECOMMENDEDMEMORYLIMITS: false X86: false Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210228_084240\ConfigurationFile.ini Detailed results: Feature: Servicios de Motor de base de datos Status: Error Reason for failure: Se canceló la instalación de la característica. Next Step: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Feature: Archivos auxiliares del programa de configuración Status: Error Reason for failure: Se canceló la instalación de la característica. Next Step: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Feature: Conectividad de cliente SQL Status: Error Reason for failure: Se canceló la instalación de la característica. Next Step: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Feature: SDK de conectividad de cliente SQL Status: Error Reason for failure: Se canceló la instalación de la característica. Next Step: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Feature: Objeto de escritura de SQL Status: Error Reason for failure: Se canceló la instalación de la característica. Next Step: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Feature: SQL Browser Status: Error Reason for failure: Se canceló la instalación de la característica. Next Step: El programa de configuración de SQL Server se canceló antes de completar la operación. Intente de nuevo el proceso de instalación. Rules with failures or warnings: Global rules: Advertencia IsFirewallEnabled El Firewall de Windows está habilitado. Compruebe que están abiertos los puertos correspondientes para habilitar el acceso remoto. Consulte la documentación sobre reglas en https://go.microsoft.com/fwlink/?linkid=2094702 para obtener información sobre los puertos que se deben abrir para cada característica. Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20210228_084240\SystemConfigurationCheck_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: El sistema no puede encontrar el archivo especificado. HResult : 0x84bb0001 FacilityCode : 1211 (4bb) ErrorCode : 1 (0001) Data: DisableRetry = true HelpLink.EvtType = 0x37D77D9E@0xDC80C325 EMBResult = Cancel DisableWatson = true Stack: en Microsoft.SqlServer.Configuration.Sco.Service.GetStartAccount() en Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPublicConfig.CalculateUserNamePassword() en Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPublicConfig.Calculate() en Microsoft.SqlServer.Chainer.Infrastructure.PublicConfigurationBridge.Calculate() en Microsoft.SqlServer.Chainer.Infrastructure.InputSettingService.CalculateSettings(IEnumerable`1 settingIds) en Microsoft.SqlServer.Configuration.InstallWizardFramework.ConfigurationController.LoadData() en Microsoft.SqlServer.Configuration.InstallWizard.ServicesController.LoadData() en Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardPageHost.PageEntered(PageChangeReason reason) en Microsoft.SqlServer.Configuration.InstallWizardFramework.InstallWizardTabbedPageHost.PageEntered(PageChangeReason reason) en Microsoft.SqlServer.Configuration.WizardFramework.UIHost.set_SelectedPageIndex(Int32 value) en Microsoft.SqlServer.Configuration.WizardFramework.NavigationButtons.nextButton_Click(Object sender, EventArgs e) en System.Windows.Forms.Control.OnClick(EventArgs e) en System.Windows.Forms.Button.OnClick(EventArgs e) en System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) en System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) en System.Windows.Forms.Control.WndProc(Message& m) en System.Windows.Forms.ButtonBase.WndProc(Message& m) en System.Windows.Forms.Button.WndProc(Message& m) en System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Inner exception type: System.ComponentModel.Win32Exception Message: El sistema no puede encontrar el archivo especificado. HResult : 0x80004005 Error : 2 Stack: en Microsoft.SqlServer.Configuration.Sco.Service.QueryServiceConfig() en Microsoft.SqlServer.Configuration.Sco.Service.GetStartAccount()

sql-server-general
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ·

Hi IratxeDeOsa-4972,

Final result: Error: vea los detalles a continuación Exit code (Decimal): -2068119551 Exit facility code: 1211 Exit error code: 1 Exit message: El sistema no puede encontrar el archivo especificado.

The error message " El sistema no puede encontrar el archivo especificado" may appear because some files of SQL Server basic component are corrupted or access to these files is denied.
You can uninstall failed installation clearly using the steps in this link, then please download the SQL Server Express setup.exe again from this link. Please make sure you right click on setup.exe file and select run as administrator, and disable any antivirus software or uninstall it temporarily on the machine for the time that the installation is running. When you reinstalling the SQL Server, on the server configuration page, please try to use NT AUTHORITY\SYSTEM as the SQL Server Database Engine account and SQL Server Agent account to ensure these accounts have enough permission.

Best Regards,
Amelia


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IratxeDeOsa-4972 avatar image
0 Votes"
IratxeDeOsa-4972 answered ·

Thank you very much.
Should I delete the subkey for Active Directory Autentication Library for SQL Server?

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

IratxeDeOsa-4972 avatar image
0 Votes"
IratxeDeOsa-4972 answered ·

And for Microsoft Command Line Utilities 15 for SQLServer?

· 3 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi IratxeDeosa-4972,
I think you can keep subkey for Active Directory Authentication Library for SQL Server and sqlcmd Utility.
Pleases remember to backup registry key first.

Best Regards,
Amelia

0 Votes 0 ·

And instead of renaming the folders, could I delete them?

0 Votes 0 ·

Hi IratxeDeOsa-4972,
Yes, you can.

Best Regards,
Amelia

0 Votes 0 ·