pymssql._mssql.MSSQLDatabaseException: (18452, b'Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.DB-Lib error message 20018, severity 14:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (servername.domainname.local)\nDB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (servername.domainname.local)\n')

I'm trying to run my MSSQL tap in my docker container locally (with dagster) and I'm getting this error. It's saying the login is from an untrusted domain, however the pipeline runs fine when I invoke it on my CLI. I use a VPN to connect to that server whenever I do dev testing so maybe that has something to do with it and maybe MSSQL can see my credentials when I'm not running the job in a container but it does when I invoke the command from the CLI? Any ideas?

Integrated auth is almost always windows auth (I think it's via NTLM) so are you running on a sql box in production? One solution is to run via a windows container with windows auth but that takes some hoops. The easiest fix is probably just make a sql account that's not integrated auth and just auth with that. Windows auth is better from a security perspective (arguably, but both can be secure)

So is integrated auth set up on the SQL Server side? A different team handles the admin for that server so they set up the service account and I didn't have visibility. That makes sense though

well my guess is the setup you're using is trying to auth with integrated auth so it's not really from the server side. Not sure if that's important, would need more context

By setup do you mean how I have my tap setup in my meltano project?

all of the above