updated ODBC Driver 18 and Entra ID but can no longer Authenticate MS Access to SQL Server

Question

since updating (new computer) using MS Access DB with office 365. I can no longer Authenticate user. I have updated the control string and ODBC Driver but script error still occurs.

upon starting the Access DB the login prompt asks for user, before the password prompt appears the script error shows (see below)

Answer 1

Hi,

check to the breaking changes (Encrypt = true; by default) with ODBC driver 18

https://techcommunity.microsoft.com/t5/sql-server-blog/odbc-driver-18-0-for-sql-server-released/ba-p/3169228

May be you need to add TrustServerCertificate=true to your connection string; or set Encrypt=false.

https://stackoverflow.com/questions/71688125/odbc-driver-18-for-sql-serverssl-provider-error1416f086

Regards