4 Replies Latest reply on Feb 6, 2015 8:36 AM by Eric McDonald

    Extract Refresh SQL Server Connection Error

    Eric McDonald

      Tableau Server Version: 8.2.5 (64 bit)

      SQL Server Database Version: SQL2012 Service Pack 2


      We're getting the following error when trying to run an extract refresh against a SQL Server connection. This connection works in Desktop 8.2.5 (64 bit) but not on Server. We have other SQL Server connections on Server which work correctly. The extract connection runs as service account and has correct permissions. The connection is set up as a Microsoft SQL Server connection (for some reason the error mentions ODBC).


      Error Message:

      com.tableausoftware.nativeapi.dll DataSourceException: To connect to <server\instance> database, you must install at least version 10.0 of teh driver. Version 0.0.0 of the driver is currently installed. Visit www.tableausoftware.com/drivers to download driver setup files.

      [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

      Unable to connect to the server "<server\instance>". Check that the server is running and that you have access privileges  to the requested database.