0 votes
1 view
in BI by (47.2k points)

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? 

1 Answer

0 votes
by (17.6k points)
  • The problem lies on the SQL Server side. Your ODBC driver is trying to use a trusted protocol version (TLS 1.1 or TLS 1.2) but your SQL server is only supporting deprecated protocol versions (SSL 3.0 or TLS 1.0).

  • You need to get your SQL Server upgraded to one of the versions or CUs referred to in Microsoft's KnowledgeBase article 3135244.

supporting documentation:

You can check Tableau Desktop Specialist Certification program to learn more about tableau from basic to advance level. 

Welcome to Intellipaat Community. Get your technical queries answered by top developers !