KNOWLEDGE BASE

"Login timeout expired" Error When Refreshing Extract


Published: 14 Aug 2013
Last Modified Date: 06 Jun 2016

Issue

When you try to refresh an extract, one of the following errors might occur:

com.tableausoftware.nativeapi.dll.DataSourceException: SQL Server database error 0x80004005: Login timeout expired
SQL Server database error 0x80004005: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

SQL Server database error 0x80004005: Named Pipes Provider: Could not open a connection to SQL Server [53].
Unable to connect to the server "ServerName". Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Server
  • Tableau Desktop
  • SQL Server

Resolution

Work with the SQL Server database administrator to troubleshoot network connection issues.

The following is a list of suggestions that could aid in troubleshooting the issue:
  • If the computer running Microsoft SQL Server uses the Named Pipes client protocol, configure Microsoft SQL Server to use TCP/IP instead.
  • On the computer running Tableau Server, signed in as Administrator, ensure that you can connect to the SQL Server database from Microsoft Excel or SQL Server Management Studio. If the connection is successful, make sure you are using the same connection parameters and credentials in the SQL Server data connection dialogue in Tableau Server or Tableau Desktop.
  • If the computer running SQL Server and the computer running Tableau Server are joined to different domains and SQL Server is using Active Directory authentication, create a local SQL Server user and then use the local SQL Server user credentials to connect to SQL Server via Tableau Server.

Cause

This issue originates from the SQL Server database, not from Tableau Server, and is caused by network communication issues with SQL Server. The error can occur for a variety of reasons, including but not limited to the following: 
  • The named pipes configuration frequently leads to dropped packets without notification, preventing Tableau Server from connecting to the computer running SQL Server.
  • If the computer running SQL Server and the computer running Tableau Server are joined to different domains and SQL Server is using Active Directory authentication, accessing the computer running SQL Server remotely (for example, via Remote Desktop) may cause issues.
  • The connection parameters and credentials entered into the SQL Server data connection dialog are incorrect.

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?