KNOWLEDGE BASE

Error "Named Pipes Provider: The specified network name is no longer available" Creating Extract


Published: 14 Apr 2014
Last Modified Date: 27 Aug 2015

Issue

When creating a large extract, the one of the following errors might occur:
 
SQL Server database error 0x80004005: Protocol error in TDS stream
SQL Server database error 0x80004005: Communication link failure
SQL Server daabase error 0x80004005: Named Pipes Provider: The specified network name is no longer available

Unable to create extract

 
Or:

[Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: The specified network name is no longer available.
[Microsoft][SQL Server Native Client 10.0]Communication link failure

Environment

  • Tableau Desktop
  • Microsoft SQL Server

Resolution

This error is not specific to Tableau, and it has no single resolution. The following is a list of troubleshooting steps.
 
Work with your database administrator to do the following:
  • Pull the query from the Tableau Desktop log files, and run the query in the database using a different program. For more information about pulling the query, see Viewing Underlying SQL Queries.
  • If the query fails, work with your database administrator to determine why the extract is failing. If the query runs successfully, contact Tableau Support for further troubleshooting.

Additional Information

For information about the differences between using TCP/IP and Named Pipes in Microsoft SQL Server, see Named Pipes vs. TCP/IP Sockets topic on MSDN.
Did this article resolve the issue?