[Bug 40107] New: ODBC Connection to MSSQL Server with SSL

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

Bug ID: 40107
           Summary: ODBC Connection to MSSQL Server with SSL
           Product: Wine
           Version: 1.8-rc4
          Hardware: x86
                OS: Mac OS X
            Status: UNCONFIRMED
          Severity: major
          Priority: P2
         Component: -unknown
          Assignee: [e-mail]
          Reporter: [e-mail]

Created attachment 53591
  --> https://bugs.winehq.org/attachment.cgi?id=53591
Connection Test with SSL

Hi,

ODBC with MDAC 2.8 works fine, but if the MSSQL-Server needs SSL the connection
fails.

To Test it, install MDAC 2.8 (winetrick: mdac 2.8)
Control Panel->Data Sources(ODBC)->SystemDSN->Add->SQL Server
Configure a Server without SSL: Everything's fine.
Configure a Server with SSL: Connection fails (See attachment).

I cross-checked this with a Windows 2k VM. Installing MDAC_TYP.EXE.
Configuring the above SQL Servers:
Connection to a SSL encryption enabled SQL Server works.

[Bug 40107] ODBC Connection to MSSQL Server with SSL fails

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

Olaf Schumann  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|ODBC Connection to MSSQL    |ODBC Connection to MSSQL
                   |Server with SSL             |Server with SSL fails

[Bug 40107] ODBC Connection to MSSQL Server with SSL fails

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

--- Comment #1 from Olaf Schumann  ---
update:
I installed the public part of the self-signed certificate with the control
panel->internet settings->content->certificates->import-><choose
file>->automatically select store->Next->Finish
I still can't connect to the SQL-Server with that self signed certificate.

[Bug 40107] ODBC Connection to MSSQL Server with SSL fails

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

--- Comment #2 from Olaf Schumann  ---
Tested it with wine running on Debian Linux. Same error.

[Bug 40107] ODBC Connection to MSSQL Server with SSL fails

[WineHQ Bugzilla]

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

Damjan Jovanovic  changed:

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

--- Comment #3 from Damjan Jovanovic  ---
This might have been fixed by the commit below, please retest.

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.