BASE DE CONNAISSANCES

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


Date de publication : 27 Apr 2022
Date de dernière modification : 09 Dec 2022

Problème

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.

Environnement

  • Tableau Prep Builder 2021.4.3

Informations supplémentaires

This issue is specific to the use of Other Databases (ODBC) to connect to SQL Server data source.
Cet article vous a-t-il permis de résoudre le problème ?