6 Replies Latest reply on Mar 13, 2018 9:49 AM by John Kuo

    Microsoft SQL extract refresh error mystery

    John Kuo

      Hi All,

       

      I'm getting frustrated with SQL Server 2012 extract refresh error. It works on our DEV environment but not PROD and as far as I can tell they have the same drivers installed. I also verified that run as account has access to both environments and they both have been configured for TLS1.2 and above connections.

       

      Here's the error from the admin page:

      om.tableausoftware.nativeapi.dll.DataSourceException: [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host. [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection Unable to connect to the server "CPVWD00A0064\PEISCMP01". Check that the server is running and that you have access privileges to the requested database.

       

      Backgrounder logs:

      {"ts":"2018-01-24T21:23:02.029","pid":90652,"tid":"a7d0","sev":"warn","req":"-","sess":"868D4F8EC62744BB9E8F18E76E08DA1D-2:10","site":"","user":"","k":"msg","v":"throw DataSourceException (type=UnableToConnect): [Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.\r\n[Microsoft][SQL Server Native Client 11.0]Client unable to establish connection\n"}

       

      Tabprotosrv logs:

      {"ts":"2018-01-24T21:23:02.029","pid":117912,"tid":"22394","sev":"warn","req":"-","sess":"-","site":"{57446F43-E4F5-42B7-AE38-5545FFC4371B}","user":"-","k":"database-error","v":{"error-records":[{"error-desc":"[Microsoft][SQL Server Native Client 11.0]TCP Provider: An existing connection was forcibly closed by the remote host.\r\n","error-record":1,"native-error":10054,"sql-state":"08001","sql-state-desc":"SQLSTATE_CONNECTION_UNABLE_TO_CONNECT"},{"error-desc":"[Microsoft][SQL Server Native Client 11.0]Client unable to establish connection","error-record":2,"native-error":10054,"sql-state":"08001","sql-state-desc":"SQLSTATE_CONNECTION_UNABLE_TO_CONNECT"}],"file":"d:\\tc\\builds\\tableau-17-q1\\tableau-17-q1.17.0912.2119\\modules\\connectors\\tabmixins\\main\\db\\ODBCProtocolImpl.cpp","line":4835,"protocol":"46845d0","retcode":-1,"retcode-desc":"SQL_ERROR"},"ctx":{"client-type":"backgrounder","procid":"90652","requestID":"-","sessionid":"868D4F8EC62744BB9E8F18E76E08DA1D-2:10","tid":"42960","username":""}}

       

      DEV 64bit drivers

      "PSChildName","Driver","FVersion"

      "Aster ODBC Driver","C:\Program Files\Teradata Aster\Aster ODBC Driver (x64)\ASTERDATAODBCDSII.DLL",

      "CData ODBC Driver for SharePoint","d:\Program Files\CData\CData ODBC Driver for SharePoint\lib64\CData.ODBC.SharePoint.dll",

      "Composite 6.2","C:\windows\system32\composite62_x64.dll",

      "IBM DB2 ODBC DRIVER","C:\Program Files\IBM\SQLLIB_01\BIN\DB2CLIO.DLL",

      "IBM DB2 ODBC DRIVER - DB2COPY1","C:\PROGRA~1\IBM\SQLLIB\BIN\DB2CLIO.DLL",

      "IBM DB2 ODBC DRIVER - DB2COPY2","C:\PROGRA~1\IBM\SQLLIB~1\BIN\DB2CLIO.DLL",

      "Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "Microsoft Access Driver (*.mdb, *.accdb)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "Microsoft Access Text Driver (*.txt, *.csv)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "MySQL ODBC 5.3 ANSI Driver","C:\Program Files\MySQL\Connector ODBC 5.3\myodbc5a.dll",

      "MySQL ODBC 5.3 Unicode Driver","C:\Program Files\MySQL\Connector ODBC 5.3\myodbc5w.dll",

      "NB SQL Anywhere","C:\Program Files\VERITAS\NetBackupDB\Win64\dbodbc16.dll",

      "ODBC Driver 11 for SQL Server","C:\windows\system32\msodbcsql11.dll",

      "Oracle in OraClient11g_home1","d:\apps\oracle\product\11.2.0.4\client_x64\BIN\SQORA32.DLL",

      "PostgreSQL ANSI(x64)","C:\Program Files\Tableau\Drivers\psqlODBC\0906\bin\psqlodbc30a.dll",

      "PostgreSQL Unicode(x64)","C:\Program Files\Tableau\Drivers\psqlODBC\0906\bin\psqlodbc35w.dll",

      "SAS","C:\Program Files\SASHome2\SASDriversforODBC\9.43\sasdrv32.dll",

      "Splunk ODBC Driver","C:\Program Files\Splunk ODBC Driver\lib\SplunkDSII.dll",

      "SQL Server","C:\windows\system32\SQLSRV32.dll",

      "SQL Server Native Client 10.0","C:\windows\system32\sqlncli10.dll",

      "SQL Server Native Client 11.0","C:\windows\system32\sqlncli11.dll",

      "Teradata","C:\Program Files\Teradata\Client\15.10\bin\tdata32.dll",

       

      dev.jpg

       

      PROD 64bit DRIVERS

      "PSChildName","Driver","FVersion"

      "Aster ODBC Driver","D:\apps\Teradata Aster\ODBC64\ASTERDATAODBCDSII.DLL",

      "CData ODBC Driver for SharePoint","d:\Program Files\CData\CData ODBC Driver for SharePoint\lib64\CData.ODBC.SharePoint.dll",

      "IBM DB2 ODBC DRIVER","D:\apps\IBM\SQLLIB_64\BIN\DB2CLIO.DLL",

      "IBM DB2 ODBC DRIVER - DB2_64","D:\apps\IBM\SQLLIB~1\BIN\DB2CLIO.DLL",

      "Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "Microsoft Access Driver (*.mdb, *.accdb)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "Microsoft Access Text Driver (*.txt, *.csv)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)","C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEODBC.DLL",

      "MySQL ODBC 5.3 ANSI Driver","D:\apps\MySQL\Connector ODBC 5.3\myodbc5a.dll",

      "MySQL ODBC 5.3 Unicode Driver","D:\apps\MySQL\Connector ODBC 5.3\myodbc5w.dll",

      "NB SQL Anywhere","C:\Program Files\VERITAS\NetBackupDB\Win64\dbodbc16.dll",

      "ODBC Driver 11 for SQL Server","C:\windows\system32\msodbcsql11.dll",

      "Oracle in OraClient11g_home1","d:\apps\oracle\product\11.2.0.4\client_x64\BIN\SQORA32.DLL",

      "PostgreSQL ANSI(x64)","C:\Program Files\Tableau\Drivers\psqlODBC\0906\bin\psqlodbc30a.dll",

      "PostgreSQL Unicode(x64)","C:\Program Files\Tableau\Drivers\psqlODBC\0906\bin\psqlodbc35w.dll",

      "Splunk ODBC Driver","D:\apps\Splunk ODBC Driver64\lib\SplunkDSII.dll",

      "SQL Anywhere 12","D:\apps\SQLANY~1\Bin64\dbodbc12.dll",

      "SQL Server","C:\windows\system32\SQLSRV32.dll",

      "SQL Server Native Client 10.0","C:\windows\system32\sqlncli10.dll",

      "SQL Server Native Client 11.0","C:\windows\system32\sqlncli11.dll",

      "Teradata","C:\Program Files\Teradata\Client\15.10\bin\tdata32.dll",

       

      prod.jpg

       

      Refresh from desktop is fine. What do you think?

       

      Thanks!

       

      John