[wix-users] SqlExtension Incompatible with TLS 1.2 , unable to Create Database

[Herman van Drie]

I imagine SQLExtension is written in dotNet 3.5 or older. So, you have to first configure dotNet on underlying OS to tell it needs to use TLS 1.2 using a few reg entries:

32 bit  on 64 bit:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v2.0.50727]       "SystemDefaultTlsVersions" = dword:00000001       "SchUseStrongCrypto" = dword:00000001 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]       "SystemDefaultTlsVersions" = dword:00000001       "SchUseStrongCrypto" = dword:00000001


Native 32 or 64 bit:

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v2.0.50727]       "SystemDefaultTlsVersions" = dword:00000001       "SchUseStrongCrypto" = dword:00000001 [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319]       "SystemDefaultTlsVersions" = dword:00000001       "SchUseStrongCrypto" = dword:00000001


https://docs.microsoft.com/en-us/mem/configmgr/core/plan-design/security/enable-tls-1-2-client

Sent from Surface Duo
________________________________
From: wix-users <wix-users-bounces at lists.wixtoolset.org> on behalf of ronald mantay via wix-users <wix-users at lists.wixtoolset.org>
Sent: Tuesday, July 26, 2022 6:29:50 PM
To: wix-users at lists.wixtoolset.org <wix-users at lists.wixtoolset.org>
Cc: ronald mantay <ronald.mantay at hotmail.co.uk>
Subject: [wix-users] SqlExtension Incompatible with TLS 1.2 , unable to Create Database

Hi

Am failing to create a sqlserver 2016 database on a windows 2016 , via wix SqlExtension , using wix 3.14.0.6526 , with tls 1.0&1.1=off and tls1.2=on I.e
Error -2147221164 : failed to create sql database


Github wixtoolset #5794 , #5543 , lead me to believe there were previous problems in this area , are they resolved  and how ?

Any information is gratefully received

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows


____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/