All of the suggestions given here are already tried.
Inside our Azure Windows Server 2012 VM, we've got an Azure SQL database. The ODBC connection string obtained from the Azure portal is:
Driver={ODBC Driver 13 for SQL Server};Server=tcp:databaseDomain.database.windows.net,1433;Database=DB_Name;Uid=user-id;Pwd=password;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;
Also, there is an MS Access application with linked tables
The forms in this app connects to the linked tables through a DSN. The DSN is created as follows:
In the ODBC Data Sources:
SQL Server Native Client 11.0 is selected
Azure SQL Server connection is set
Notice that Windows login is strictly not used
The databases pops up correctly
In the next step, we do everything with defaults
The ODBC DSN setup seems to be succesfull
In the Access app's VBA code, we've updated the above connection string as well
Set cn = New ADODB.Connection
cn.Open "Driver={ODBC Driver 13 for SQL Server};Server=tcp:databaseDomain.database.windows.net,1433;Database=DB_Name;Uid=user-id;Pwd=password;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;"
When any of the linked tables is hovered over, the DSN details shows up properly:
However, when any of the linked tables is tried to be opened, the following error is thrown:
Notice that Windows login is strictly not used, so what is the problem?