KNOWLEDGE BASE

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


Pubblicato: 27 Apr 2022
Data dell'ultima modifica: 09 Dec 2022

Problema

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.

Ambiente

  • Tableau Prep Builder 2021.4.3

Ulteriori informazioni

This issue is specific to the use of Other Databases (ODBC) to connect to SQL Server data source.
Con questo articolo hai risolto il problema?