KNOWLEDGE BASE

Error Occurred When Using ODBC SQL Server Driver with Other Databases(ODBC) Connector in Tableau Prep


Published: 27 Apr 2022
Last Modified Date: 09 May 2022

Issue

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.

Environment

  • Tableau Prep Builder 2021.4.3

Additional Information

This issue is specific to the use of Other Databases (ODBC) to connect to SQL Server data source.
Did this article resolve the issue?