Could not connect to a SQL Server data source using ODBC connector with ODBC SQL Server Driver in Tableau Prep Builder 2021.4 with the error below:
An error occurred while communicating with Other Databases(ODBC).
[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open database "XXXX" requested by the login.
Login failed. Additional configuration is required for generic ODBC.
The driver and DSN (data source name) must be installed and configured to verify the connection.
Cannot connect using a DSN named "XXXX".
Please verify that the DSN exists and is a valid connection.