Team
While publishing a twbx workbook to Tableau server, it gives me the following error message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Login failed for user 'CORP\XXXX'." on a live connection.
I am using SQL Server Management Studio 2016 and Tableau Desktop and Server 2020.3. I went through all the forum questions and the solution I got was to uninstall the ODBC driver. I have Microsoft SQL Server ODBC driver 17.3.1.1 installed at present. Will it hamper anything else if I uninstall it or any other changes I need to make?
Post uninstalling do I need to install SQL Native Client for SQL Server (if yes that has to be done on the developer side or should I contact the server team) ?
TIA
-Mary
You need some driver installed, and generally the newer the better. Since you have ODBC driver 17 on your machine, and apparently ODBC driver 13 on the server, the best thing to do is probably upgrade the driver on the server. But you can downgrade the driver on your desktop to match the server and that might help.
Tableau's recommended drivers are at https://www.tableau.com/support/drivers
Dan
