Tableau driver problem querying SQL 2012
Posted by Diego em Fevereiro 25, 2014
Just sharing a situation I’ve been through these past few days.
After updating a SQL Server Instance from 2008R2 to 2012, a dashboard that connected to a DB on that instance – and was working perfectly fine – started to produce a “driver not found ” error.
After some digging I realized that the problem was due to a particular GROUP BY clause. If the group by was there, I got the error, otherwise not.
Checking the XML, I realized that, on the presence of the GROUP BY, tableau was adding the highlighted clause bellow to the connection tag:
<connection authentication=’sqlserver’ class=’sqlserver’ dbname=’XXXXX’ minimum-driver-version=’SQL Server Native Client 10.0′ odbc-native-protocol=’yes’ server=’XXXX’ username=’XXXXX’ workgroup-auth-mode=’prompt’>
It’s clearly telling you that the minimum driver necessary to that operation is the Native client for SQL 2008.
First thing I wondered was: why didn’t tableau put this clause before when the DB was SQL 2008? – I don’t really have an answer to this question.
To fix the problem I had to install the Microsoft SQL Server 2012 SP1 Native Client x64 (version 11.0.2100.60) driver (found here http://www.tableausoftware.com/support/drivers), which felt a little strange because:
1) I didn’t have to install the above driver to query SQL 2012 in the first place (any queries without the GROUP BY clause where working)
2) The dependency clearly says native client version 10 (which was installed) – not sure why only v11 fixed the problem.
Anyway, just sharing the information.