Hi,
My data source is MySQL which is authenticated with a user id and password.
It is working fine on desktop but when the workbook us uploaded on the server, it shows authentication error and scheduled refreshes do not work.
Please see below the error of the screenshot and let me know a solution to it(if any), anyone might have faced this problem.
Hi Calvin,
Are you using older version of tableau. if older version then Try to install mysql driver in tableau server machine and refresh your extract.
Thanks
sankar
Hello Calvin, you publish the workbook with password embedded?
Do you have just MYSQL as data source?
Cheers.
Do you have any other extracts that are connecting successfully to the database from that server ? One of the reasons could be that the network where the server is located doesn't have access to your company/ personal network where the database is.
Regards,
Nerea
Hi Paulo,
Yes I published the workbook with password embedded.
Yes, I have just MYSQL as the data source, but the extraxct refresh is not working
I was using 2018.1 and the upgraded to 2018.2 and republished the file but again the same error.
Actually the tableau server ip was not whitelisted, after whitelisting it, the connection is running properly.
Hi Atishi Goyal, can you please mark my answer as correct or as helpful as it seems that was the issue.
Thank you
Hi Calvin,
please open the log file from Tableau Server, you can get in the Tableau Server installation, data -> tabsvc -> logs -> backgrounder and there you can check the real problem.
This MySQL have firewall or your Tableau Server?
Cheers.