Forum Discussion

Lyle_Xu's avatar
Lyle_Xu
Icon for Microsoft rankMicrosoft
Sep 12, 2024

The customer cannot install developer version under system account

Hi There,

 

When the customer uses winget to install sql server developer edition under user level, everything is fine.

Now the customer wants to use dev box and bake sql server developer edition to their customized image. So they tried to use winget to install sql server developer edition under system account, but there is the error as below:

VERBOSE: Creating MTA thread
{
  "Id": "Microsoft.SQLServer.2022.Developer",
  "Name": "Microsoft SQL Server 2022 Developer",
  "Source": "winget",
  "CorrelationData": "",
  "InstallerErrorCode": 4294967295,
  "ExtendedErrorCode": {
    "ErrorCode": -1978335226,
    "TargetSite": null,
    "Message": "",
    "Data": {
      "Description": null,
      "RestrictedDescription": null,
      "RestrictedErrorReference": null,
      "RestrictedCapabilitySid": null,
      "__RestrictedErrorObjectReference": null,
      "__HasRestrictedLanguageErrorObject": false
    },
    "InnerException": null,
    "HelpLink": null,
    "Source": null,
    "HResult": -1978335226,
    "StackTrace": null
  },
  "RebootRequired": false,
  "Status": "InstallError"
}

 

even not use the winget, just click SQL2022-SSEI-Dev.exe to install under system account, they got the error below:

Question: SQL server developer edition cannot be installed under system account?

Is there any workaround to achieve this?

 

Note: The customer cannot use choco to install...

2 Replies

  • SivertSolem's avatar
    SivertSolem
    Iron Contributor
    The errorcode presented in the "Extended Error Code" segment, "ErrorCode": -1978335226, translates to the following error message:
    APPINSTALLER_CLI_ERROR_SHELLEXEC_INSTALL_FAILED (Running ShellExecute failed)
    See https://github.com/microsoft/winget-cli/blob/master/doc/windows/package-manager/winget/returnCodes.md

    I don't know if that helps.
    If the SQL Server setup successfully installed, you should have a summary.txt file at the following path
    C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\summary.txt

    This will contain the summary of the install, with SQL Server specific error messages.
    • Lyle_Xu's avatar
      Lyle_Xu
      Icon for Microsoft rankMicrosoft
      Thanks Siver. Under System account, double click "SQL2022-SSEI-Dev.exe", it immediately fails. There is no summary.txt generated because it did not start to install...

Resources