1 Reply Latest reply on Aug 29, 2018 10:59 PM by Ritesh Bisht

    published data source on MS SQL without using Server-Run-As account

    Johnny Huang

      hi guys,

       

        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...

      1. Server Run-As Account
      2. Impersonate via Server Run-As Account

       

        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.