What version of Tableau are you using? Is Tableau Server in use or is this just desktop? If you are using Server, you could utilize a Tableau server data source with the authentication managed by the server. Is there a reason the password is being missed frequently?
A read only account is also a good practice since Tableau should never create a query that modifies the db.
Also - i did find out that there was an issue that existed that was fixed in 9.3.7 that addressed an issue similar to this so if you have an earlier version than that, the recommendation for a solution will be to upgrade.
Hi Patrick ,
currently we are using 9.3.1v, no server is in use at that time only desktop , and password miss match is happened unfortunately and after account got locked , to know the root cause i tested with different DB with wrong password ...
Can you please share the link stating that isuue os fixed in 9.3.7 or issues exits befor versions.
I do not see the note in the release notes but the issue identified and fixed relates to MS-SQL data sources and a blank password field. The issue was identified as defect 548615 and this has been resolved in 9.3.7.
You can download a copy of Desktop for a newer version, install it on the same pc and use the same license to test. Tableau allows you to run concurrent versions of the software on the same PC. (I run 6 versions) but be aware that the last version installed will be the default one used for opening a .twbx file or .twb file if you click on these in file explorer. I suggest just testing out with a newer version to verify it is resolved.
I hope that helps.