The customer cannot install developer version under system account

Microsoft

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:

Lyle_Xu_0-1726130984649.png

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
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.m...

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.
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...