KNOWLEDGE BASE

Error "Kerberos timeout" Signing in to SQL Server from Tableau Desktop on the Mac


Published: 28 Jul 2014
Last Modified Date: 30 Jan 2018

Issue

When you try to use Active Directory authentication to sign in to Microsoft SQL Server from Tableau Desktop on the Mac, the following error might occur:

An error occurred while communicating with the Microsoft SQL Server Database data source '<data source name>'.
Your connection to SQL Server could not be established or was lost, most likely because of a Kerberos timeout. To renew your Kerberos ticket, close tableau and then try any of the following:
  • Lock and unlock your Mac
  • Log out from your Mac and then log in again
  • If your Local User account is different from your Active Directory account, run the following command in Terminal: knit <ADUsername@domain>. For example: kinit myuser@mycompnay.
[Simba][Support](50260) Integrated security authentication failed. (Routine Error:
Miscellaneous failure (see text)
Mechanism Info:
Server (MSSQLSvc/<ADUsername@domain>) unknown while looking up 'MsSQLSvc/
<ADUsername@domain>' (cached result, timeout in <number> sec)

Environment

  • Tableau Desktop 8.20 - 8.2.3
  • OS X
  • Microsoft SQL Server
  • Active Directory
Did this article resolve the issue?