KNOWLEDGE BASE

Cannot Connect To Sql Server Using Windows Authentication After Upgrading Tableau Desktop On Mac


Published: 18 Mar 2021
Last Modified Date: 19 Mar 2021

Issue

When connecting to MS SQL Server, getting Error Code: 06DA155A after Desktop upgrade to 2020.4.1 on Mac using Active Directory

1) "[Simba][ODBC] (11570) Required credential settings missing: {[PWD] [UID]}.\n[Simba][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[PWD] [UID]}\n"

OR

2)"[Simba][SqlServer] (18456) Login failed for user"

OR

3) "[Simba][SqlServer] (18456) Login failed for user 'user\\username'.\nThis may indicate that the database name is incorrect."

Environment

  • Tableau Desktop 2020.4.1
  • MS SQL Server
  • macOS 10.15
  • Active Directory

Resolution

There can be 2 different solutions depending upon the requirement.

Option 1

Use SQL Authentication instead of Windows Authentication.
Error "[Simba][SqlServerODBC] (15) Failed to connect to the SQL Server instance: [28000]" Connecting to Azure SQL on Mac

Option 2

If using Active Directory the workaround would be:
1. Reinstall the 1.5.5 driver.
2. Use the TDC file provided in attachments (mssql_integrated.tdc) which will add ‘Integrated Security=true’ to the connection string.
3. Save it to Documents\My Tableau Repository\Datasources.
Help Article: (Use the TDC file with Tableau Desktop)
4. Restart Tableau Desktop.

5. Connect to the SQL Server.

 

Cause

Simba SQL Server ODBC driver v1.5.5 requires 'Integrated Security=true' in the connection string for NTLM & Kerberos Windows Authentication on Mac.



 
Did this article resolve the issue?