---
schema_version: "1"
id: 457e2dd6a9a2dd08c3d5a89f26f38b5df636843e7588e5efc2071117eddc2458
title: Impersonate with Embedded SQL Credentials
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/server/impers_SQL.md
canonical_url: https://help.tableau.com/v0.0/server/en-gb/impers_SQL.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 0e9221534fa2fff053c7ee9fcc385798d69787af4cbef870676ec65d4b83d8a7
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-gb/maintenance_set.htm) must be enabled on the server Settings page in Tableau Server:

![A tick box to enable embedded credentials.](/tableau/next/en-gb/server/en-gb/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-gb/server/en-gb/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-gb/server/en-gb/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 authorised to see.