Loading

Error "Unable to connect" using MS SQL Server and Tableau Server on Linux

Publiceringsdatum: Feb 26, 2025
Beskrivning
When connecting to live MS SQL data sources using the FreeTDS driver provided by Tableau for Tableau Server on Linux, the following error may occur:

“[unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist
[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”

Cause

The FreeTDS driver is not able to connect to the MS SQL Server because port 1433 is not open and accepting TCP connections.
Lösning
Configure the MS SQL Server computer to accept TCP connections over port 1433.
If a different port then 1433 is used, connect with server: Server, port
Ytterligare resurser
For more information about this topic, see Configure the Windows Firewall to Allow SQL Server Access in the Microsoft Knowledge Base. 
Knowledge-artikelnummer

001472853

 
Laddar
Salesforce Help | Article