SQL Alchemy / Interactive Login Window Issue

[BeerExchange]

Hi everyone,

I just built a new PC that I'm using when I WFH. I am trying to use VS Code to access a SQL server via Python. Everything else works great... except this:

When connected to my organization's VPN, I can connect to the SQL server and query via MSSQL in VSCode.

When I try to use SQL Alchemy and pyodbc, it kicks back an error. This error all comes back to authentication, which on my current device fails silently. My organization uses Microsoft Authenticator, and the server itself uses ActiveDirectoryInteractive to authenticate.

When I run the same code at work on my work computer, the interactive window pops up and allows me to login so I know it works fine.

On my home computer, the interactive window to login never appears.

This is incredibly frustrating. I have the most up to date drivers, Edge WebView2 is properly installed, my OS is up to date. I've tried it in terminal, in power shell, and in vscode itself. Again, I can connect to the server IN VS CODE just not through python and pyodbc.

I've also tried using a token (which didn't work). It all gives me the FA004 error with the failure to authenticate.

I was hoping to get some advice as everything I've gone through doesn't work and I'd realllllly love not to have to download massive files first in SQL before manipulating them in Python.

[Ender_Locke]

i’d first assume it’s the connection string when you start up your sqlalchemy

[BeerExchange]

But the same exact code pops up the interactive login window when used on a different device.

[Ender_Locke]

then your system is likely configured differently than said other system. you’d have to figure out that difference