Hello everyone,
The problem I describe doesn't happen directly to me, but to a user of my software who asked me for help. Therefore I don't have direct access to the affected machine. I haven't found any solution for this specific problem on the Internet.
The problem is that the Database Engine Services and SQL Server Replication installation fails with the following errors logged in the summary:
Overall summary:
Final result: Failed: see details below
Exit code (Decimal): -2068119551
Start time: 2021-01-08 10:09:02
End time: 2021-01-08 10:10:41
Requested action: Install
Detailed results:
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: Falscher Parameter.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.6024.0&EvtType=0x0AC2A120%400xDC80C325&EvtType=0x0AC2A120%400xDC80C325
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: Falscher Parameter.
Error help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.6024.0&EvtType=0x0AC2A120%400xDC80C325&EvtType=0x0AC2A120%400xDC80C325
In the Detail.txt I've found the following fragment saying about error 87 (ERROR_INVALID_PARAMETER):
(01) 2021-01-08 10:10:32 Slp: Sco: Attempting to get local system account name
(01) 2021-01-08 10:10:32 Slp: Sco: Attempting to get NT account from sid S-1-5-18
(01) 2021-01-08 10:10:32 Slp: Sco: Attempting to get account from sid S-1-5-18
(01) 2021-01-08 10:10:32 Slp: Sco: Attempting to open SC Manager
(01) 2021-01-08 10:10:32 Slp: Sco: Attempting to open service handle for service SQLBrowser
(01) 2021-01-08 10:10:32 Slp: Invoking ChangeServiceConfig Win32 API
(01) 2021-01-08 10:10:32 Slp: Sco: Attempting to close service handle for service SQLBrowser
(01) 2021-01-08 10:10:32 Slp: Sco: Attempting to close SC Manager
(01) 2021-01-08 10:10:32 SQLBrowser: SQL Server Browser Install for feature 'SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64' failed with cancel exception: Microsoft.SqlServer.Configuration.Sco.ScoException: Falscher Parameter.
---> System.ComponentModel.Win32Exception: Falscher Parameter.
at Microsoft.SqlServer.Configuration.Sco.Service.ChangeServiceConfig(UInt32 dwServiceType, UInt32 dwStartType, UInt32 dwErrorControl, String lpBinaryPathName, String lpLoadOrderGroup, String lpDependencies, String lpServiceStartName, SqlSecureString lpPassword, String lpDisplayName)
at Microsoft.SqlServer.Configuration.Sco.Service.ChangeStartAccount(String userName, SqlSecureString password, Boolean bAutoSetServiceLogonRight)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Configuration.Sco.Service.ChangeStartAccount(String userName, SqlSecureString password, Boolean bAutoSetServiceLogonRight)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.UpdateAccountIfNeeded(SqlBrowserPublicConfig publicConfigSqlBrowser)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigUserProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig).
(01) 2021-01-08 10:10:32 SQLBrowser: The last attempted operation: Setting the service account of the SQL Server Browser service 'SQLBrowser' to 'NT AUTHORITY\LOCAL SERVICE'..
(01) 2021-01-08 10:10:32 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
(01) 2021-01-08 10:10:32 Slp: Falscher Parameter.
(01) 2021-01-08 10:10:32 Slp: The configuration failure category of current exception is ConfigurationFailure
(01) 2021-01-08 10:10:32 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing ConfigNonRC and scenario ConfigNonRC.
(01) 2021-01-08 10:10:32 Slp: Microsoft.SqlServer.Configuration.Sco.ScoException: Falscher Parameter.
(01) 2021-01-08 10:10:32 Slp: ---> System.ComponentModel.Win32Exception: Falscher Parameter.
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.ChangeServiceConfig(UInt32 dwServiceType, UInt32 dwStartType, UInt32 dwErrorControl, String lpBinaryPathName, String lpLoadOrderGroup, String lpDependencies, String lpServiceStartName, SqlSecureString lpPassword, String lpDisplayName)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.ChangeStartAccount(String userName, SqlSecureString password, Boolean bAutoSetServiceLogonRight)
(01) 2021-01-08 10:10:32 Slp: --- End of inner exception stack trace ---
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.ChangeStartAccount(String userName, SqlSecureString password, Boolean bAutoSetServiceLogonRight)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.UpdateAccountIfNeeded(SqlBrowserPublicConfig publicConfigSqlBrowser)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigUserProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
(01) 2021-01-08 10:10:32 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
(01) 2021-01-08 10:10:32 Slp: Inner exceptions are being indented
(01) 2021-01-08 10:10:32 Slp:
(01) 2021-01-08 10:10:32 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
(01) 2021-01-08 10:10:32 Slp: Message:
(01) 2021-01-08 10:10:32 Slp: Falscher Parameter.
(01) 2021-01-08 10:10:32 Slp:
(01) 2021-01-08 10:10:32 Slp: HResult : 0x84bb0001
(01) 2021-01-08 10:10:32 Slp: FacilityCode : 1211 (4bb)
(01) 2021-01-08 10:10:32 Slp: ErrorCode : 1 (0001)
(01) 2021-01-08 10:10:32 Slp: Data:
(01) 2021-01-08 10:10:32 Slp: DisableRetry = true
(01) 2021-01-08 10:10:32 Slp: Feature = SQL_Engine_Core_Inst_sql_engine_core_inst_Cpu64
(01) 2021-01-08 10:10:32 Slp: Timing = ConfigNonRC
(01) 2021-01-08 10:10:32 Slp: SQL.Setup.FailureCategory = ConfigurationFailure
(01) 2021-01-08 10:10:32 Slp: WatsonConfigActionData = INSTALL@CONFIGNONRC@SQL_ENGINE_CORE_INST
(01) 2021-01-08 10:10:32 Slp: WatsonExceptionFeatureIdsActionData = System.String[]
(01) 2021-01-08 10:10:32 Slp: Stack:
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.ChangeStartAccount(String userName, SqlSecureString password, Boolean bAutoSetServiceLogonRight)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.UpdateAccountIfNeeded(SqlBrowserPublicConfig publicConfigSqlBrowser)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ConfigUserProperties(SqlBrowserPublicConfig publicConfigSqlBrowser)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.ExecConfigNonRC(SqlBrowserPublicConfig publicConfigSqlBrowser)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.SelectAndExecTiming(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfigBase.ExecWithRetry(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlBrowser.SqlBrowserPrivateConfig.Install(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcbPublicConfig)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)
(01) 2021-01-08 10:10:32 Slp: Inner exception type: System.ComponentModel.Win32Exception
(01) 2021-01-08 10:10:32 Slp: Message:
(01) 2021-01-08 10:10:32 Slp: Falscher Parameter.
(01) 2021-01-08 10:10:32 Slp:
(01) 2021-01-08 10:10:32 Slp: HResult : 0x80004005
(01) 2021-01-08 10:10:32 Slp: Error : 87
(01) 2021-01-08 10:10:32 Slp: Stack:
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.ChangeServiceConfig(UInt32 dwServiceType, UInt32 dwStartType, UInt32 dwErrorControl, String lpBinaryPathName, String lpLoadOrderGroup, String lpDependencies, String lpServiceStartName, SqlSecureString lpPassword, String lpDisplayName)
(01) 2021-01-08 10:10:32 Slp: at Microsoft.SqlServer.Configuration.Sco.Service.ChangeStartAccount(String userName, SqlSecureString password, Boolean bAutoSetServiceLogonRight)
(01) 2021-01-08 10:10:32 Slp: Watson Bucket 1
Original Parameter Values
(01) 2021-01-08 10:10:32 Slp: Parameter 0 : SQL Server 2014@RTM@
(01) 2021-01-08 10:10:32 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.Sco.Service.ChangeStartAccount
(01) 2021-01-08 10:10:32 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.Sco.Service.ChangeServiceConfig
(01) 2021-01-08 10:10:32 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.Sco.ScoException@1211@1
(01) 2021-01-08 10:10:32 Slp: Parameter 4 : System.ComponentModel.Win32Exception@-2147467259
(01) 2021-01-08 10:10:32 Slp: Parameter 5 : SqlBrowserConfigEngAction_install_ConfigNonRC
(01) 2021-01-08 10:10:32 Slp: Parameter 6 : INSTALL@CONFIGNONRC@SQL_ENGINE_CORE_INST
(01) 2021-01-08 10:10:32 Slp: Parameter 8 : 87
(01) 2021-01-08 10:10:32 Slp:
Final Parameter Values
(01) 2021-01-08 10:10:32 Slp: Parameter 0 : SQL Server 2014@RTM@
(01) 2021-01-08 10:10:32 Slp: Parameter 1 : 0x3007A5B0
(01) 2021-01-08 10:10:32 Slp: Parameter 2 : 0x0AC2A120
(01) 2021-01-08 10:10:32 Slp: Parameter 3 : 0xD3BEBD98@1211@1
(01) 2021-01-08 10:10:32 Slp: Parameter 4 : 0xDC80C325
(01) 2021-01-08 10:10:32 Slp: Parameter 5 : SqlBrowserConfigEngAction_install_ConfigNonRC
(01) 2021-01-08 10:10:32 Slp: Parameter 6 : 0x50806C41
(01) 2021-01-08 10:10:32 Slp: Parameter 8 : 0xEDDA9E37
As far as I understand it, the invalid parameter applies to ChangeServiceConfig method and the parameter which causes error is Parameter 8 which is lpPassword - please correct me if I'm wrong. But if it's so, then what password does it relate to? The engine is installed by our setup and the only password that is being set is the one to the SQL Server instance. Please give me some hints on how to remedy this problem.
Additional info: installation has been run as admin and before it the antivirus (BODYGUARD) had been disabled.