can not log into sql server using domain account

[yxl1108]

OS: WSL2 / Ubuntu 20.04.6 LTS (Focal Fossa) Driver: Microsoft ODBC Driver 18 for SQL Server

Installation: curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - curl https://packages.microsoft.com/config/debian/11/prod.list > /etc/apt/sources.list.d/mssql-release.list apt-get update ACCEPT_EULA=Y apt-get install -y msodbcsql18 apt-get install -y unixodbc-dev gnupg libkrb5-dev pkg-config

dbt profile.yml: local: type: sqlserver driver: 'ODBC Driver 18 for SQL Server' server: sql-server-instance.domain.com port: 1433 trust_cert: true database: database_name schema: dbo authentication: ActiveDirectoryPassword user: 'DOMAIN\username' password: 'password' threads: 4

Error: with authentication: ActiveDirectoryPassword

Database Error ('28000', "[28000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user ''. (18456) (SQLDriverConnect)")

without authentication: ActiveDirectoryPassword

Database Error ('28000', "[28000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user 'DOMAIN\\username'. (18456) (SQLDriverConnect)")

Observations: sql server authentication works fine

[NicolasPA]

If it can help, this is what we're using to connect with the Windows user of the current session.

dbt-transform:
  target: local
  outputs:
    local:
      type: sqlserver
      driver: 'ODBC Driver 17 for SQL Server'
      server: my_server\name
      port: 1433
      trusted_connection: True
      encrypt: False
      threads: 2
      database: my_db
      schema: my_local_schema

[yxl1108]

I see you use trusted_connection here. doesn't this imply it's running on domain joined windows hosts? I am running dbt for sql server on ubuntu, which is not domain joined.

[NicolasPA]

Yes, it's all Windows.

[romiof]

@yxl1108 as far I know, you need to login with a SQL Account.

AD Accounts, can only login to a SQL Server using Trusted Connection when you had logged with the same account at your machine.

At my setup, I have a dedicated SQL Account for dbt jobs.