Skip to main content
Topics#DescriptionVasif Rasulov's Question
Vasif Rasulov asked in #Description
Jan 17, 2024, 5:36 AM

Hi, How to manage this? (Tableau Server Version: 2023.1.6 /Ubuntu 20.04. LTS / msodbcsql17 and mssql tool installed ) Datasource created by Tableau Desktop and published to Tableau Server. Entering db sql login and pwd, but unable to connect

Hi, How to manage this? (Tableau Server Version: 2023.1.6 /Ubuntu 20.04. LTS / msodbcsql17 and mssql tool installed ) Datasource created by Tableau Desktop and published to Tableau Server. Entering db sql login and pwd, but unable to connecttableau1

9 answers
  1. Vasif Rasulov
    Jan 20, 2024, 7:57 PM

    Solution>

    Centos 7.9 Tableau Server 2023.3-1 tableau-freetds-1.00.40-1.x86_64.rpm

    odbcinst.ini

    [ODBC Drivers]

    FreeTDS=Installed

    ⌗[ODBC Driver 17 for SQL Server]

    #Description=Microsoft ODBC Driver 17 for SQL Server

    ⌗Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.5.1

    ⌗UsageCount=1

    [FreeTDS]

    Description=FreeTDS for Microsoft SQL Server

    Driver=/opt/tableau/tableau_driver/freetds/lib/libtdsodbc.so

    FileUsage=1

     

    freetds.conf

    # A typical Microsoft server

    [egServer70]

    host = ntmachine.domain.com

    port = 1433

    tds version = 7.4

Write an answer...
0/9000