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.