KNOWLEDGE BASE

Error Message: "To open this view, you must sign in to the database that the view uses" When Viewing Workbook Published With Run As User Account


Published: 15 Oct 2014
Last Modified Date: 05 May 2016

Issue

When you open a view with a live connection to Microsoft SQL Server that was published with the Tableau Server Run As User Account authentication option, the following error might occur:
To open this view, you must sign in to the database that the view uses.

Environment

  • Tableau Server
  • MS SQL Server
  • Windows Authentication

Resolution

  1. Sign in to Tableau Server.
  2. In the upper right-hand corner, click <username> > My Account Settings.
  3. Under Saved Credentials, click Clear All Saved Credentials.
 

Additional Information

If the issue arises for all users, ensure that the Run As User account has the correct permissions to sign in to SQL Server and view the tables used in the workbook.
Did this article resolve the issue?