1 Reply Latest reply on Feb 9, 2015 2:18 PM by diego.medrano

'Impersonate via server run as account' Authentication

Rishabh Dhingra Feb 8, 2015 8:56 PM

Hi,

I am connected to a relational database using "Window NT Integrated Security" and then using custom SQL query. I have published the workbook on Tableau Server 8.3 using the data source authentication method 'Impersonate via server run as account' account

However, I am getting an error while accessing the view on the server. Could someone help me in understanding how 'Impersonate via server run as account' works? And also when users try to access, do we need to add their individual accounts to the SQL database?

Currently we have AD groups to manage database access.

My windows account:- Rishabh Dhingra

Tableau Server Run as Account:- XYZ

Thanks,

Rishabh

1. Re: 'Impersonate via server run as account' Authentication

diego.medrano Feb 9, 2015 2:18 PM (in response to Rishabh Dhingra)

Hey Rishabh,

First things first, make sure you are not using Windows NT Integrated Security as your run-as user. Then, make sure the user you are trying to impersonate with has permission in the SQL database to impersonate as the users you want to access the data. This online help article helps set up impersonation on Tableau's end:

Impersonate with a Run As User Account

While this article helps to set up impersonation on the SQL server (bottom of article):

Resolving SQL Server Impersonation Errors | Tableau Software

Let me know if you have other questions,

Diego
Like Show 0 Likes(0)

Actions

Tableau Community

'Impersonate via server run as account' Authentication

1. Re: 'Impersonate via server run as account' Authentication

Actions

More Like This