---
schema_version: "1"
id: 63b9a3951c0d50002eadc9ee584d032360202df5f8d41b3de35a085fc73025b8
title: Impersonate with Embedded SQL Credentials
collection: tableau
version: next
locale: en-us
portal_url: https://docs.salesforce.com/tableau/next/en-us/server/impers_SQL.md
canonical_url: https://help.tableau.com/v0.0/server/en-us/impers_SQL.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 3b12cea5539b9e4e5d190a52d25323af7cb45ea86e42a163a382a86ae1b2cd4b
description: Configure SQL Server impersonation using embedded SQL credentials.
---
[Skip to main content](#main-content)

# Impersonate with Embedded SQL Credentials

You can also perform impersonation by having the person who publishes a view embed their SQL Server account credentials in the view. Tableau Server can be running under any type of account, but it will use these credentials, supplied by the publisher, to connect to the database.

This may be the right choice for your site if the account that handles the impersonation cannot be an Active Directory (AD) account and if you’re comfortable giving workbook publishers an account with a potentially high permission level on SQL Server.

**Note:**

To use this approach, [Embedded Credentials](https://help.tableau.com/v0.0/server/en-us/maintenance_set.htm) must be enabled on the server Settings page in Tableau Server:

![A checkbox to enable embedded credentials.](/tableau/next/en-us/server/en-us/Img/embedded.png)

To impersonate with the workbook publisher’s SQL account:

1. In Tableau Desktop, create a workbook. When you create the data connection, select Use a specific username and password for the workbook's live connection to a SQL Server database:
    
    ![SQL Server Connection configuration window with the option to log on to the server using a specific username and password selected.](/tableau/next/en-us/server/en-us/Img/impers_SQL_sql.png)
2. Publish the workbook to Tableau Server (Server > Publish Workbook).
3. In the Publish dialog box, click Authentication, then in the Authentication dialog box, select Impersonate via embedded password from the drop-down list:
    
    ![Authentication dialog box with the “Impersonate via embedded password" option circled.](/tableau/next/en-us/server/en-us/Img/impers_sql_publish.png)
4. Click OK.
5. Test the connection by signing in to Tableau Server as a user. When you click a view, you should not be prompted for database credentials and you should only see the data the user is authorized to see.