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

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"

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

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.