[Bug 40131] New: SqlConnection to Microsoft SQL Server 2014 fails with SSL error

https://bugs.winehq.org/show_bug.cgi?id=40131

Bug ID: 40131
           Summary: SqlConnection to Microsoft SQL Server 2014 fails with
                    SSL error
           Product: Wine
           Version: 1.8
          Hardware: x86
                OS: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: -unknown
          Assignee: [e-mail]
          Reporter: [e-mail]
      Distribution: ---

Created attachment 53627
  --> https://bugs.winehq.org/attachment.cgi?id=53627
Error log (Wine 1.8)

Installed Wine 1.8 in Linux Mint 17.3 and tried to run simple console
application that opens and closes connection to Microsoft SQL Server. This
application works with Mono and fails with Wine.

Attached you can find application text, config file that contains connection
string and two log files - for successfull connection (using Mono) and for
broken connection (using Wine).

[Bug 40131] SqlConnection to Microsoft SQL Server 2014 fails with SSL error

https://bugs.winehq.org/show_bug.cgi?id=40131

--- Comment #1 from Dmitry  ---
Created attachment 53628
  --> https://bugs.winehq.org/attachment.cgi?id=53628
Success log (Mono 4.2.2)

[Bug 40131] SqlConnection to Microsoft SQL Server 2014 fails with SSL error

https://bugs.winehq.org/show_bug.cgi?id=40131

--- Comment #2 from Dmitry  ---
Created attachment 53629
  --> https://bugs.winehq.org/attachment.cgi?id=53629
Application text

[Bug 40131] SqlConnection to Microsoft SQL Server 2014 fails with SSL error

https://bugs.winehq.org/show_bug.cgi?id=40131

--- Comment #3 from Dmitry  ---
Created attachment 53630
  --> https://bugs.winehq.org/attachment.cgi?id=53630
Config file

[Bug 40131] SqlConnection to Microsoft SQL Server 2014 fails with SSL error

https://bugs.winehq.org/show_bug.cgi?id=40131

--- Comment #4 from Dmitry  ---
So application fails with exception:

System.Data.SqlClient.SqlException (0x80131904): A connection was successfully
established with the server, but then an error occurred during the login
process. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake
failed)

I've tried different servers and different connection string properties like
Encrypt=True or TrustServerCertificate=True or PersistSecurityInfo=True but got
the same result. Furthermore checked that ForceEncrypt SQL Server parameter is
False.

[Bug 40131] SqlConnection to Microsoft SQL Server 2014 fails with SSL error

https://bugs.winehq.org/show_bug.cgi?id=40131

Vlt  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[e-mail]

--- Comment #5 from Vlt  ---
Just wanna add that I also had that problem (when used ZorinOS).
If I installed the 64bit version of the OS it'd give me that exact same error.
When I switch to 32bit version, it'd run fine.

I read some posts on how to try to fix that, change some SSL settings,
libraries, etc but could never solve the problem (I'm a Windows power user/dev,
but have very few experience with Linux) but I hope this helps.

[Bug 40131] SqlConnection to Microsoft SQL Server 2014 fails with SSL error

[WineHQ Bugzilla]

https://bugs.winehq.org/show_bug.cgi?id=40131

Damjan Jovanovic  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEEDINFO
     Ever confirmed|0                           |1
                 CC|                            |[e-mail]

--- Comment #6 from Damjan Jovanovic  ---
This might have been fixed by the commit below, please retest with a recent
Wine version.

I also experienced Mono working but .NET broken, before this was fixed. And I
got either that exception or a very similar one.

commit de9238962c237f0d4463199a0a1f9f6b6835aed5
Author: Damjan Jovanovic <damjan.jov at gmail dot com>
Date:   Thu Jan 28 19:02:39 2021 +0200

secur32: Implement the SECPKG_ATTR_UNIQUE_BINDINGS context attribute.

.NET's System.Data.SqlClient needs this to connect to MSSQL Server.