Loading

After publishing with "Run As User" authentication, viewing the workbook results in endless "This view requires access to the <> database."

Julkaisupäivä: Feb 19, 2025
Kuvaus
After publishing a workbook to Tableau Server with "Server Run As Account," "Impersonate via Embedded Account," or "Impersonate via Server Run As Account" authentication, when accessing the view the user is repeatedly asked to enter credentials for the database. For example:

This view requires access to the <> database.
Authenticate with Microsoft SQL Server.
After you click Authenticate with Microsoft SQL Server, you will be presented an authentication page. On that page, provide the correct database credentials to gain access.

After entering credentials, sometimes the view shows "sign in successful", but then always loops back to the authentication request without rendering the view.
 

Cause

The Tableau Server Run As User must be in the Active Directory domain that is being authenticated to the data source and have permission to access the view.
Ratkaisu
  1. Confirm that the Tableau Server Run As User can connect to the database.
  2. Confirm that the Run As User has been granted permission in the database to access the specific tables in use in the dashboard. The Run As User account should have Connect, Select, and Execute permissions for the database.
Knowledge-artikkelin numero

001473198

Liitteet

access error.png

15 KB

 
Ladataan
Salesforce Help | Article