KNOWLEDGE BASE

Error "Server name cannot be determined" Connecting to SQL Server From Tableau Desktop


Published: 31 Mar 2016
Last Modified Date: 06 Oct 2017

Issue

When attempting to connect to a SQL data source in Tableau Desktop, the following error occurs:

[Microsoft][SQL Server Native Client 10.0][SQL Server] Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.

Environment

  • Tableau Desktop
  • Windows 8
  • MS SQL Server

Resolution

Log in using username@servername rather than simply username.

Cause

The database is configured to require the format username@servername when logging in. 
This behavior is due to the database configuration and not specific to Tableau Desktop.
Did this article resolve the issue?