KNOWLEDGE BASE

Error "To open this view, you must log on to the database that the view uses" Accessing View


Published: 25 Apr 2013
Last Modified Date: 16 Sep 2015

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. 

Environment

  • Tableau Server
  • Microsoft SQL Server

Resolution

Option 1

Embed the credentials of the data source before publishing. For more information, see Embedding Database Credentials in Tableau Server.

Option 2

Configure SQL Server to use impersonation. For more information, see SQL Server Impersonation.

Option 3

  1. Sign n to Tableau Server from Tableau Desktop.
  2. Publish workbook to Tableau Server.
  3. In the Publish Workbook to Tableau Server dialog box, click Authentication....
  4. In the Authentication drop-down menu, select Server Run As account and click OK.
  5. Click Publish to publish to Tableau Server.

Cause

Tableau Server prompts for credentials when workbooks are published without changing authentication to none.
Did this article resolve the issue?