IssueWhen 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.
ResolutionOption 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.
CauseTableau Server prompts for credentials when workbooks are published without changing authentication to none.
Did this article resolve the issue? Thank you for providing your feedback on the effectiveness of the article. Click here to return to our Support page. Open new Case Open a new case Continue Searching Click here to go to our Support page. Knowledge Base Get detailed answers and how-to step-by-step instructions for your issues and technical questions. Community Find and share solutions with our active community through forums, user groups and ideas. Product Help Browse a complete list of product manuals and guides. Available online, offline and PDF formats. Training and Tutorials Learn how to master Tableau’s products with our on-demand, live or class room training.