Support all auth options using bulk copy

[MeinAccount]

Describe the bug

Using Authentication=ActiveDirectoryServicePrincipal causes bulkcopy to carsh with RuntimeError: Failed to connect to SQL Server: Connection Error: Authentication method 'ActiveDirectoryServicePrincipal' is not supported. No token provider was registered for this method.

The docs to not mention supported auth options.

Further technical details

Python version: Python 3.12.9
SQL Server version: Azure SQL
Library Version: 1.5.0

[MeinAccount]

Using the trick from #127 also doesn't work: RuntimeError: Failed to connect to SQL Server: Sql Error: 18456: Class 14: State 1: Login failed for user ''. on Unknown in Unknown at line 0

[github-actions]

Hi @MeinAccount, thank you for opening this issue!

Our team will review it shortly. We aim to triage all new issues within 24-48 hours and get back to you.

If you have additional information to share, please feel free to update the issue.

Thank you for your patience!

[saurabh500]

@bewithgaurav what are you thinking? Take the token and pass it to mssql-py-core with the Access token API ?

[bewithgaurav]

@MeinAccount - thanks for raising this issue - this is a bug on token collection logic, and the PR is under development, we'll post more updates as we go.

@saurabh500 - yes same lines, this is happening due to missed auth cases in token acquistion path.

[nspcc-tv]

I have the same issue. Could you update with possible fix & ETA please?

[MeinAccount]

Bump @bewithgaurav . Can you give us an estimate for our planning?

[bewithgaurav]

@MeinAccount @nspcc-tv - Thanks for your patience, we're in process of developing the PRs for this since the changes are extending to the TDS auth internals as well.
As of now the bulkcopy path supports ActiveDirectoryDefault, ActiveDirectoryDeviceCode & ActiveDirectoryInteractive for EntraID auth.
We're planning to add ActiveDirectoryMSI by v1.8.0 (release date 28/05)
We will add an estimation update on the other auth options - esp. ServicePrincipal by the end of this week
Thanks again for your continued patience, we will update the wikis & docs shortly.