Describe the bug
While using Authentication method as Interactive it is expecting UId in connection string. And even after providing Uid it is unable to authenticate.
Error which you get
RuntimeError: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user ''.
Expected behavior
While using Interactive, UId should be an optional parameter.
Further technical details
Python version: 3.13.5
SQL Server version: SQL Server 2022
Operating system: Windows Server 2022
Bug Fix:
We have encountered this issue and found the fix as well, for this.
Below is the PR for the same.
#142