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

Archives Ansible Project
1

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,

2

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

Regards,