KNOWLEDGE BASE

Using Windows Authentication to Connect to a SQL Server Data Source from a Mac Computer Running Tableau Desktop


Published: 26 Apr 2017
Last Modified Date: 26 Apr 2017

Question

How to connect to a SQL Server data source using Windows authentication from a Mac computer running Tableau Desktop.

Environment

  • Tableau Desktop
  • Mac OS
  • MS SQL Server

Answer

You will need to use the Kinit utility to obtain and cache a Kerberos ticket before you will be able to use Windows Authentication to sign in to Microsoft SQL Server. The kinit utility is included with Mac OS X.

Two sets of steps are provided: One set is for users who are not currently signed in to the same corporate domain as SQL Server, and another set for users who are. If you are not sure whether or not you are signed in to the corporate domain, do the following:

  1. Open the Terminal application on the Mac (Applications > Utilities > Terminal)

  2. Type klist at the prompt, and press Return.

  3. If the result is No credentials cache file found, you are not joined to a corporate domain. (For example, you may be accessing SQL Server using a VPN.)

  4. In this case, you should follow the "Steps for Users Not Joined to the SQL Server Domain," below.


When in doubt, use the steps for users not joined to the SQL Server domain.

Steps for Users Not Joined to the SQL Server Domain

If you are signed in to the Mac as a local user and are not joined to the SQL Server corporate domain, you must obtain the following information before setting up authentication:

  • Active Directory user name

  • Domain (specifically, the fully qualified domain name)

  • Active Directory password

Follow these steps:

  1. Start Terminal (Applications > Utilities > Terminal).

  2. Type kinit <Active Directory user name>@<domain> at the prompt, using your actual Active Directory user name and domain.

  3. When prompted, enter your Active Directory password.

  4. Start Tableau Desktop.

  5. Click Connect to Data and then select Microsoft SQL Server.

  6. In the Server box, type the server's fully qualified domain name (such as mydb.test.ourdomain.lan).

  7. Select Use Windows Authentication, enter your Active Directory user name and password, and click Connect.

Steps for Users Who Are Joined to the SQL Server Domain Using Active Directory Credential

If you are signed in to the Mac as a local user and signed in to a corporate network using Active Directory credentials, you must obtain the following information before setting up authentication:

  • Active Directory user name

  • Active Directory password

Follow these steps:

  1. Start Terminal (Applications > Utilities > Terminal).

  2. Type kinit <Active Directory user name> at the prompt, using your actual Active Directory user name.

  3. When prompted, enter your Active Directory password.

  4. Start Tableau Desktop.

  5. Click Connect to Data and then select Microsoft SQL Server.

  6. In the Server box, type the server's fully qualified domain name (such as mydb.test.ourdomain.lan).

  7. Select Use Windows Authentication, enter your Active Directory user name and password, and click Connect.

Did this article resolve the issue?