You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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
The text was updated successfully, but these errors were encountered: