14 Replies Latest reply on Feb 29, 2016 4:25 AM by Tharashasank Davuluru

    SQL Server impersonation issue

    Surendra Masupalli

      Hi All,

       

      I've a small issue with SQL server impersonation configuration.

       

      To give the details, I'm using live connection to a MS SQL Server Database in one of my workbooks (published with impersonate via server run as account) and the tableau service account has db owner permissions to that database.

       

      When I grant a user access to that database, his access to the tableau workbook on the server works fine. However when I remove his access to that database on SQL Server, he is still able to access the workboook.

       

      Pls let me know if this is a limitation or am I missing some setting anywhere. Kindly help me.

       

       

      Thank you!

      Surendra