[wix-users] SQLDatabase: CreateDatabase fails afterdisablingTLS 1.0

[Sudripta Nandy]

Looking more into it, we found that the issue occurs only when we disable 
TLS 1.0 client protocol.



Thanks Mat for the reply.

We were connecting to SQL Server 2016 and now we have installed the ODBC
drivers too from the link
https://www.microsoft.com/en-us/download/details.aspx?id=36434. But the
installation still fails.

Not sure what else we need to do to fix this.


Thanks.
With Regards,
// Sudripta.



-----Original Message----- 
From: Skildum, Mat
Sent: Tuesday, December 6, 2016 6:48 PM
To: wix-users at lists.wixtoolset.org
Subject: Re: [wix-users] SQLDatabase: CreateDatabase fails after
disablingTLS 1.0

Check the version of SQL Server you are connecting too.  Only SQL 2016
supports TLS 1.1 and 1.2 out of the box, for the others you must install the
latest update packages to get this support.  You may also need to update
some of the SQL tools on the system where the install is running depending
on how you are connecting to SQL server as changes were made to ODBC as
well.

Mat Skildum


-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of
sudriptan at sarangsoft.co.in
Sent: Tuesday, December 6, 2016 5:45 AM
To: wix-users at lists.wixtoolset.org
Subject: [wix-users] SQLDatabase: CreateDatabase fails after disabling TLS
1.0


Hello,
    Our setup program was running successfully until we disabled TLS 1.0
keeping TLS 1.1 and 1.2 enabled in our system due to security reasons. We
are using the WIX element 'SQLDatabase' for creating our database and it
seems that it has started failing after the change. Here is the error log
that was generated:

CreateDatabase: Error 0x80004005: failed to check if database exists:
'MyDatabase', error: unknown error Error 26201. Error -2147467259: failed to
create SQL database: MyDatabase, error detail: unknown error.
MSI (s) (AC!80) [06:27:39:850]: Product: MySetup -- Error 26201.
Error -2147467259: failed to create SQL database: MyDatabase, error detail:
unknown error.
CustomAction CreateDatabase returned actual error code 1603 (note this may
not be 100% accurate if translation happened inside sandbox)


Any ideas on how to workaround this problem. We need to use only TLS 1.1 or
1.2 in our system due to security restrictions.


I hope someone has a solution to it. Thanks in advance.


Thanks.
With Regards,
Sudripta.

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant
http://www.firegiant.com/
This email (including any attachments) is proprietary to Aspect Software,
Inc. and may contain information that is confidential. If you have received
this message in error, please do not read, copy or forward this message.
Please notify the sender immediately, delete it from your system and destroy
any copies. You may not further disclose or distribute this email or its
attachments.

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


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