My workbook connects to a MS SQL database and authenticates using AD.
When I publish a datasource to Tableau Server in this setup, I'm only given 2 options for authentication...
What I actually want is for the published data source to authenticate against MS SQL DB using the user's AD account (either SSO or prompt the user).
How do I achieve this? (ultimately, I need the queries Tableau Server issue against the DB to be pegged against each user name not against the Run-As-Account).
Incidentally.... I see 'Prompt User' option is available for Oracle DB connections but not for MS SQL.
Hi Johny ,
What about using Prompt with the worksheet itself that should be possible with My SQL as well
Connecting to MySQL and save username and password
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...