[wix-users] SQLDatabase: CreateDatabase fails after disablingTLS 1.0

[Sudripta Nandy]

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/