1 Reply Latest reply on Oct 10, 2016 6:18 AM by lenaic.ridinger

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

    Larsen Rennie

      Hello All

       

      I am facing one issue in which we have  dashboards which are published to the Tableau server. Earlier it was working fine but  sql logons to all all database got discontinued as told by our dba team and all sql logins got deleted. Now the authetication to connect with the sql server is windows authentication and we have published the twb file to the tableau server but still i am getting the above error message that To open this view, you must sign in to the database that the view uses" When Viewing Workbook Published.

       

      Can anybody please suggest me what will be the workaround for this ? do we need to tell the dba team to add the tableau account in the server to make the things smooth again

       

      as i checked with DBA team has told that they  have given tableau accounts read and write permission from the Database side but still when we open the view in the server its display the same error message .

       

      Thanks in Advance

       

      Sunil Tikar

       

       

       

      Regards

      Larsen

        • 1. Re: Error Message: "To open this view, you must sign in to the database that the view uses" When Viewing Workbook Published

          Hi Larsen Rennie,

           

          I have two different recommendations regarding the issue you are experiencing:

           

           

          FIRST TRY:

          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.

          Check if the issue still occurs. If yes, do the following, depending on your environments.

           

           

          ◘ THEN TRY:

          • Verify that Viewer Credentials is the chosen authentication option when publishing. For more information, see Embedding Passwords and Authentication.
          • Verify in Active Directory that the Delegation tab for the Tableau Server Run As User is configured as follows: 
            • Verify that the Tableau Server Run As User Service Principal Name (SPN) matches the server name in the connection properties of the workbook or data source. For example, if the workbook is connecting to: server.acme.com, verify that the Run As User has one of the following SPNs added to the Delegation tab: 
              • For Microsoft SQL Server: MSSQLSvc/server.acme.com
              • For MSAS: MSOLAPSvc.3/msas-server.acme.com
            • Trust this user for delegation to specified services only is enabled
            • Use Any authentication protocol is enabled.
          • Verify that there are no duplicate SPNs which match the server name by running the following command: setspn -X

           

           

          OR

          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.