I have a Windows machine with SQL Server Management Studio (SSMS) and Tableau Desktop installed. From SSMS I can connect to a database on another machine. However, when I try to connect to the same database from Tableau Desktop I get the following error.
Could not connect to server
[Microsoft][ODBC Driver 13 for SQL Server]SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm.
[Microsoft][ODBC Driver 13 for SQL Server]Client unable to establish connection
I tried to update the SQL Server drivers on the machine but they are already updated to the latest version. How can I establish connectivity between Tableau and SQL Server?