How can I establish connectivity between Tableau and SQL Server?

Highlighted
New Member

How can I establish connectivity between Tableau and SQL Server?

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 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: How can I establish connectivity between Tableau and SQL Server?

@tobimarsh43 ,

 

Not sure if this will help, but have you looked at this article from Tableau?

 

https://help.tableau.com/current/pro/desktop/en-us/examples_sqlserver.htm

 

Rob