Install a french version of SQLServer on an english windows server with ansible

[Jean-Yves LENHOF]

Hi,


I try to silently install a french version of SQLServer (this is not my
idea, it's become this is the licensed version we have) with ansible
using some code like this (I already installed MUI French lang pack via
ansible) :

- name: "Change LANG"
win_shell: |
Set-WinUILanguageOverride -Language fr-FR

- name: "Silent Install of SQL Server 2019"
win_shell: |
D:\SETUP.EXE
/ConfigurationFile=c:\Windows\ansible_SQLSERVER2019_EXPRESS_ConfigurationFile.ini
/SAPWD=MySuperPassw0rd /IAcceptSQLServerLicenseTerms

But it keeps saying that there's something wrong with my language...

fatal: [myserver]: FAILED! => {
"changed": true,
"cmd": "D:\\SETUP.EXE
/ConfigurationFile=c:\\Windows\\ansible_SQLSERVER2019_EXPRESS_ConfigurationFile.ini
/SAPWD=MySuperPassw0rd /IAcceptSQLServerLicenseTerms",
"delta": "0:00:00.531238",
"end": "2021-06-24 04:13:53.809159",
"msg": "non-zero return code",
"rc": 1,
"start": "2021-06-24 04:13:53.277921",
"stderr": "",
"stderr_lines": [],
"stdout": "This SQL Server setup media does not support the language
of the OS, or does not have the SQL Server English-language version
installation files. Use the matching language-specific SQL Server
media; or install both the language specific MUI and change the format
and system locales through the regional settings in the control
panel.\r\n\r\n\r\n\r\n",
"stdout_lines": [
"This SQL Server setup media does not support the language of
the OS, or does not have the SQL Server English-language version
installation files. Use the matching language-specific SQL Server
media; or install both the language specific MUI and change the format
and system locales through the regional settings in the control panel.",
"",
"",
""
]
}

But If I'm connecting on the server the UI Lang is changed to French (so
this part seems to work) and if I run the command line on powershell it
succeed.
On Linux I would have just surcharged LANG parameter before my command
but on windows, I think this is not possible...

Is there's something on ansible which force the language to english ?
If not, is someone has an idea on what's going on...

Thanks


Regards,

--
Jean-Yves LENHOF
jean...@lenhof.eu.org

[Jean-Yves LENHOF]

Fucking off Windows !

Little followup, because that was a quite difficult one to found.
It seems that windows does'nt directly changed tue UI Language when we
do it programmatically.... the configuration is pending an interactive
connection to that user make actually the change
Here's the registry key difference I found (note the pending in the
entry) :

Control Panel\Desktop

-"PreferredUILanguages"=hex(7):66,00,72,00,2d,00,46,00,52,00,00,00^M
+"PreferredUILanguagesPending"=hex(7):66,00,72,00,2d,00,46,00,52,00,00,00^M

I will have just to create directly this key in the hive of my ansible
user to have the right language directly I think...