KNOWLEDGE BASE

Live Connections and Extract Refreshes to MS SQL Server Fail When using Non-Default Ports After Migration to AWS


Published: 26 Jul 2018
Last Modified Date: 27 Jul 2018

Issue

When publishing live connections, connecting live, or refreshing extracts using non-default ports after the migration to AWS, the below connection errors may occur: 
 
Tableau Online can't connect to the following database or publish with a live connection: [database name] 

Or
 
[unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist
[unixODBC][FreeTDS][SQL Server]Unable to connect to data source

Environment

  • Tableau Online 10ay, 10az 
  • Live Connections 
  • MS SQL Server 

Resolution

To continue using non-default ports, use the <server name>, <port number> format. See Microsoft SQL Server for more information.

For any existing published workbooks or data sources using the <server name>\<database>, <port number> syntax, you may be able to update them directly using the "Edit Connection" option in Tableau Online. See Edit Connections on Tableau Online for more information. 
Did this article resolve the issue?