Issue
When opening a view on Tableau Server, the following error might occur:To open this view, you must log on to the database that the view uses.
Last Modified Date: 21 Dec 2017
To open this view, you must log on to the database that the view uses.
Environment
- Tableau Server
- Microsoft SQL Server
Resolution
Option 1
Embed the credentials of the data source before publishing. Read more about this topic in Tableau Help: Connecting to Data Sources.Option 2
Configure SQL Server to use impersonation. For more information, see SQL Server Impersonation.Option 3
- Sign n to Tableau Server from Tableau Desktop.
- Publish workbook to Tableau Server.
- In the Publish Workbook to Tableau Server dialog box, click Authentication....
- In the Authentication drop-down menu, select Server Run As account and click OK.
- Click Publish to publish to Tableau Server.
Cause
Tableau Server prompts for credentials when workbooks are published without changing authentication to none.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials