Windows 10: After october update oledb connection to SQL Server 2022 fails. did something change?

//// Fetch the row// hResult = m_SelectCommand.MoveFirst; if FAILEDhResult { m_LastError = FormatResulthResult; return false; }Fails at line ATLASSUMEm_pAccessor != NULL;in atldbcli.h

:)

 

SQL Server remote connection fails

I'm trying to install SharePoint 2019 and the remote connection to my SQL Server is failing. I've set up the firewall rules on SQL Server, allowed TCP and UDP ports 1433 and 1434 and have allowed the sqlservr.exe program in the inbound rules.

The user that's being used in the SP install wizard is an active AD domain user. I can ping the server by IP address and by name but it seems that SQL Server never receives the connection attempt.

As a test I set up a .udl file on the SharePoint host and tried to connect to the SQL Server and the connection still failed. It's not just the SP installer but something is preventing connections to SQL. I've searched the web and tried every tutorial and
suggestion but it's still failing.

Is there anything else I can check? This should not be as difficult as it has been and I'm wondering if something else is preventing the connection.

I appreciate any help.

 

Does Azure DevOps Server 2022 supports SQL Server 2022 ?

Hello Team,

As per below URL Azure DevOps Server 2022 supports SQL Server 2019, but the EOL for SQL Server 2019 is 28th Feb 2025.

So my question is does Azure DevOps Server 2022 supports SQL Server 2022 ? if not by when we can expect the same.

Thank you.

Setup & upgrade requirements - Azure Dg:type

 

MSOLEDBSQL19 driver seems to ignore TrustServerCertificate=yes if SQL Server Force Encryption is yes

• Microsoft SQL Server 2019 with DGR 2101 (KB5021125) is installed on a Windows Server 2019 computer.
  
• The SQL Server has a self-signed certificate and is configured with Force Encryption = yes.
  
• A Windows Server 2012 R2 computer has Microsoft OLEDB Driver 19 for SQL Server installed (v19.3.1.0).
  
• An application is running on this server that uses OLE DB to reach the SQL Server. The connection string is:
  

The connection fails with: "SSL Provider: The certificate chain was issued by an authority that is not trusted."

Yes, that is true, but I am specifying "TrustServerCertificate=yes;" in the connection string. It does connect OK if Force Encryption = no on the SQL Server but gives this certificate chain error if Force Encryption = yes.

Why is the driver ignoring the "TrustServerCertificate=yes" connection string parameter?

Note: On the W 2012R2 server, registry value: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\SNI19.0\GeneralFlags\Flag2 = 0x1.

Thank you.