My client is running Microsoft Dynamics NAV 2018 on a Windows Server 2022 with SQL Server 2022.
My client is connecting to the SQL Database from the Development client over the Internet, so it's using the ODBC connection. When they attempt to connect it errors out, but when you attempt to connect from the server that is running the Database it works just fine.
When I attempt to connect to the Database using SSMS over the internet works just fine, but I do have to enable "Trust Server Certificate" in SSMS to get connected. My best guess is that I need to enable something like this in the Development client or the ODBC Driver my computer is using.
Any thoughts on this?