I am setting up 32 and 64 bit ODBC connections on 2 identical SQL Servers running SQL 2019 CU18. These are part of the same cluster with AOAG. The primary node gave no problems with 32 or 64 bit ODBC(both readwrite and read only connections). The 32 bit ODBC on the secondarary also gave no problems(readwrite and readonly). When I tried to create the 64 bit ODBC connection on the secondary using SQL Server Native Client 11.0, I get the below error as soon as I click the drop down to select the default DB.
We do have force encryption enabled on SQL Server, but we are using just the default certificates(no self signed or ones bought from a CA).
Why would everything be fine on the primary, but not working for just the 64 bit ODBC on the secondary?