-
1. Re: tableu desktop - Not able to connect to sql server after it updated from Tls1.0 to Tls 1.2
Dan CoryNov 16, 2015 12:57 PM (in response to Mai Huynh)
That's up to the ODBC driver, not Tableau. You probably need to update your ODBC driver as well. You didn't say whether you are using Windows or Mac, or what version of SQL Server, so see Drivers & Activation | Tableau Software and click on the right driver.
I just noticed that Microsoft has a newer ODBC driver version (for Windows) than what Tableau currently has posted. You may need to upgrade to that version direct from the Microsoft website. I've had trouble finding documentation from Microsoft on exactly when TLS 1.2 support was added.
Dan
-
2. Re: tableu desktop - Not able to connect to sql server after it updated from Tls1.0 to Tls 1.2
Mai Huynh Nov 16, 2015 12:54 PM (in response to Dan Cory)I’m using tableau desktop on windows 7. The SQL server to connect is SQL server 2014. Before they applied tls 1.2 to the SQL server, I was able to connect to it (under server/Microsoft SQL Server).
Thanks,
Mai
-
3. Re: tableu desktop - Not able to connect to sql server after it updated from Tls1.0 to Tls 1.2
Dan CoryNov 16, 2015 1:13 PM (in response to Mai Huynh)
Probably you have a version of the ODBC driver that doesn't support TLS 1.2. Try upgrading it using the link I sent above, or directly from the Microsoft site.
What error message do you get?
Dan
-
4. Re: tableu desktop - Not able to connect to sql server after it updated from Tls1.0 to Tls 1.2
Dan CoryNov 16, 2015 1:16 PM (in response to Dan Cory)
The links we have for SQL Server 2012 (and later) are:
https://downloads.tableau.com/drivers/microsoft/2012/x64/sqlncli.msi (64-bit)
https://downloads.tableau.com/drivers/microsoft/2012/x86/sqlncli.msi (32-bit)
You may need to find newer ones on the Microsoft web site.
Dan
-
5. Re: tableu desktop - Not able to connect to sql server after it updated from Tls1.0 to Tls 1.2
Mai Huynh Nov 16, 2015 1:20 PM (in response to Dan Cory)The error was something like ‘.. SQL server native client 11.0 error. An existing connection was forcibly closed by the host. Either the server was not online or you were denied..’
I guess tableau hasn’t supported TLS 1.2 yet.
Thanks,
Mai
-
6. Re: tableu desktop - Not able to connect to sql server after it updated from Tls1.0 to Tls 1.2
Dan CoryDec 8, 2015 1:46 PM (in response to Mai Huynh)
Mai -
We put the newer SQL Server driver from Microsoft on our web site. Try installing that and see if it helps:
https://downloads.tableau.com/drivers/microsoft/2012/x64/sqlncli.msi
Dan
-
7. Re: tableu desktop - Not able to connect to sql server after it updated from Tls1.0 to Tls 1.2
Mai Huynh Dec 8, 2015 2:17 PM (in response to Dan Cory)Thank you. We rolled back to tls1 because of that. I’ll let the network admin know and we will try again.
Thanks,
Mai