KNOWLEDGE BASE

Error "TableauException: Database error 0x80040E09: The SELECT permission was denied on the object" Viewing Workbook


Published: 03 Sep 2013
Last Modified Date: 30 Jun 2016

Issue

When viewing a published workbook, the following browser error might occur:

TableauException: Database error 0x80040E09: The SELECT permission was denied on the object 'FlashByQuarter', database 'Bookings', schema 'dbo'. The table "[dbo].[Flash-ByQuarter]" does not exist. Unable to connect to the server "store-dbrepo1". Check that the server is running and that you have access privileges to the requested database.

Additionally, when publishing the workbook using the same data source, the following error might appear in the log file:

Database error 0x80004005: Cannot generate SSPI context

Environment

  • Tableau Server
  • Tableau Desktop
  • MS SQL Server

Cause

The SPN (Service Principle Name) is not assigned to the appropriate container. 
Did this article resolve the issue?