Share via

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

Jason Jones 0 Reputation points
2024-05-23T06:33:41.21+00:00

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)

User's image

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,099 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joerg 62 116 Reputation points
    2024-06-09T20:12:15.06+00:00

    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

    0 comments